Courses - Learn Excel Online By Doing
← Back to all Courses

All About Pivots

ALL DO WATCH PRACTICE UNLOCKED
Learn By Doing
Free

Sales Pivot

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order Amount" to start pivot tables.

Learn By Doing

Sunshine Events UNLOCK NOW

Summarizing data with pivot table.
Learn By Watching
Free

Pivot Table - Why should you learn? [04:00]

Learn By Watching
Free

Pivot Table - Pre-requisites [02:26]

Learn By Watching

Pivot Table - How to create one? [02:41] UNLOCK NOW

Learn By Watching

Pivot Table - Exploring Pivot Table grid (Fields) [03:23] UNLOCK NOW

Learn By Watching

Pivot Table - Value Field Settings - "Summarize Values By" - Sum, Average, Count, Max etc. [05:06] UNLOCK NOW

Learn By Watching

Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Grand Total [02:24] UNLOCK NOW

Learn By Watching

Pivot Table - Value Field Settings - "Show Values As" - Percentage (%) of Column/Row Total [04:51] UNLOCK NOW

Learn By Watching

Pivot Table - Grouping - Numbers [03:40] UNLOCK NOW

Learn By Watching

Pivot Table - Grouping - Dates [Years, Months etc.] [04:10] UNLOCK NOW

Learn By Watching

Pivot Table - Grouping - Text [03:37] UNLOCK NOW

Learn By Watching

Pivot Table - Refresh vs. Refresh All, Change Data Source and creating Dynamic Table Data Source [06:19] UNLOCK NOW

Learn By Watching

Pivot Table - Auto Refresh [00:42] UNLOCK NOW

Learn By Watching

Pivot Table - Pivot Chart Shortcut and Sparklines [02:14] UNLOCK NOW

Learn By Watching

Pivot Table - Drill Down option [00:58] UNLOCK NOW

Learn By Watching

Pivot Table - Report Filter - Generating 100s of reports in few seconds [03:41] UNLOCK NOW

Learn By Watching

Pivot Table - Slicer vs. Report Filter [02:32] UNLOCK NOW

Learn By Watching

Pivot Table - Practice - Sales Data Analysis - 1 of 2I (%, Grouping, Chart, Report Filter Pages) [08:00] UNLOCK NOW

Learn By Watching

Pivot Table - Practice - Sales Data Analysis - 2 of 2 (Slicer) [03:06] UNLOCK NOW

Learn By Watching

Pivot Table - Practice - Closing Stock Analysis [07:03] UNLOCK NOW

Practice

Practice: Pivot Tables-II UNLOCK NOW

Practice your skills about pivot tables.
Practice

Practice: Pivot Tables-III UNLOCK NOW

Practice your skills about pivot tables.
Practice

Practice: Pivot Tables-IV UNLOCK NOW

Practice your skills about pivot tables.
Practice

Practice: Pivot Tables-V UNLOCK NOW

Practice your skills about pivot tables.


  • Level: Advanced
  • Exercises: 0/25
  • Steps: 0/70
  • Points: 10.750
  • Approx. Time: 4h 15m

All About Pivots

Learn the most powerful data analysis and presentation tool in Excel

Rating Count : 4

Courses

Excel Paths

Sheetzoom

© 2024 Sheetzoom       Legal Stuff         Made with    in Istanbul

Start learning Excel now

Get notified first! Sign-up free for our newsletter.

Follow Us