Data Analysis & Reporting with Pivot Tables and Power Pivot
Created by Sudoksho
Course Duration 50 Days ৳1000
Effort Time 1/2 Hours Days
Last updated Feb 23, 2021
10 Modules
11 Exams
26 Files
60 videos
2 Trainee
Course Overview
Data Analysis & Reporting with Pivot Tables and Power Pivot
Chapter 1 - Create Your First PivotTable
- Chap-1_1. Introduction to PivotTables
- Introducing
- Chap-1-2. Format data for PivotTable
- DataPrep
- Chap-1_3. Create PivotTable
- CreatePivot
- Chap-1_4. Create Recommended PivotTable
- Recommended
- Chap-1_5. Pivoting a PivotTable
- Pivoting
- Chap-1_6. Configure a PivotTable
- Configure
- Chap-1_7. Connect an External Data Source
- External
- 1 OutsideSource
- Chap-1_8. Consolidate Data from Multiple Sources
- Consolidating
- Chap-1_9. Managing PivotTables
- Managing
- Take exam
Chapter 2 - Consolidate Reports in PivotTable
- Chap-2_1. Manage Subtotals and Grand Totals
- 1- SubAndGrand
- Chap-2_2. Change the Data Field Summary Operation
- 2- Summary
- Chap-2_3. Summarize more than One Data Field
- 3- MoreThanOne
- Chap-2_4. Create Calculated Field
- 4- Calculated
- Chap-2_5. Use PivotTable Data in a Formula
- 5- GetPivotData
- Chap-2_6. Drill Down to the Underlying Data
- 6- DrillDown
- Grouping
- Take exam
Chapter 3 - Sort & Filter PivotTable Data
- Chap-3_1. Sort PivotTable data
- 1- Sorting
- Chap-3_2. Create a custom sort order
- 2- CustomOrder
- Chap-3_3. Filter a PivotTable field by selection
- 3- Selection
- Chap-3_4. Filter a PivotTable by rule
- 4- FilterByRule
- Chap-3_5. Filter a PivotTable using a search filter
- 5- SearchFilter
- Chap-3_6. Filter a PivotTable using slicers
- 6- Slicers
- Chap_3_7. Format Slicer
- 7- FormatSlicer
- Chap-3_8. Filter with report filter fields
- 8- ReportFilter
- Chap-3_9. Clear and reapply PivotTable filters
- 9- Clearing
- Take exam
Chapter 4 - Customize PivotTable Presentation
Chapter 5 - Data Visualization Techniques in PivotTables
- Chap-5_1. Highlight cells by applying a rule
- Chap-5_2. Highlight the top or bottom values in a PivotTable
- Chap-5_3. Format cells using data bars
- Chap-5_4. Format cells using color scales
- Chap-5_5. Format cells using icon sets
- Chap-5_6. Edit a conditional formatting rule
- Chap-5_7. Control how multiple rules are applied
- Chap-5_8. Delete a conditional formatting rule
- Take exam
Chapter 6 - Data Analysis & Presentation with PivotCharts
Chapter 7 - Put Your Pivot Tables to Paper with Pivot Printing
Chapter 9 - Create PivotTable Using the Data Model
Chapter 10 - Create Business Intelligence Report with Power Pivot
- Chap-10_1. Power BI Tools System Requirements
- Chap-10_2. Introduction to Get & Transform in Power Query
- Chap-10_3. Normalizing Data with Power Query Editor
- Chap-10_4. Create Table Relationship Power Pivot Data Model
- Chap-10_5. Create Business Intelligence Report with Power Pivot
- Chap-10_6. Dynamically Update Report with Additional Data
- Take exam