Learn Excel Pivot Tables in under an Hour!

About this Course:

If you've been tasked with summarising a large amount of data or need to know how to create Pivot Tables look no further. This course will take you from the basics of what is a Pivot Table to creating visually impressive reports with ease.

You'll be able to quickly analyse data from large worksheets into manageable reports. The course will take you through creating a Pivot Table and best practices Grouping data to help when summarising using powerful filtering with Slicers and illustrating your data with Pivot Charts.

Pivot Tables are a great tool to master for any situation or any role where reporting is required.

Basic knowledge:

• You'll need Excel 2010 2013 or 2016 installed and a desire to learn about how Pivot Tables can work for your large data set

Who is the target audience?

• Any Excel user who requires an introduction to Pivot Tables. You should already be familiar with the basics used to working with large amounts of data.

Course Completion Certificate

What you will learn:

• Understand what Pivot Tables are and when to use them
• Create a Pivot Table report
• Utilize the tools available for summarising data
• Work with Slicers and Create Pivot Charts

Curriculum:

• Introduction to Pivot Tables
• Creating Pivot Tables

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.