Excel™ Dashboards Assessment Form Excel™ Dashboards Assessment Form Can you understand the use of Excel™ to an advanced level Yes No Not Sure Can you create Workbooks Yes No Not Sure Can you open existing files, save and navigate to workbooks/spreadsheets Yes No Not Sure Do you understand the Ribbon, shortcut keys & contextual tabs Yes No Not Sure Do you know how to format using the ribbon, mini-tool bar & Painter Yes No Not Sure Do you know what a Dashboard is Yes No Not Sure Do you understand what you would use a Dashboard for Yes No Not Sure Do you know where the sources of your data are located Yes No Not Sure Do you know how to use Microsoft Access™ to connect data sources Yes No Not Sure Do you know how to use Excel’s tools Yes No Not Sure Do you understand what Excel tools are useful to use with Dashboards Yes No Not Sure Do you know how to use conditional formatting Yes No Not Sure Do you understand data validation Yes No Not Sure Do you understand how to create data tables in Excel Yes No Not Sure Do you know how to use links Yes No Not Sure Do you know what a Dashboard toolbox is Yes No Not Sure Can you use named cells and ranges Yes No Not Sure Do you use the name manager Yes No Not Sure Do you know IFS Sisters, INDEX & MATCH, LARGE & SMALL Yes No Not Sure Do you know CHOOSE over IF but not over IFS Yes No Not Sure Have you used GETPIVOTDATA Yes No Not Sure Have you used INDIRECT Yes No Not Sure Do You know when to use PIE and not to use PIE Charts Yes No Not Sure Have you used Enhanced Bar Charts Yes No Not Sure Have you added Dynamic Vertical Group Bars Yes No Not Sure Have you created or used Dynamic Chart Ranges Yes No Not Sure Have you used or created Gantt Charts Yes No Not Sure Have you used Dynamic Excel Maps Yes No Not Sure Have you created Pivot Tables & Pivot Charts Yes No Not Sure Have you created form controls before Yes No Not Sure Have you used Interactive Dashboards using Form Controls Yes No Not Sure Do you understand the reasons to use content controls Yes No Not Sure Have you created a Dashboard before Yes No Not Sure Computer Knowledge I am comfortable using a keyboard and mouse Yes No Not Sure I know how to download an app Yes No Not Sure I know how to test my microphone and camera Yes No Not Sure I have used Zoom before Yes No Not Sure How can we reach you? Email Address * Phone Number reCAPTCHA If you are human, leave this field blank. Submit Assessment Δ