Microsoft Excel: Advanced Data Analysis and Visualisation

Learn how to use Excel alongside industry experts

Though millions of people use Excel for their simple daily tasks, it’s also one of the most widely used solutions for analysing and visualising data. That’s because it now includes tools that enable the analysis of more data, with improved visualisations and more sophisticated business logic.

On this three-week course, you’ll get an introduction to the latest versions of these new tools, learning directly from an expert on the Excel Product Team at Microsoft.

Discover how to import data and perform data cleaning

You’ll start by learning how to import data from different sources in Excel to help you prepare for data analysis.

This knowledge will help you perform a variety of tasks including; data cleaning and pre-processing steps, creating data mash-ups, building your business logic in the Excel data model, and presenting the data with interactive visuals.

Explore visualisation and pivot tables

After learning how to prepare the data, you’ll find out how business calculations can be expressed using the DAX calculation engine.

Next, you’ll see how the data can be visualised and shared to the Power BI cloud service. You’ll then see how it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.

This will help you understand how pivot tables, pivot charts, and slicers work together.

Hone your data science skills

By the end of this course, you’ll feel confident in using Excel to perform data analysis and visualisations.

Learning from the experts at CloudSwyft and from the Excel Product Team, you’ll develop essential data science skills to help advance your career.

This course is designed for anyone interested in learning more about Excel analytics tools – whether you’re a novice user or a seasoned Excel user.

You don’t need any prior knowledge or experience to benefit from this course.

The upgrade version of this course will include all the required CloudSwyft Hands-On Lab practice environments to be used by students and learners on this course, powered by CloudSwyft. You will need a computer running Windows, Mac OSX or Linux, and a web browser.

• Course Introduction
• About the Course
• Data Analysis in Excel
• CloudSwyft Hands-On Labs
• Data Models and DAX in Excel
• CloudSwyft Hands-On Labs
• Wrapping up the Week
• Importing Data into the Excel Data Model
• Importing Data: CSV Files
• CloudSwyft Hands-On Labs
• Importing Data: Databases and Multiple Files
• Importing Data: Excel Reports
• CloudSwyft Hands-On Lab
• Wrapping Up the Week
• Data Analysis and Visualisation with Excel and Power BI
• The DAX Language
• CloudSwyft Hands-On Labs
• Visualising Data in Excel
• CloudSwyft Hands-On Labs
• Power BI
• Wrapping Up the Course