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
Complete Machine Learning and Data Science: Zero to Mastery
Sources: udemy, zerotomastery.io
This is a brand new Machine Learning and Data Science course just launched January 2020 and updated this month with the latest trends and skills! Become a complete Data Scientis...
43 hours 22 minutes 23 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
Case Study in A/B Testing
Sources: LunarTech
Examples from practice in A/B testing - this course will introduce you to the methods of designing, conducting, and analyzing experiments using A/B...
1 hour 56 minutes 17 seconds
Complete linear algebra: theory and implementation
Sources: udemy
You need to learn linear algebra! Linear algebra is perhaps the most important branch of mathematics for computational sciences, including machine learning, AI, data science, st...
32 hours 53 minutes 26 seconds
Statistics for Data Science and Business Analysis
Sources: udemy
Is statistics a driving force in the industry you want to enter? Do you want to work as a Marketing Analyst, a Business Intelligence Analyst, a Data Analyst, or
4 hours 49 minutes 30 seconds