How to Use Microsoft Excel for Data Analysis

Syllabus

• Week 1

  Introduction to Excel Table and Pivot Table Fundamentals

  • Welcome to the Course!

    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.

  • Introduction to Reporting in Excel

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

  • CloudSwyft Hands-On Lab 1

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

  • Excel Tables

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

  • CloudSwyft Hands-On Lab 2

    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.

  • Basic Pivot Tables

    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.

  • CloudSwyft Hands-On Lab 3

    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.

  • Wrapping up the Week

    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!

• Week 2

  Reporting, Analysing and Comparing Data in Excel

  • Dashboards

    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.

  • CloudSwyft Hands-On Lab 4

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

  • Profitability Analysis and Finding Anomalies

    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.

  • CloudSwyft Hands-On Lab 5

    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.

  • Comparative Data in Pivot Tables

    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.

  • CloudSwyft Hands-On Lab 6

    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.

  • Reporting Hierarchical Data

    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.

  • CloudSwyft Hands-On Lab 7

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

  • Introduction to Multi-Table Pivot Tables and the Data Model

    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.

  • CloudSwyft Hands-On Lab 8

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

  • Wrapping up the Course

    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.