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:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230731
DTEND;VALUE=DATE:20230802
DTSTAMP:20260601T182412
CREATED:20230103T130949Z
LAST-MODIFIED:20230103T131012Z
UID:1318-1690761600-1690934399@brainwork-resources.com
SUMMARY:Microsoft Excel - Intermediate
DESCRIPTION:INTRODUCTION \nWhether you need to crunch numbers for sales\, inventory\, information technology\, human resources\, or other organizational purposes and departments\, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all\, the world runs on data more than ever before and that’s a trend not likely to change\, or even slow down\, any time soon. But with so much data available and being created on a nearly constant basis\, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read\, interpret\, and present to others. But\, Excel is capable of doing so much more. To gain a truly competitive edge\, you need to be able to extract actionable organizational intelligence from your raw data. In other words\, when you have questions about your data\, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. \nThis course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data\, extract actionable information from it\, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. \n  \nOBJECTIVES \nUpon successful completion of this course\, participants will be able to : \n\nWork with Functions\nWork with Lists\nAnalyze Data\nVisualize Data with Charts.\nCreate advanced formulas.\nAnalyze Data with PivotTables and PivotCharts.\n\n  \n  \nCOURSE CONTENTS \nMODULE 1: CREATING ADVANCED FORMULAS \n\nApply Range Names\nUse Specialized Functions\nExcel If\, Sumif\, Averageif\, Countif\n\n  \nMODULE 2: ANALYZING DATA WITH LOGICAL AND LOOKUP FUNCTIONS  \n\nWhat Is Vlookup\nWhat Is Hlookup\nUsing Text Function\nUsing Date & Time Function\n\n  \nMODULE 3: ORGANIZING WORKSHEET DATA WITH TABLES            \n\nCreate And Modify Tables\nSort And Filter Data\nFiltering Data\n\n  \nMODULE 4: VISUALIZING DATA WITH CHARTS            \n\nCreate Charts\nModify and Format Charts\n\n  \nMODULE 5: ANALYZING DATA WITH PIVOT TABLES\, SLICERS\, AND PIVOT CHARTS \n\nCreate A Pivot table\nFilter Data By Using Slicers\nSlicers\nAnalyze Data By Using Pivotcharts\nPivot charts\n\n  \nMODULE 6: INSERTING GRAPHICS           \n\nInsert And Modify Graphics Objects\nLayer And Group Graphic Objects\nIncorporate Smartart\nInsert Picture Into A Cell In Excel\n\n  \nMODULE 7: ENHANCING WORKBOOKS   \n\nProtect Files\n\n  \nWHO SHOULD ATTEND?\nThis course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data. \n  \nFEES \nINDIVIDUAL RM1\,000.00 per pax \nEARLY BIRD RM800.00 per pax \n(payment 14 days before the program) \n2 PAX  RM900.00 per pax \n3 PAX or  > RM850.00 per pax \n(Fees – without accommodation) \n  \nTRAINER \nShamsiyah Abd Kadir \nKelvin Ng Choo Kent
URL:https://brainwork-resources.com/event/microsoft-excel-intermediate/
LOCATION:Kuala Lumpur/Selangor\, Malaysia
END:VEVENT
END:VCALENDAR