Microsoft Excel Pivot Tables – Beginner to Advanced

سرفصل های دوره

Quickly calculate, summarize and analyze large data sets with Microsoft Excel Pivot Tables

1. Microsoft Excel PivotTables - Beginner to Advanced Course Introduction

1. Microsoft Excel PivotTables - Beginner to Advanced Course Introduction

2.1 ExcelPivotTableExerciseFiles.zip

2. Excel PivotTable Course Exercise Files (DOWNLOAD)

3. Excel PivotTable Course QA (ASK QUESTIONS)

4. CHALLENGE 01 Post to the Course QA.html

2. Introduction to Excel PivotTables

1. Why Use an Excel PivotTable

2. Introduction to PivotTable Source Data

3. Inserting an Excel PivotTable

4. Working with the PivotTable Field List

5. CHALLENGE 02 Create an Excel PivotTable.html

6. Modify Excel PivotTable Field Layout

7. CHALLENGE 03 Modify PivotTable Summary.html

8. Refreshing an Excel PivotTable

9. BONUS TIP - Excel Table as PivotTable Source

3. Preparing Microsoft Excel Worksheet Data

1. Proper Microsoft Excel List Design and Layout

2. Microsoft Excel - Dos and Donts of Proper Excel List Design

3. Cleaning Up Excel List Data

4. Proper Excel List Headers

5. Removing Empty Excel List Rows

6. Microsoft Excel PROPER() Function

7. Microsoft Excel TRIM() Function

8. Microsoft Excel VALUE() Function

9. Microsoft Excel UPPER() Function

10. CHALLENGE 04 Cleaning Up Excel Data.html

11. Apply Excel Data Validation to List to Ensure Data Integrity

12. Highlight Invalid List data

13. Removing Duplicate Records from Excel List

14. Format Excel List as Table

15. CHALLENGE 05 Applying Validation to PivotTable Source Data.html

4. Microsoft Excel PivotTables Summary Values and Calculations

1. Excel PivotTable VALUE Defaults

2. Manage Value Field Settings

3. Show Values As Settings

4. Formatting PivotTable Values

5. CHALLENGE 06 PivotTable Value Field Settings.html

5. Grouping Excel PivotTable Data

1. Grouping PivotTable Date Values

2. Date Value Group Settings

3. Manually Grouping PivotTable Row Data

4. Excel PivotTable Multi-Level Row Groupings

5. CHALLENGE 07 PivotTable Grouping.html

6. Sorting and Filtering Excel PivotTable Data

1. Sorting Data in an Excel PivotTable

2. Using Custom Lists to Sort in an Excel PivotTable

3. Sorting PivotTable Column Headers

4. Filtering Data in an Excel PivotTable

5. Working with PivotTable Slicers to Filter Data

6. Removing a PivotTable Slicer

7. Working with Excel PivotTable Timeline Filters

8. Sorting and Filtering Excel PivotTable Data.html

7. Formatting Excel PivotTables

1. Working with Excel PivotTable Styles

2. Managing Excel PivotTable Subtotals

3. Managing Excel PivotTable Grand Totals

4. Formatting PivotTable Slicers

8. Excel Pivot Charts

1. Inserting an Excel Pivot Chart

2. Combining Charts with PivotTable Slicers

3. PivotTable and Pivot Chart Connection

4. Formatting a Pivot Chart with Chart Styles

5. Adding and Removing Chart Elements

9. Introduction to Microsoft Excel Power Query

1. Why Excel Power Query

2. Introduction to External Data Sources

3. Creating a New Query

4. Transform Power Query Data

5. Loading a Query to an Excel Worksheet

6. Updating the Original Source Data

7. Creating a PivotTable based on the Query

8. Introduction to Excel Table Relationships

9. Append Multiple Queries through Power Query

10. Merge Multiple Queries through Power Query

11. Create a PivotTable based on Multiple Datasets

10. Congratulations

1. Congratulations on Completing the Excel PivotTables Beginner to Advanced Course

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training