BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Brainwork Resources - ECPv6.16.5.1//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:20260708T080000
DTEND;TZID=UTC:20260709T170000
DTSTAMP:20251209T102148Z
CREATED:20251209T102148Z
LAST-MODIFIED:20251209T102148Z
UID:1502-1783497600-1783616400@brainwork-resources.com
SUMMARY:MS Excel : Basic - Advanced
DESCRIPTION:INTRODUCTION \nThis comprehensive 2 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 \nthrough 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  \n  \nLEARNING OUTCOMES \nApply advanced data manipulation techniques:\n\nSort and filter data efficiently.\nUtilize advanced filtering options for complex data\nWork effectively with tables and structured references.\nImplement conditional formatting to highlight data patterns.\n\nDemonstrate proficiency in using formulas and functions:\n\nUtilize intermediate-level functions such as IF\, VLOOKUP\, and\nApply logical functions (AND\, OR\, NOT) for complex\nNest functions to perform advanced calculations.\n\nImplement advanced formatting techniques:\n\nCustomize cell formatting to enhance visual\nApply styles and themes for consistent formatting.\nCreate and modify templates for efficient document creation.\nUtilize conditional formatting to visually represent data\n\nUtilize data analysis tools effectively:\n\nCreate and modify PivotTables and PivotCharts for data\nUse slicers and timelines to interactively analyze data.\nApply What-If Analysis tools (Goal Seek\, Scenario Manager) for decision-making.\n\n  \nCOURSE CONTENT \nMODULE 1 : INTRODUCTION TO EXCEL AND BASIC FUNCTIONS \n\nOverview of Excel interface and navigation\nEntering data and formatting cells\nBasic mathematical operations and formulas\nIntroduction to functions (e.g.\, SUM\, AVERAGE\, MAX\, MIN)\n\nMODULE 2 : WORKING WITH DATA \n\nSorting and filtering data\nUsing conditional formatting\nWorking with tables and ranges\nIntroduction to data validation\n\nMODULE 3 : MANAGING WORKSHEETS AND WORKBOOKS \n·         Creating\, renaming\, and deleting worksheets\n\nMoving and copying worksheets\nLinking data between worksheets\nProtecting worksheets and workbooks\n\nMODULE 4 : VISUALIZING DATA \n\nCreating basic charts (e.g.\, column\, bar\, line\, pie\nCustomizing charts (titles\, legends\, axes)\nAdding data labels and trendlines\nIntroduction to sparklines\n\nMODULE 5 : ADVANCED FORMULAS AND FUNCTIONS \n\nUsing logical functions (e.g.\, IF\, AND\, OR)\nWorking with text functions (e.g.\, CONCATENATE\, LEFT\, RIGHT)\nDate and time functions\nLookup and reference functions (e.g.\,VLOOKUP\,HLOOKUP\,INDEX\,MATCH)\n\nMODULE 6 : DATA ANALYSIS TOOLS \n\n Using filters and advanced filtering\nPivotTables and PivotCharts\nData analysis with scenarios\nGoal Seek and Solver\n\nMODULE 7 : ADVANCED DATA MANAGEMENT \n\nConsolidating data from multiple sources\nData validation techniques\nText-to-columns and splitting data\nRemoving duplicates and cleaning data\n\nMODULE 8 : ADVANCED CHARTING AND GRAPHICAL ELEMENTS \n\nAdvanced chart types (e.g.\, radar\, doughnut\, waterfall)\nFormatting and customizing charts\nAdding secondary axes and combination charts\nWorking with sparklines and slicer\n\nMODULE 9 : ADVANCED DATA ANALYSIS \n\n What-If Analysis (e.g.\, data tables\, scenarios)\nStatistical analysis using Excel functions\nRegression analysis and trendlines\nIntroduction to Power Query\n\nMODULE 10 : AUTOMATING TASKS WITH  MICROS \n\nRecording and running macros\nEditing and debugging macros\nAssigning macros to buttons and shortcuts\nIntroduction to VBA (Visual Basic for Applications)\n\nMODULE 11 : COLLABORATION AND DATA SHARING \n\nProtecting and sharing workbooks\nTracking changes and comments\nSharing workbooks via email and cloud storage\nIntroduction to Excel Online and co-authoring\n\nMODULE 12 : ADVANCED TIPS & TRICKS \n\nUsing keyboard shortcuts for productivity\nCustomizing the Excel environment\nTips for optimizing large datasets\nTroubleshooting common Excel issues\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  \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-basic-advanced/
LOCATION:Kuala Lumpur/Selangor\, Malaysia
END:VEVENT
END:VCALENDAR