Excel Pivot Tables Tutorial
Learn Skills Daily
@learnskillsdailyAbout
BECOME A MEMBER TO UNLOCK AD-FREE VIDEOS Learn Skills Daily provides on-demand video courses on a wide range of software and subjects. From the deep data tools of Microsoft Excel to the endless creative possibilities of Adobe Photoshop to the collaborative concoction of Microsoft Teams, we've got you covered. At Learn Skills Daily, we've been fine-tuning our teaching methodology for over 25 years. Our videos are specifically designed to emulate the same great experience you get from a live class. Plus, you can learn at your own pace, following along with our try-it-yourself exercise files. If you're serious about learning, we're serious about providing you with a better learning platform.
Latest Posts
Video Description
Excel Pivot Tables Tutorial Get Ad-Free Training by becoming a member today! https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: https://www.learnitanytime.com Exercise Files: https://tinyurl.com/2mk6wcc4 Who it's for: Excel users interested in one of the most useful tools Microsoft's spreadsheet app offers. What it is: A Pivot Table is a powerful feature in Excel that analyzes complex datasets and streamlines that information into neat and tidy tables, displaying only the information you really need to see. What you'll learn: In this comprehensive course, you’ll learn how to create, modify, and update Pivot Tables in Excel. We'll also show you how to create Pivot Charts and use XLOOKUP. For advanced users, we'll tackle Power Pivot, DAX expressions, data mining, and much more. Start 0:00 Introduction 0:09 What are Pivot Tables? 1:44 Preparing Data for Analysis 7:18 Pivot Table Components 11:51 Building Pivot Tables to Show Different Values 18:09 Adding Fields to Pivot Tables 23:24 Using Built-In Filters 30:13 Filtering Data with Slicers 36:03 Displaying New Values from Data Sources 42:53 Inserting Pivot Charts 49:24 XLOOKUP 56:15 Joining Data Sets with XLOOKUP 1:04:27 Introduction to Advanced Pivot Tables 1:12:20 Inserting Pivot Tables from Tables 1:13:46 Calculated Fields 1:21:32 Using the Timeline Tool 1:27:22 Report Filter Pages 1:32:38 Pivot Table Layouts 1:39:21 Creating Pivot Table Designs 1:45:45 Adding Power Pivot Tabs to the Ribbon 1:53:11 Adding Tables to Power Pivot Data Model 1:55:54 Creating Table Relationships 2:00:56 Creating Columns with DAX Expressions 2:05:07 Displaying New Source Data in Power Pivot Tables 2:12:33 Data Mining with Flash Fill 2:15:24 Conclusion 2:21:27 #excel #exceltutorial #exceltips #exceltricks Learnit is no longer associated with this channel/video. (C) 2025 Bomberry Productions Any illegal reproduction of this content will result in immediate legal action.
You May Also Like
Excel Mastery Essentials
AI-recommended products based on this video
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
Media Management and Artificial Intelligence: Understanding Media Business Models in the Digital Age