Welcome to the Microsoft Future Ready: How to Use Microsoft Excel for Data Analysis course. This activity introduces you to the course outline and learning outcomes, as well as CloudSwyft and its partnership on this course.

In this activity, you'll be introduced to the basics of reporting data in Excel and using Excel charts.

This is your first Hands-On learning lab. In this activity, you'll practically apply the knowledge you've gained in the course.

In this activity, we'll learn about Excel tables and their features.

Welcome to your second Hands-On learning lab. In this activity, you'll be presented with a scenario and given the opportunity to practically apply the knowledge you've gained so far.

In this activity, we'll introduce you to the basic features of the pivot table. We'll also look at how you can use pivot tables and charts to build a basic dashboard.

This is your third Hands-On learning lab. In this activity, you'll be presented with a scenario in which you'll apply the knowledge you've gained thus far in the course.

This is the closing activity for Week 1, where we'll reflect on what you've learned. You'll also get a sneak peek at Week 2 and vote in a fun poll!

In this step, we'll jump right into our first topic, Dashboards. You'll learn how slicers, filters and pivots can be used to build sophisticated dashboards.

This is your fourth Hands-On learning lab. In this activity, you'll practically apply the knowledge you've gained in the course.

In this activity, you'll explore how to use calculated fields and conditional formatting in pivot tables to analyse datasets and detect anomalies in data.

This is your fifth Hands-on learning lab. You'll be provided with the opportunity to show what you've learned about profitability analysis and finding anomalies in your lab.

In this activity, we'll look at comparing data in pivot tables. We'll focus on year-on-year comparison values using the pivot table as well as the SUMIFS function.

This is your sixth Hands-On learning lab. In this activity, you'll practically apply the knowledge you've gained about comparing year-over-year values.

In this activity, you'll go through different ways to visualise and chart data in Excel. In particular, you'll explore how to visually represent hierarchical data making use of Treemaps and Sunburst charts.

This is your seventh Hands-On learning lab. In this activity, you'll practically apply what you've learned about hierarchical data.

In this step, you'll be introduced to multi-table pivot tables. You'll learn the process of using the 'data model' to import data into Excel from different data sources.

This is your final Hands-On learning lab where you'll demonstrate what you've learned in the previous activity.

Well done! You've reached the end of the course. In this final activity, you'll explore some takeaway information on conditional formatting on the pivot and Excel table.