Farizat_tips_for_all

How to use this course

Welcome!

1. Why do we need pivot tables?

2. Preparing data for a pivot table

3. Creating our first pivot table

4. Pivot table fields

5. The "Analyze" and "Design" tabs of a pivot table

6. How to clear, select, and move a pivot table

7. How to refresh a pivot table and change the data source of a pivot table?

Test1

Homework 1

1. Formatting numeric values in a pivot table

2. Automatically formatting empty cells

3. Customizing the appearance and style of a pivot table

4. Editing pivot table headers

5. Conditional formatting in a pivot table

Test2

Homework 2

1. Sorting pivot table data

2. Pivot table label filters

3. Pivot table value filters

4. How to apply multiple filters in a pivot table

5. Grouping pivot table data

6. Pivot table slicers and timelines

7. How to show all filter pages of a pivot table

Test3

Homework 3

1. Summing pivot table data

2. Additional calculations in pivot table

3. Show data as % of Column/Row

4. Show data as % of Parent Total

5. Show data differences dynamically

6. Show data as a running total

7. How to show the rank of pivot table values

8. Creating calculated fields in a pivot table

9. Creating calculated items in a pivot table

Test4

Homework 4

1. Introduction to pivot charts

2. How to create a column chart

3. How to create a pie chart

4. How to create a bar chart

5. How to protect a chart from resizing

6. How to change the chart type

7. Chart style and design

8. How to move a chart to a separate sheet

9. How to use slicers and timelines

Test5

Homework 5