Excel Data Analysis – Advanced Pivot Table Skills

Free Download Excel Data Analysis – Advanced Pivot Table Skills
Published 8/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.25 GB | Duration: 3h 16m
Learn Everything from Creating to Customizing and Analyzing Data with Pivot Tables

What you’ll learn
Create and customize Pivot Tables for data analysis.
Use filters, slicers, and timelines in Pivot Tables.
Generate interactive Pivot Charts for data visualization.
Apply Power Pivot and DAX expressions for advanced analysis.
Develop comprehensive data analysis reports.
Develop comprehensive data analysis reports.
Perform accurate and intuitive data analysis in Excel.
Requirements
A computer with Microsoft Excel installed (preferably Excel 2016 or later).
Basic experience with Excel functionality (charts & formulas a plus!)
Description
Unlock the full potential of Microsoft Excel with our comprehensive course, "Excel Data Analysis: Advanced Pivot Table Skills." This course is designed for professionals who want to master the art of data analysis using Excel Pivot Tables.Throughout this course, you’ll gain an accurate and intuitive understanding of how to efficiently prepare data for analysis, build dynamic Pivot Tables, and create insightful Pivot Charts. Our step-by-step approach ensures that you achieve a 100% comprehensive understanding of Pivot Table components, including filters, slicers, and calculated fields. We’ll also delve into deep features such as Power Pivot, DAX expressions, and table relationships, empowering you to handle large datasets easily.Whether you’re looking to streamline your workflow or enhance your data visualization skills, this course covers everything you need. By the end, you’ll be able to perform complex data analysis, generate interactive reports, and gain deeper insights from your data.Key topics include:Inserting and Adjusting Pivot TablesAdvanced Filtering TechniquesCreating and Customizing Pivot ChartsUsing Power Pivot for Large DatasetsEmploying DAX for Advanced CalculationsInteractive Data Analysis with Slicers and TimelinesOur course is filled with hands-on demos and Excel exercises that ensure you not only learn the concepts but also see how they work in practice. These practical exercises are essential because they give you answers to real-world data problems.In today’s increasingly data-driven world, analytics skills are in short supply and incredibly high demand. Those with the ability to transform data into insight are leading the charge. Enroll today and start your journey to becoming an Excel analytics pro!See you there!
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Welcome
Lecture 3 Download Excel files
Section 2: Basic Data Management
Lecture 4 List Design Basics
Lecture 5 Inserting Tables for Analysis
Lecture 6 Filtering Data in Tables
Lecture 7 Using the Total Row
Lecture 8 Conditional Formatting
Lecture 9 IF Function
Lecture 10 SUMIF and AVERAGEIF
Lecture 11 SUMIFS
Section 3: Data Visualization
Lecture 12 Inserting Recommended Charts
Lecture 13 Adjusting Charts
Lecture 14 Sparklines
Section 4: Pivot Tables: Data analysis
Lecture 15 What are Pivot Tables
Lecture 16 Preparing Data for Analysis
Lecture 17 Pivot Table Components
Lecture 18 Building Pivot Tables to Show Different Values
Lecture 19 Adding Fields to Pivot Tables
Lecture 20 Using Built-In Filters
Lecture 21 Filtering Data with Slicers
Lecture 22 Displaying New Values from Data Sources
Lecture 23 Inserting Pivot Charts
Lecture 24 XLOOKUP
Lecture 25 Joining Data Sets with XLOOKUP
Section 5: Advanced Pivot Tables
Lecture 26 Inserting Pivot Tables from Tables
Lecture 27 Calculated Fields
Lecture 28 Using the Timeline Tool
Lecture 29 Report Filter Pages
Lecture 30 Pivot Table Layouts
Lecture 31 Creating Pivot Table Designs
Lecture 32 Adding Power Pivot Tabs to the Ribbon
Lecture 33 Adding Tables to Power Pivot Data Model
Lecture 34 Creating Table Relationships
Lecture 35 Creating Columns with DAX Expressions
Lecture 36 Displaying New Source Data in Power Pivot Tables
Lecture 37 Data Mining with Flash Fill
Section 6: Conclusion
Lecture 38 Conclusion
Business Analysts looking to enhance data analysis capabilities,Data Enthusiasts eager to learn and apply Excel for data insights,Financial Professionals wanting to improve financial data analysis,Project Managers needing to track and analyze project data effectively,Marketing Analysts seeking to interpret and visualize marketing data,Sales Managers aiming to analyze sales data for better decision making,Students and Beginners interested in learning comprehensive Excel skills
Homepage

https://www.udemy.com/course/excel-data-analysis-advanced-pivot-table-skills/