The Introduction to Excel Dashboards exercise walks students through the creation of a dashboard in Excel, focusing on advanced data visualization and interactivity techniques. Students pay $14.95 for the exercise and are guided through a video with numbered steps.
The students are taught 34 different Excel concepts, including 3 features, 6 worksheet functions, 14 techniques, and 11 commands.
6 Features
- PivotTables
- PivotCharts
- Slicers
- Slicing Multiple PivotTables
- Filtering PivotTables
- Text Box
2 worksheet function
- IF Function
- CHAR Function
20 Commands
- Data | From Text
- Home | Align Right
- Home | Comma Style
- View | Gridlines
- Insert | PivotTable
- PivotTable Analyze | Options
- PivotTable Analyze | Insert Slicer
- Slicers | Report Connections
- Insert | Clustered Column Chart
- PivotChart Analyze | Field Buttons
- Home | Copy
- Home | Paste Special | Linked Picture
- Picture Format | Picture Border | Weight
- PivotChart Analyze | Move Chart
- Home | Cut
- Home | Paste
- Slicer | Quick Styles
- Slicer | Columns
- Table Design | Total Row
- Insert | Text Box
29 Techniques
- Importing comma-delimited files
- Setting query properties
- Enriching query results with formulas
- Navigating with Excel’s Name Box
- Adding fields to PivotTables
- Adjusting Column Widths
- Hiding gridlines on worksheets
- Editing PivotTable field names
- Enabling Automatic PivotTable Refresh
- Duplicating worksheets
- Creating a Top 5 PivotTable
- Creating Clustered Bar PivotChart
- Removing Field Buttons from PivotCharts
- Creating Pie PivotChart
- Renaming PivotTables
- Creating Dynamic PivotChart Titles
- Creating Linked Pictures
- Adding Borders to Pictures
- Assembling an Excel Dashboard
- Moving Charts
- Adding Borders to Charts
- Moving Slicers
- Formatting Slicers
- PivotTable Drill-Down
- Adding Total Rows to Excel Tables
- Inserting Text Boxes
- Enabling Data Callouts
- Setting Pie Chart Explosion Level
- Concatenating Text
Each student is assigned a unique 4-digit number known as their Spreadsheet ID for use during the exercise. This ID number is incorporated into the exercise and helps ensure that each student turns in their own work.
The students submit their work to us and we handle all of the grading. We give you three scores:
- Completion: This score indicates if the student attempted a given step.
- Accuracy: This score indicates carried out the step accurately.
- Combined: The average of the two Completion and Accuracy scores.
Within one week of an assignment’s due date we provide instructors with a spreadsheet showing all student results. Partial credit in our scoring is given if a student at least attempts a step. Instructors determine final credit for each student, and whether late submissions are allowed. Students receive written feedback confirming which steps were completed successfully, as well as providing guidance on steps that they did not attempt or did not complete correctly.
Some instructors give more weight to the Completion score than the Accuracy score, while other instructors use the combined average when determining credit. We’re happy to provide any additional information that can help you as an instructor.
- Exercise Video
- Purchase instructions – to share with your students
- There is no download for this presentation, the students start with a blank Excel worksheet.
Please direct questions to David Ringstrom (david@studentsxl.com) or 404.784.0275. Learn more about us at www.studentsxl.com.