Learn Excel by Building Dashboards and Calculators

Course Objectives

• Understand and apply the basic functions associated with dashboards and calculators.
• Understand and apply the variety of tools in Excel in conjunction with the various functions
• Building dashboards by using Pivot tables and slicers

Target Audience

• Anyone that uses Excel and want to learn more about dashboards and the relevant tools that assist in creating eye catching dashboards and calculators

Course Modules

MODULE 1 – INTRODUCTION
MODULE 2 – SHORTCUTS & NAVIGATION
MODULE 3 – FUNDAMENTAL FUNCTIONS FOR BUILDING DASHBOARDS
MODULE 4 – Function Exercises
MODULE 5 – Building Calculators
MODULE 6 – VISUAL TOOLS
MODULE 7 – DEVELOPER TOOL EXERCISES
MODULE 8 – CREATING DYNAMIC CHARTS
MODULE 9 – CREATING YOUR DYNAMIC DASHBOARD
MODULE 10 – PIVOT TABLES, TABLES & SLICERS DASHBOARDS
MODULE 11 – PIVOT AND SLICER DASHBOARD