-
Millions of people use Excel every day for their daily tasks, whether it’s for number crunching, reporting, calculations–you name it. In this course, you’ll learn how to use Excel to perform data analysis and visualisations. You will learn how to bring data from other sources into Excel, perform data cleaning and pre-processing steps, create data mash-ups, build your business logic in the Excel data model, and present the data with interactive visualisations.
We welcome all learners! While you may find the understanding of Excel analytics tools such as Excel tables, pivot tables and pivot charts, and working with data from databases challenging, we’re sure that everyone can follow this course. If you’re a novice user, visit the discussion forum. If you’re a more advanced learner or a seasoned Excel user, stick around the discussion forum and perhaps help your fellow learners!
Overview
Syllabus
-
- 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