Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Data Analysis: Pivot Tables, Lookups, and Data Cleaning - 3 Hour Course

Alex the Analyst via YouTube

Overview

Master essential Excel skills in this comprehensive video tutorial that covers fundamental data analysis techniques in under 3 hours. Progress through hands-on demonstrations of conditional formatting, pivot tables, charts and graphs creation, essential formulas and functions, lookup operations, and data cleaning procedures. Apply these learned concepts in a practical full project walkthrough that consolidates all the covered topics. Gain proficiency in transforming raw data into meaningful insights using Excel's powerful features, making this tutorial ideal for aspiring data analysts and business professionals seeking to enhance their spreadsheet capabilities.

Syllabus

Intro
Conditional Formatting
Pivot Tables
Charts and Graphs
Formulas and Functions
Lookups
Data Cleaning
Full Project in Excel

Taught by

Alex the Analyst

Reviews

Start your review of Excel Data Analysis: Pivot Tables, Lookups, and Data Cleaning - 3 Hour Course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.