Can you understand the use of Excel™ to an advanced level

Can you create Workbooks

Can you open existing files, save and navigate to workbooks/spreadsheets

Do you understand the Ribbon, shortcut keys & contextual tabs

Do you know how to format using the ribbon, mini-tool bar & Painter

Do you know what a Dashboard is

Do you understand what you would use a Dashboard for

Do you know where the sources of your data are located

Do you know how to use Microsoft Access™ to connect data sources

Do you know how to use Excel’s tools

Do you understand what Excel tools are useful to use with Dashboards

Do you know how to use conditional formatting

Do you understand data validation

Do you understand how to create data tables in Excel

Do you know how to use links

Do you know what a Dashboard toolbox is

Can you use named cells and ranges

Do you use the name manager

Do you know IFS Sisters, INDEX & MATCH, LARGE & SMALL

Do you know CHOOSE over IF but not over IFS

Have you used GETPIVOTDATA

Have you used INDIRECT

Do You know when to use PIE and not to use PIE Charts

Have you used Enhanced Bar Charts

Have you added Dynamic Vertical Group Bars

Have you created or used Dynamic Chart Ranges

Have you used or created Gantt Charts

Have you used Dynamic Excel Maps

Have you created Pivot Tables & Pivot Charts

Have you created form controls before

Have you used Interactive Dashboards using Form Controls

Do you understand the reasons to use content controls

Have you created a Dashboard before

I am comfortable using a keyboard and mouse

I know how to download an app

I know how to test my microphone and camera

I have used Zoom before