BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Brainwork Resources - ECPv6.16.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Brainwork Resources
X-ORIGINAL-URL:https://brainwork-resources.com
X-WR-CALDESC:Events for Brainwork Resources
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260203T080000
DTEND;TZID=UTC:20260204T170000
DTSTAMP:20260602T011615
CREATED:20251207T054235Z
LAST-MODIFIED:20251207T054235Z
UID:1429-1770105600-1770224400@brainwork-resources.com
SUMMARY:MS Excel : Intermediate - Advanced
DESCRIPTION:INTRODUCTION \nThis comprehensive one-day training program is designed to build upon your existing Excel knowledge and take your skills to the next level. Throughout the day\, we will dive into intermediate-level concepts and techniques that will empower you to manipulate data\, perform advanced calculations\, and create visually appealing reports and analyses. \nThis training is specifically tailored for individuals who are familiar with the basics of Excel and are eager to expand their proficiency in this powerful spreadsheet software. Whether you’re a business professional\, analyst\, student\, or anyone who works with data\, this training will equip you with the necessary tools and techniques to work more efficiently and effectively in Excel. \nWe have carefully structured the training agenda to cover a wide range of topics\, including data manipulation and analysis\, formulas and functions\, advanced formatting techniques\, data analysis tools\, data validation\, and collaboration features. By the end of the day\, you will have gained valuable skills and knowledge that can be immediately applied to your everyday work tasks. \nThroughout the training\, we encourage active participation\, as you will have opportunities to practice the concepts through hands-on exercises and engage in discussions. Additionally\, we will provide you with valuable resources and references to support your continued learning beyond this training. \n  \nCOURSE OBJECTIVES \nEnhanced Spreadsheet Proficiency \nParticipants will gain fundamental skills in Excel\, enabling them to navigate the interface\, enter data\, and perform basic calculations. This proficiency forms the basis for more advanced Excel usage in professional settings. \nImproved Data Accuracy \nUnderstanding basic formulas and functions equips participants with the ability to perform accurate calculations\, reducing the risk of errors in their work. \nEfficient Data Management \nParticipants will learn data sorting\, filtering\, and manipulation techniques\, allowing them to organize and manage data effectively. This skill is crucial for tasks involving large datasets. \nVisual Data Representation \nThrough the creation and customization of charts and graphs\, participants will learn how to visually represent data. This skill aids in making data-driven decisions and conveying information effectively to others. \nTime-saving Techniques \nKnowledge of shortcuts and efficient formula copying methods enhances productivity\, enabling participants to accomplish tasks in less time. \n  \nCOURSE CONTENT \nDAY 1 : INTERMEDIATE EXCEL SKILLS AND TECHNIQUES \nTEMPLATES \n\nUsing templates\nCreating Excel templates\n\nPASTE SPECIAL OPTIONS \n\nUsing Paste Special to add\, subtract\, multiply & divide\nUsing Paste Special ‘values’.\nUsing Paste Special transpose option\n\nPIVOT TABLES \n\nUsing a Pivot\nFiltering and Sorting Data\nGrouping Data\nCreating and using a pivot\nFiltering and sorting data within a pivot\nAutomatically grouping data in a pivot table and renaming\nManually grouping data in a pivot table and renaming\n\nINPUT TABLES \n\nOne-input data\nTwo-input data\n\nSTATISTICAL FUNCTIONS \n\nCOUNT\nCOUNTA\nCOUNTIF\nCOUNTBLANK\n\n  \nDAY 2 : ADVANCED EXCEL SKILLS AND TECHNIQUES \nTRACKING & REVIEWING CHANGES \n\nEnabling or disabling the ‘track changes’\nSharing\, comparing and merging\n\nSCENARIOS \n\nScenario\nScenario summary\n\nFINANCIAL FUNCTIONS \n\nFV\nPV\nNPV\nRATE\nPMT\n\nLOOKUP FUNCTIONS \n\nVLOOKUP\nHLOOKUP\nXLOOKUP\n\nDATABASE FUNCTIONS \n\nDSUM\nDMIN\nDMAX\nDCOUNT\nDAVERAGE\n\nMACROS \n\nUsing Macros\nAssigning a Macro to a Button on the Quick Access Toolbar\nDeleting Macros\n\n  \nMETHODOLOGY \nAn adult learning approach using a combination of lectures and simulation\, exercises\, hands-on with close supervision by the trainers\, presentation\, management games & group discussions \n  \nWHO SHOULD ATTEND? \nOpen to all \n  \n  \nTRAINER (either one of them) \nFakhrul Syahmi (either one of them) \nHazry Hidzir \nShamsiyah Abd Kadir \nSuhaily Georga Abdullah \nAdila Diyana Erwan \nKamil Rohman \n  \nFEES (WITHOUT ACCOMODATION) \nRM1\,100.00 per pax \nEarly Bird RM1\,000.00 per pax \n(20 days before program) \n2 pax RM 1\,050.00 per pax \n3 pax > RM1\,000.00 per pax \n(This fees is inclusive of 2 morning tea breaks\, 2 lunch \, 2 afternoon tea breaks\, notes and certificate of attendance for the participants)
URL:https://brainwork-resources.com/event/ms-excel-intermediate-advanced/
END:VEVENT
END:VCALENDAR