Excel™ Dashboards Assessment Form

Excel™ Dashboards Assessment Form

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

Computer Knowledge

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

How can we reach you?