English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 13 Lessons (2h 10m) | 506 MB
Learn to wield the power of Excel for Data Analysis with this beginner-friendly course. Plus you’ll put your new skills to the test with exercises and even have fun along the way!
This byte-sized Excel Data Analysis Training course is perfect for beginners who want to have the power to analyze structured data using two of Excel’s most powerful features: Excel Tables and Pivot Tables. Plus you’ll learn everything from scratch!
What you’ll learn
- Learn how to use Excel for Data Analysis as a complete beginner
- Master Excel Tables to efficiently manage and organize your data with structured formatting
- Leverage Pivot Tables to transform raw data into meaningful insights for smarter decision-making
- Understand how to analyze complex datasets and track trends to improve your analytical skills
Table of Contents
1 Introduction
2 Text to Columns
3 External Data
4 Table Features
5 Tables as Named Ranges
6 Budget Project: Structured Data
7 Intro to Pivot Tables
8 Adding Layers to Pivot Tables
9 Pivot Table Formatting and Layout
10 Filtering Pivot Tables
11 Slicers
12 Pivot Table Math
13 Budget Project: Pivot Tables
Resolve the captcha to access the links!