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