BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Brainwork Resources - ECPv6.16.3//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20260112T080000
DTEND;TZID=UTC:20260113T170000
DTSTAMP:20260601T232847
CREATED:20251207T053045Z
LAST-MODIFIED:20251207T053045Z
UID:1417-1768204800-1768323600@brainwork-resources.com
SUMMARY:MS Excel : Basic - Intermediate
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 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  \nLEARNING OUTCOME \nAPPLY DATA MANIPULATION TECHNIQUES: \n\nSort and filter data\nUtilize advanced filtering options for complex data\nWork effectively with tables and structured\nImplement conditional formatting to highlight data\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\n\nIMPLEMENT ADVANCED FORMATTING TECHNIQUES: \n\nCustomize cell formatting to enhance visual\nApply styles and themes for consistent\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\nApply What-If Analysis tools (Goal Seek\, Scenario Manager) for  decision-making.\n\n  \nCOURSE CONTENTS  \nMODULE 1 : INTRODUCTION TO EXCEL\n\nOverview of Microsoft Excel interface\nUnderstanding the ribbon\, tabs\, and menus\nExplanation of basic Excel terminology (workbook\, worksheet\, cell\, rows\, columns)\nCreating a new workbook and saving it\n\nMODULE 2 : DATA ENTRY AND FORMATTING\n\nEntering data into cells (text\, numbers\, dates)\nFormatting cells (font\, alignment\, borders\, fill color)\nUsing basic formatting tools (bold\, italic\, underline)\nIntroduction to cell styles for quick formatting\n\nMODULE 3 : BASIC FORMULAS AND FUNCIONS\n\nUnderstanding formulas and calculations in Excel\nBasic arithmetic operations (+\, -\, *\, /)\nIntroduction to functions (SUM\, AVERAGE\, COUNT)\nUsing AutoSum for quick calculations\nCopying formulas and functions across cells\n\nMODULE 4 : DATA MANIPULATION\n\nSorting data in Excel (ascending\, descending)\nFiltering data using AutoFilter and advanced filter options Using\nFind and Replace feature\nIntroduction to conditional formatting based on cell values\n\nMODULE 5 : CHARTS AND GRAPHS\n\nCreating different types of charts (bar\, line\, pie)\nFormatting charts (titles\, labels\, legends)\nUsing chart templates for quick visualization\nAdding data labels and annotations to charts\n\nMODULE 6 : INTRODUCTION TO DATA ANALYSIS TOOLS\n\nUsing Data Tables for what-if analysis\nIntroduction to PivotTables and PivotCharts\nCreating basic PivotTables to analyze data\nUsing slicers for interactive filtering in PivotTables\nIntroduction to Excel’s built-in data analysis tools (Goal Seek\, Solver)\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  \nTRAINER (either one of them) \nFakhrul Syahmi \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-intermediate/
LOCATION:Kuala Lumpur/Selangor\, Malaysia
END:VEVENT
END:VCALENDAR