Call Me
Advanced Excel
 

Duration: 20 Hours

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)