Excel Advanced Dashboard & Reports Masterclass

Course Content

Modules Status
1

1 - Introduction - What You Will Learn In This Course

2

2 - Application & Feature Walk Through

3

3 - Setting Up For Speed, Safety & Security

4

4- Principals For Simple Yet Powerful Report Dashboards

5

5 - Designing Your Dashboard To Wow Your Users

6

6 - VBA Principals To Ensure Project Success

7

7 - Using Shapes & Icons For Eye-Popping Dashboards

8

8 - Create Beautiful Reports & Speed Up Your Application With These Conditional Formatting Tricks

9

9 - Your Comprehensive Guide To Named Ranges

10

10 - Three Proven Ways To Locate Records

11

11 - Create A Powerful Date Range Feature For ANY Dashboard

12

12 - Loading, Clearing and Updating Reports in VBA

13

13 - Groundbreaking Custom Reports Feature

14

14 - Create Your Own Toggle Columns Feature

15

15 - Create A Dynamic Sales By Customer Report

16

16 - How To Master In-Cell Filtering On ANY Table

17

17 - How To Create This Amazing Single Click Table Sorting In Any Table

18

18 - Generate Reports, Graphs & Charts With This Sales By Month Training

19

19 - Create This Stunning One Click Graphs Display

20

20 - How To Create This Powerful Profit & Loss Statement With Drill Down Data

21

21 - How To Create A Dynamic Pop-up Picture In ANY Report

22

22 - Allow Your Users To Create Their OWN Custom Reports

23

23 - How To Add This Incredible & Dynamic Toolbar To ANY Dashboard

24

24 - Adding Additional Protections To Protect You, Your Users & Your Application

25

25 - Course & Application Summary & Closing