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

Zero To Mastery

Data Analysis for Beginners: Excel & Pivot Tables

via Zero To Mastery

Overview

Learn to wield the power of Excel for Data Analysis with this beginner-friendly course. Plus you'll put your new skills to the test with exercises and even have fun along the way!
  • Learn how to use Excel for Data Analysis as a complete beginner
  • Master Excel Tables to efficiently manage and organize your data with structured formatting
  • Leverage Pivot Tables to transform raw data into meaningful insights for smarter decision-making
  • Understand how to analyze complex datasets and track trends to improve your analytical skills

Syllabus

  •   Introduction
    • Introduction
    • Exercise: Meet Your Classmates and Instructor
    • Course Resources
  •   Introduction to Data Analysis with Excel: Working with Structured Data
    • Text to Columns
    • External Data
    • Table Features
    • Tables as Named Ranges
    • Exercise: Working With Structured Data in Excel
    • Budget Project: Structured Data
  •   Data Analysis with Excel: Pivot Tables
    • Intro to Pivot Tables
    • Adding Layers to Pivot Tables
    • Pivot Table Formatting and Layout
    • Filtering Pivot Tables
    • Slicers
    • Pivot Table Math
    • Exercise: Pivot Tables
    • Budget Project: Pivot Tables
  •   Where To Go From Here?
    • Review This Byte!

Taught by

Travis Cuzick

Reviews

Start your review of Data Analysis for Beginners: Excel & Pivot Tables

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.