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

Join premium to watch
Go to premium
# Title Duration
1 Introduction 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

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Python for Business Data Analytics & Intelligence

Python for Business Data Analytics & Intelligence

Sources: zerotomastery.io
Become a top Business Data Analyst. We’ll teach you everything you need to go from a complete beginner to getting hired as an analytics professional. You’ll lea
15 hours 25 minutes 6 seconds
Dimensional Data Modeling

Dimensional Data Modeling

Sources: Eka Ponkratova
In today's world, where data plays a key role, effective organization of information is the foundation for quality analytics and report building.
1 hour 37 minutes 57 seconds
Platform & Pipeline Security

Platform & Pipeline Security

Sources: Andreas Kretz
A reliable security concept for platforms and pipelines is critically important. Almost anyone can put together a Proof of Concept without an adequate level...
34 minutes 46 seconds
Data Engineering on AWS

Data Engineering on AWS

Sources: Andreas Kretz
This course is the perfect start for those who want to learn cloud technologies and start working with Amazon Web Services (AWS), one of the most popular..
4 hours 46 minutes 38 seconds
Dockerized ETL With AWS, TDengine & Grafana

Dockerized ETL With AWS, TDengine & Grafana

Sources: Andreas Kretz
Data engineers often need to quickly set up a simple ETL script that just does its job. In this project, you will learn how to easily implement...
29 minutes 12 seconds