Modern Excel for Data Analysis

An Introduction to Data Analysis with Excel

Fundamentals of Data Analysis with Excel

• Aggregating Data

• Understanding Relational Data

• VLookup and XLookup

• Logic Functions (IF, AND, OR)

• Drawing Simple Charts

• Understanding Pivot Tables

• Knowing when to unpivot data

• Drawing Simple Charts

• Pivot Charts

Introduction to OSEMN Data Science Process in Excel 

• Obtain Data

• Scrub and prepare the data

• Explore the data

• Model the data

• iNterpret the data

Obtaining Data with the Power Query Editor

• Use "Get Data" and the Power Query Editor to Obtain data from multiple sources

• Working with Relational Data in Excel (Building a Data Model)

• Using Power Pivot to make a data model

• Combining Data with Merge and Append Queries

Scrub and Prepare Data using the Power Query Editor 

• Fix common data quality issues

• Deal with missing or erroneous data

• Create new calculated columns

• Automatically apply the same steps to new data as it arrives.

Exploring Data in Excel

• Use Pivot Charts to explore data and uncover hidden truths

• Identifying trends

• Analysing time series data

Model Data in Excel to make predictions

• Lines of Best Fit (Regression)

• What-if Analysis

• Forecast Sheets

iNterpret Data 

• Understand that correlation does not always imply causation

• Bring your findings together into a coherent presentation

• Presenting your findings to others.