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
0:00
/ #1: Introduction
All Course Lessons (13)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
The Data Bootcamp: Transform your Data using dbt™
Sources: udemy
Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course
4 hours 10 minutes 51 seconds
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
Semantic Log Indexing & Search
Sources: Andreas Kretz
Semantic search is one of the most practical ways to apply generative AI in real-world data processing projects. In this course, we go beyond...
53 minutes 37 seconds
The Data Science Course: Complete Data Science Bootcamp 2023
Sources: udemy
Data scientist is one of the best suited professions to thrive this century. It is digital, programming-oriented, and analytical. Therefore, it comes as no surp
31 hours 14 minutes 14 seconds
Data Platform & Pipeline Design
Sources: Andreas Kretz
Data pipelines are a key component of any Data Science platform. Without them, data loading and machine learning model deployment would not be possible. This...
1 hour 59 minutes 5 seconds