Excel PLUS

According to Microsoft Office Live Director of Marketing Michael Schultz, "roughly half a billion people use MS Office", making Excel the world’s most popular spreadsheet application by a mile. Useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards, a training in Excel helps every single office-goer. Our course design emphasizes on using Excel for building dashboards and reports using its own functionalities as well as VBA –built macros.

Excel Course Contents

o Introducing Excel - Navigating Worksheets, Formatting and Editing Worksheet Data, Grouping Data, Subtotals and data Validation

o Working with Formulas and Functions - Date and Time Functions, Referencing Functions, Text Manipulating Functions and Array Formulas o Creating Charts and Graphics

o Analyzing Data with Excel - Consolidating Worksheets, Using Pivot Tables and What-If Analysis

o Using Advanced Excel Features - Recording and Running Macros, Introduction to VBA, Conditional and Looping Statements, User Defined Functions, ActiveX Controls and User Forms