Microsoft Office & 365 Apps
Excel Dashboards
Build effective Excel dashboards in one day: analyse data with formulas and PivotTables, visualise it with charts and assemble interactive dashboards.
1 dayIntermediate5 modules
About this course
Build effective Excel dashboards in one day: analyse data with formulas and PivotTables, visualise it with charts and assemble interactive dashboards.
What you'll learn
- Perform data analysis fundamentals.
- Visualize data with Excel.
- Analyze data with formulas and functions.
- Analyze data with PivotTables.
- Present visual insights with dashboards in Excel.
Curriculum
5 modules
- Topic A- Introduction to Data Science
- Topic B- Create and Modify Tables
- Topic C- Sort and Filter Data
- Topic A- Visualize Data with Charts
- Topic B- Modify and Format Charts
- Topic C- Apply Best Practices in Chart Design
- Topic A- Analyze Data with Formulas and Named Ranges
- Topic B- Analyze Data with Functions
- Topic C- Implement Data Validation, Forms, and Controls
- Topic D- Create Conditional Visualizations with Lookup Functions
- Topic A- Create a PivotTable
- Topic B- Analyze PivotTable Data
- Topic A- Visualize Data with PivotCharts
- Topic B- Filter Data Using Slicers and Timelines
- Topic C- Create a Dashboard in Excel
Who it's for
Analysts and managers who report in Excel.
Before you start
- To ensure success, you should have baseline skills using Excel worksheets, particularly in creating workbooks with formulas and functions.
Part of these Alalamia diplomas
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.