Learn Pivot Tables in Microsoft Excel

Creating Pivot Tables in Excel: Course Outline

• Creating a PivotTable Report
• Refreshing a PivotTable Report
• Changing the Summary Function
• Adding New Fields to a PivotTable Report
• Using Expand and Collapse Buttons
• Hiding/Unhiding PivotTable Report Items
• Inserting Slicers 
  
• Creating Report Filter Pages
• Creating a PivotChart Report
• Exercise – Creating/Revising PivotTables

Top 5 Reasons to Learn Excel Pivot Tables:

1. Excel Pivot Table and Pivot Charts allow you to look at the same data in a completely different way.Now you can group the information by departments, by Days, Months, Quarters, Years, and summarize information at a higher level, or drill it down to the lowest level available.

2. Secondly, you do not need to do any IT programming to create or use a pivot table. That means that you can do the analysis and reporting on your own, without anyone’s help. All your slice and dice can happen in seconds, on the fly, exactly the way you want it.

3. Thirdly, it hardly takes a few minutes to create a pivot table. This is a great time saver for the data warriors, or sales/marketing people who spend their time on the road, but want the control to look at their data quickly, in a way that suits them. And once the Pivot Table is created, you don’t have to create it again. You can save the file along with the data and the pivot table. Whenever you open the Excel data file, the Pivot Table would be automatically loaded, and refreshed too.

4. Fourthly, a Pivot Table is somewhat like having a Business Intelligence (BI) tool – like Hyperion, Tableau, SAP B1, Cognos or Crystal Reports and other heavy-duty, huge price tag products. You can analyze data in numerous ways, slice and dice it, sum it, count it, compare it with other years, areas, departments etc. with ease.

And last but not the least, an Excel Pivot is a Dynamic Report and can be extended with Conditional Formatting, Pivot Charts, Sparklines etc. to really make meaningful dashboards for presenting to the management.

I would say that a sound knowledge of Excel Pivot Tables is a Must for every Excel User. It will elevate your level from just a casual user, to an Excel Power Analyst – someone who can convert raw data into information – actionable information.

Can you create a pivot table from scratch?

If not, do not worry. You can learn How to use Pivot Tables in Excel – by attending the Intellisoft Infographics & Data Visualization or the Advanced Excel 365 – 2 Day Training Class in Singapore.

The 2-day Advanced Excel training classes are more of working sessions – where you learn Pivot Tables by Doing it Yourself!

Pivot Tables are covered in detail in our 2 Day Advanced Excel workshops.

We also cover the Advanced Features of Pivot Tables in our 2 Day Excel Pivots Charts, and Dashboards Masterclass.

Basic knowledge of Microsoft Excel is sufficient for this training program.

You must know how to start Excel, key in numbers, text, and do simple arithmatic. You should know the basic functions like Sum, Count etc.

Prior knowledge of Pivot Tables is not required.

We will teach the Pivot Tables to You, as a complete beginner, and make you an Expert in using Pivot Tables in no time!

This pivot table training program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of pivot table features of Excel to become more productive and make the most of Excel.

The course is designed for people who want to analyze data using the rich features provided in Excel. It will impart the necessary skills to analyze data with pivot tables.