Lesson 12 of 14 • 26 upvotes • 4:48mins
Pivot tables are a highly useful feature of Microsoft Excel. It helps to concise data and draw conclusions from a large variety of information. This lesson elaborates over what are actually Pivot Table, preparing data for Pivot Table, creating a Pivot table, designing Pivot Table layout with the help of examples and screenshot of Worksheets for a better understanding.
14 lessons • 1h 35m
Overview Of The Course: Microsoft Excel - From Beginner To Becoming A Pro
5:55mins
Introduction To Microsoft Excel
5:36mins
Creating Your First Worksheet
7:20mins
Changing The Layout Of A Worksheet
6:14mins
Formatting Data In A Worksheet
7:07mins
Sorting And Filtering Data In A Worksheet
7:13mins
Inserting Elements In A Worksheet
9:05mins
Working With Charts And Graphs
7:59mins
Inserting A Formulae In Worksheets
9:38mins
Exploring Functions In MS Excel
8:47mins
Exploring VLOOKUP With An Example
6:46mins
Learn How To Create Pivot Tables
4:48mins
How To Create Macros In MS Excel
3:52mins
Beyond Data In MS Excel
5:17mins