Advanced PivotTables in Excel: Master the Pivot Table!
5.0 /5- Offered byUDEMY
Advanced PivotTables in Excel: Master the Pivot Table! at UDEMY Overview
Duration | 10 hours |
Total fee | ₹389 |
Mode of learning | Online |
Credential | Certificate |
Advanced PivotTables in Excel: Master the Pivot Table! at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Comes up with 30-Day Money-Back Guarantee
- Get Full lifetime access
Advanced PivotTables in Excel: Master the Pivot Table! at UDEMY Course details
- For Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
- For Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge
- For People looking to perform Data Analysis using Excel
- How to do a PivotTable (a quick refresher)
- How to combine data from multiple worksheets for a PivotTable
- Grouping, ungrouping and dealing with errors
- How to format a PivotTable, including adjusting styles
- How to use the Value Field Settings
- Advanced Sorting and Filtering in PivotTables
- How to use Slicers, Timelines on multiple tables
- How to create a Calculated Field
- All about GETPIVOTDATA
- How to create a Pivot Chart and add sparklines and slicers
- How to use 3D Maps from a PivotTable
- How to update your data in a PivotTable and Pivot Chart
- All about Conditional Formatting in a PivotTable
- How to create amazing looking dashboards
- In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function
- In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting
- This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function
Advanced PivotTables in Excel: Master the Pivot Table! at UDEMY Curriculum
Introduction
WATCH ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files
Importing data
Importing data from Access
Exercise 01
Section Quiz
Preparing Data for Analysis
Cleaning Data
Tabular Data
Exercise 02
Section Quiz
Creating and Manipulating Pivottables
Combining Data from Multiple Worksheets
Grouping and Ungrouping
Report Layouts
Formatting Error Values and Empty Cells
Exercise 03
Section Quiz
Formatting Pivot tables
PivotTable Styles
Custom Number Formatting
Exercise 04
Section Quiz
Value Field Settings
Summarizing Values
Show Values As
Exercise 05
Section Quiz
Sorting and Filtering
Advanced Sorting
Advanced Filtering
Exercise 06
Section Quiz
Interacting with Pivot tables
Inserting and formatting Slicers
Inserting and formatting Timelines
Connecting Slicers to Multiple PivotTables
Using Slicers in Protected Workbooks
Exercise 07
Section Quiz
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?