Data Analysis for Beginners: Excel & Pivot Tables

2h 10m 21s
English
Paid

Course description

This short course on data analysis in Excel is perfect for beginners who want to acquire skills in analyzing structured data using two of Excel's most powerful tools: tables and pivot tables. And most importantly, you will learn everything from scratch!

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 13 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online Data Analysis for Beginners: Excel & Pivot Tables

0:00
/
#1: Introduction

All Course Lessons (13)

#Lesson TitleDurationAccess
1
Introduction Demo
04:56
2
Text to Columns
05:56
3
External Data
10:05
4
Table Features
09:59
5
Tables as Named Ranges
14:10
6
Budget Project: Structured Data
09:33
7
Intro to Pivot Tables
13:04
8
Adding Layers to Pivot Tables
14:09
9
Pivot Table Formatting and Layout
10:58
10
Filtering Pivot Tables
10:04
11
Slicers
11:13
12
Pivot Table Math
09:45
13
Budget Project: Pivot Tables
06:29

Unlock unlimited learning

Get instant access to all 12 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Data Engineering on GCP

Data Engineering on GCP

Sources: Andreas Kretz
Google Cloud Platform (GCP) is one of the most popular cloud platforms in the world, providing an extensive set of tools and services for building...
1 hour 17 minutes 33 seconds
Storing & Visualizing Time Series Data

Storing & Visualizing Time Series Data

Sources: Andreas Kretz
Processing, storing, and visualizing time series data is becoming an increasingly important task. From IoT data and system logs to statistics...
2 hours 11 minutes 34 seconds
Azure Data Pipelines with Terraform

Azure Data Pipelines with Terraform

Sources: Andreas Kretz
Azure is becoming an increasingly popular platform for companies using the Microsoft365 ecosystem. If you want to enhance your data engineering skills...
4 hours 20 minutes 29 seconds
Machine Learning: Natural Language Processing in Python (V2)

Machine Learning: Natural Language Processing in Python (V2)

Sources: udemy
Welcome to Machine Learning: Natural Language Processing in Python (Version 2). NLP: Use Markov Models, NLTK, Artificial Intelligence, Deep Learning, Machine Le
22 hours 4 minutes 2 seconds
TensorFlow Developer Certificate in 2023: Zero to Mastery

TensorFlow Developer Certificate in 2023: Zero to Mastery

Sources: zerotomastery.io
Learn TensorFlow. Pass the TensorFlow Developer Certificate Exam. Get Hired as a TensorFlow developer. This course will take you from a TensorFlow beginner to b
62 hours 43 minutes 54 seconds