About this course
In the first course of our Data Analysis Series (DAT101: Introduction to Data Analysis using Excel), we set a good foundation for data analysis by exploring essential tools such as pivot tables and other important excel functions. In this second course in the series, we will deep dive into more complexed functions of excel to ensure that participants are equipped with better data analysis skills.
Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logic.
We will revise some of the tools learned in DAT101 such as pivot tables, pivot charts, and slicers; learn how to import data from different sources; create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. We will also explore an Excel Data Model; practice financial formulas such as NPV and IRR; and calculate payment schedules and periods using Excel tools.