PivotTables in Excel Course for Beginners

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

Learn a quick and interactive way of summarizing large data with Pivot Tables in Excel!

1. Introduction

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Pivot Tables Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Pivot Tables Course Files.zip

4. DOWNLOAD ME Course Support Files.html

5. What are Pivot Tables and Why are They Useful

6. Section Quiz.html

2. Preparing Data for Analysis

1. The Importance of Cleaning Data

2. Removing Blank Rows

3. Removing Duplicate Rows

4. Clearing Formatting

5. Applying Number Formatting

6. Changing the Case

7. Removing Spaces and Non-printing Characters

8. Merging and Splitting Columns

9. Convert Numbers Stored as Text

10. Finding and Replacing Text

11. Spell Check

12. Exercise 01

13. Section Quiz.html

3. The Importance of Excel Tables

1. Excel Tables vs Pivot Tables

2. Format Data as a Table

3. Exercise 02

4. Section Quiz.html

4. Creating a Basic Pivot Table Report

1. Using Recommended Pivot Tables

2. Creating a Pivot Table from Scratch

3. Pivot Table Ribbons and Fields

4. Pivoting the Fields

5. Adding Multiple Dimensions

6. Deleting Fields and Locking the Report Layout

7. Exercise 03

8. Section Quiz.html

5. Aggregation and Grouping

1. Methods of Aggregation

2. Combining Methods of Aggregation

3. Grouping and Ungrouping Data

4. Exercise 04

5. Section Quiz.html

6. Formatting Values

1. Applying Number Formatting

2. Handling Cells with No Data

3. Exercise 05

4. Section Quiz.html

7. Layout Options

1. Subtotals and Grand Totals

2. Choosing a Report Layout

3. Inserting Blank Rows

4. Exercise 06

5. Section Quiz.html

8. Formatting Pivot Tables

1. Applying Pivot Table Styles

2. Modifying Pivot Table Styles

3. Creating a Custom Pivot Table Style

4. Exercise 07

5. Section Quiz.html

9. Sorting and Filtering

1. Sorting Pivot Table Data

2. Filtering Pivot Table Data

3. Top 10 Filter

4. Exercise 08

5. Section Quiz.html

10. Creating Pivot Charts

1. Selecting the Right Chart Type

2. Clustered Column and Bar Charts

3. Line Charts

4. Pie and Donut Charts

5. Map Charts

6. Applying Chart Layouts

7. Exercise 09

8. Section Quiz.html

11. Formatting Pivot Charts

1. Adding a Slicer

2. Formatting a Slicer

3. Adding a Timeline

4. Connecting Slicers and Timelines

5. Exercise 10

6. Section Quiz.html

12. Applying Conditional Formatting

1. Highlight Cell Rules

2. Data Bars

3. Color Scales

4. Icon Sets

5. Exercise 11

6. Section Quiz.html

13. Updating Pivot Tables and Pivot Charts

1. Adding Data to the Dataset

2. Updating Pivot Tables and Pivot Charts

3. Exercise 12

4. Section Quiz.html

14. Course Close and Next Steps

1. Course Close and Next Steps

15. Additional Training

1. READ ME This Additional Training Is Optional.html

2. Ten Excel Tips and Tricks - Part 1

3. Ten Excel Tips and Tricks - Part 2

4. Ten Excel Tips and Tricks - Part 3

235,000 تومان

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

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

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

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