This course is specially designed for existing users of Microsoft Excel who want to import, manage, and transform data from single or multiple sources and create reports in Excel with Office Excel 365.
Information workers using Microsoft Excel focusing on data management, analysis and reporting.
Participants will gain an understanding of the importance of managing the quality of data that they are working with. They will learn skills on cleaning and transforming data to remove noise. They will also be able to work with data relationships to link multiple datasets together for use later. They will be able to create reports using PivotTables or any other visualization tools. They will then load and present the analysis into the Excel worksheet.
Module 1: Introduction to the Modern Data Analysis Tools in Excel
Module 2: Connect Data from Multiple Sources
Module 3: Transform and Shape Data with Power Query
Module 4: Loading Data
Module 5: Modeling Data with PowerPivot
Module 6: Building Interactive Report Visualizations