آموزش تسلط بر Pivot Tables در اکسل: از مفاهیم پایه تا تحلیل‌های پیشرفته - آخرین آپدیت

درس ها Lessons

• Welcome to the course!

• Module 1: Introduction and First Steps

• Using Pivot Tables in Business Scenarios

• Common Mistakes When Creating Pivot Tables

• Creating Your First Pivot Table

• Performing Your First Data Analysis

• Customizing the Ribbon in Excel

• Quick Access Toolbar Configuration

• Working with Dynamic Tables

• Module 2: Building and Customizing Pivot Tables

• Creating Easy Pivot Tables

• Understanding Field Options

• Pivot Table Options Overview

• Generating Data with GETPIVOTDATA

• Sorting Data in Pivot Tables

• Filtering Data in Pivot Tables

• Module 3: Exercises and Hands-On Practice

• Exercise: Build and Analyze Pivot Tables

• Solution: Pivot Table Exercise

• Module 4: Advanced Calculations and Aggregations

• Aggregation Methods Explained

• Working with Percentages

• Performing Calculations in Pivot Tables

• Grouping Data in Pivot Tables

• Duplicating Pivot Tables Efficiently

• Actions: Clear, Select, and Move Items

• Refreshing and Updating Data Sources

• Drill-Through Techniques

• Managing Field Lists Effectively

• Module 5: Layout, Design and Styling

• Recommended Pivot Table Layouts

• Style Options for Pivot Tables

• Pivot Table Styles Final

• Layout Configuration for Better Readability

• Printing Pivot Tables Professionally

• Module 6: Conditional Formatting

• Basics of Conditional Formatting in Pivot Tables

• Rule-Based Formatting

• Advanced Conditional Formatting Rules

• Module 7: Pivot Charts and Data Visualizations

• Pivot Charts vs Standard Excel Charts

• Column and Bar Charts

• Line and Area Charts

• Pie Charts and TreeMap Tips

• Radar Chart Techniques

• Choosing the Right Chart Type

• Design and Chart Configuration

• Final Touches: Formatting and Polish

• Module 8: Slicers, Timelines & Dashboard Integration

• Slicer Functionality and Best Practices

• Using Timelines in Pivot Tables

• Selection Pane for Enhanced Control

• Creating a Pivot Dashboard from Scratch

• Module 9: Power Pivot and Data Models

• Using Lookup Functions with Pivot Tables

• Adding Tables to Power Pivot

• Introduction to Power Pivot

• Adding Tables to Power Pivot

• Building a Data Model for Pivot Use

• Working with Pivot Tables Across Multiple Data Sources

• Pivot Table Analysis: Final Techniques

• Module 10: Automation and AI

• Automating with VBA for Pivot Tables

• Recording Macros for Pivot Tables

• Writing Custom VBA Code

• Using ChatGPT to Generate VBA Code

• ChatGPT for Signing Up and Generating Pivot Table Scripts

• Congratulation on your successful Completion!