Главная
Study mode:
on
1
- Introduction to Advanced PivotTables
2
- PivotTables Recap
3
- Importing data from a text file
4
- Importing data from Access
5
- Exercise 01
6
- Cleaning Data
7
- Tabular Data
8
- Exercise 02
9
- Creating and Manipulating a PivotTable
10
- Combining Data from Multiple Worksheets
11
- Grouping and Ungrouping
12
- Report Layouts
13
- Formatting Error Values and Empty Cells
14
- Exercise 03
15
- PivotTable Styles
16
- Custom Number Formatting
17
- Exercise 04
Description:
Master advanced pivot table techniques in Excel with this comprehensive 2.5-hour tutorial. Dive deep into importing data from various sources, cleaning and manipulating data, combining information from multiple worksheets, and exploring different pivot table layouts and styles. Learn to group and ungroup data, format error values and empty cells, and apply custom number formatting. Follow along with downloadable exercise files to practice creating, manipulating, and customizing pivot tables for powerful data analysis. Suitable for intermediate to advanced Excel users looking to enhance their pivot table skills and streamline complex data operations.

Advanced Pivot Tables Tutorial in Excel

Simon Sez IT
Add to list
0:00 / 0:00