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
Analytics Engineering for Data Professionals
Sources: Fabrizio Valentini, Mattia Brunelli
Analytics Engineering is the foundation of Data Science and artificial intelligence. This approach represents a dynamic combination of data engineering and...
12 hours 46 minutes 13 seconds
Machine Learning with Javascript
Sources: udemy, Stephen Grider
If you're here, you already know the truth: Machine Learning is the future of everything. In the coming years, there won't be a single industry in the world untouched by Machine...
17 hours 42 minutes 20 seconds
Schema Design Data Stores
Sources: Andreas Kretz
During my coaching sessions, one important topic repeatedly comes up - designing diagrams. Therefore, I decided to create a separate course in the academy to...
2 hours 30 minutes 25 seconds
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
Sources: udemy
Are you interested in a career in Data Science or Data Analytics? In that case, inevitably you are going to encounter databases in your work. But how do you int
12 hours 32 minutes 7 seconds
2022 Python for Machine Learning & Data Science Masterclass
Sources: udemy
Welcome to the most complete course on learning Data Science and Machine Learning on the internet! After teaching over 2 million students I've worked for over a
44 hours 5 minutes 31 seconds