Excel 2016 for PC – Pivot Tables

Overview:

This excellent Excel 2016 for PC – Pivot Tables course will get you up to speed with using Pivot Tables on Excel 2016. The course will teach you how to develop a whole new appreciation for the information in your spreadsheets and gain insights into what it might mean. You’ll also learn how to create Pivot Charts, Sparklines and other elements to better visually represent your data. This course is taught by an expert instructor with years of experience, who has an abundance of insider knowledge to share with you.

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

• Explore dynamic worksheets that can be reorganised by the user, with data generated from a database or a table
• Create, change, and format Sparklines, and learn to create and change slicers
• Understand how to select the appropriate data for a Pivot Table
• Learn to print Pivot Tables, understand printing options, and how to copy Pivot Tables

Course outline:

• Module 01: Getting Started
• Module 02: Creating & Deleting
• Module 03: Custom Appearance & Layout
• Module 04: Printing Options & Copying a Pivot Table
• Module 05: Summarizing with Totals & Formulas
• Module 06: Refreshing Data
• Module 07: Pivot Charts
• Module 08: Sparklines & Slicers

What are the requirements?

• You must be 16 or over
• You should have a basic understanding of English, Maths and ICT
• You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

• You will have one assignment. Pass mark is 65%.
• You will only need to pay £19 for assessment.
• You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

What Certification am I going to receive?

Those who successfully pass this course will be awarded a Excel 2016 for PC – Pivot Tables certificate. Anyone eligible for certification will receive a free e-certificate, and printed certificate.

What careers can I get with this qualification?

With this course, you are able to fulfil various roles, such as:

• Administration
• Reception
• Accounting
• Bookkeeping
• Business ownership
• PA professionals