Excel for Data Analytics

Course details

Acquire comprehensive expertise in Excel, its functions, formulas, data analysis tools, and more. The course is enriched with practical exercises and demonstrations of real-world scenarios, showing how to manipulate and analyze data efficiently. Interactive, guided projects provide practical experience with real-world data analysis challenges. Explore foundational statistical concepts. Practice using pivot tables, lookups, formulas, and more. Upon completing this course, you will be equipped with new skills so you can confidently leverage Excel in your profession.

Concepts

Introduction

Instructor and course introductions

Introduction to Excel

What is Excel
Installing Microsoft Excel
Excel UI walkthrough

Excel Basics

Data types
Adding, deleting, and editing
Sorting and filtering

Formulas and Functions

Formulas and functions introduction
Basic formulas and functions
Conditional functions
Min, max, and average
Logical operators
IS Functions
Rounding functions
String functions

Statistics

Mean, median, and mode
Distributions
Standard deviation
Percentiles

Conditional Formatting

Highlight cells rules
Top and bottom rules
Bars, scales, and sets

XLOOKUP vs. VLOOKUP

Lookups introduction
VLookups
HLOOKUPs
XLOOKUPs
Index match
Lookup practice

Pivot Tables

Pivot table introduction
Creating our first pivot table
Formatting
Working with dates
Calculated fields
Sorting and filtering
Practice challenge

Visualizations

Bars and column charts
Line and combo charts
Scatter plots and bubble charts
Pie and donut charts
Geographical Map Charts

Data Cleaning

Data cleaning introduction
Removing duplicates
Fuzzy matching
Standardizing data
Handling missing data
Deleting columns and rows
Separating and combining columns
Data cleaning practice

Projects

Project 1 - US debt
Project 2 - NYC transportation

Congratulations

Congratulations