From Excel charts to dashboards, develop the skills to aid business decisions, track KPIs, and reveal data insights with this online course from The Excel Club.
2 hrs per week
Approx 12 weeks
Certificates
Find out more
100% online
How it works
Cost
Find out more
Level
See requirements
Course 1
Introduction to Excel Charts for Data Visualisation
4.5 (6 reviews)Learn the basics of charting in Excel, from creating and formatting charts, to the pros and cons of each different type of chart.
1 test
4 weeks
2 hours per week
Week 1
Our first Excel charts
- Kickstarting this course
- Inserting and working with charts
- What is data visualization?
- Chart templates and line charts
- Weekly wrap up
Week 2
Common Excel charts
- Welcome back
- Some common Excel charts
- More common charts in Excel
- Weekly wrap up
Week 3
Less common charts in Excel
- Welcome to week 3
- More Excel charts
- Oh My! Even more charts
- Weekly wrap up
Week 4
Visualizations are not always charts
- Welcome to week 4
- Charts and visualizations
- Weekly wrap up
Course 2
Design and Create Custom Dashboards in Excel
Enhance your Excel charting skills and discover the tools and skills to create advanced and automated dashboards.
1 test
6 weeks
2 hours per week
Week 1
Getting started with dashboards
- Kickstarting this course
- Your first custom visual
- Designing dashboards
- Weekly wrap up
Week 2
Down and dirty with custom visuals
- Getting started with week 2
- Basic to advanced Waterfall charts
- Dashboards in Excel
- Excel Gauge Charts
- Weekly wrap up
Week 3
Lets start to get more dynamic
- Getting started with week 3
- Actual V's Budget
- It's dynamic!
- Good and bad dashboards
- Keeping it dynamic and interactive
- Weekly wrap up
Week 4
What's in a name?
- Getting started with week 4
- Automating charts with named ranges
- INDEX function in action
- Weekly wrap up
Week 5
Changing charts
- Getting started with week 5
- Dropdowns, loookups and named ranges
- Form Controls
- Cards
- Weekly wrap up
Week 6
Putting it all together
- Getting started with week 6
- Your first dashboard
- The second dashboard
- The third dashboard
- Weekly wrap up
Course 3
How to Use Pivot Tables to Analyse Data in Excel
Build and improve your data analysis skills by learning how to utilise pivot tables, charts, and dashboards in Excel.
1 test
2 weeks
2 hours per week
Week 1
The Basics of Pivot Tables
- Kickstarting this course
- An Introduction to Pivot Tables
- More on Pivot tables and Pivot Charts
- Weekly wrap up
Week 2
Pivot Table Dashboards
- Getting started with week 2
- Pivot Dashboard in 20 minutes
- GETPIVOTDATA
- Weekly wrap up
More courses you might like
Learners who joined this course have also enjoyed these courses.