Advanced Excel Course

Dashboard reports provide Managers with information regarding the key performance indicators of the business at a glance. Excel along with VBA is a powerful tool to create these dashboards that provide analysis and insights in a timely manner.

Course Modules

• Working with Controls

• Command Button, Text Box and Label, Combo Box, User Forms, Scroll Bar and Check Box

• Create a simple calculator dashboard.

• Functions like VLOOKUP,HLOOKUP,INDEX,MATCH,OFFSET,SUBTOTAL

• Using the above functions to make simple parts of a dashboard.

• Using Pivot Table to make simple dashboard.

• Dynamic Charts, Rolling Charts, Formatting Charts, Format as Table, Naming a Range

• Introduction to VBA

•  

  • Programming Language, VBA, OOP, Objects,

    • Data Types, Variables, Procedures & Operators

• Recording a Macro and Editing the Macro

• User-Defined Functions

• Control Statements

  • If Then

  • For Next

  • Do Loops

• Error Handling and Debugging

• Worksheet and Workbook Events

• ActiveX Controls

•  

  • User form Data Entry Form

  • Data entry with simple dashboard

• Connecting Excel to Outlook & PowerPoint(Requires strong VBA skills)