Excel 2013 – Pivot Tables

Product type
Level

Excel 2013 – Pivot Tables

1TRAINING
Logo 1TRAINING

Need more information? Get more details on the site of the provider.

Description

Overview:

This excellent Excel 2013 – Pivot Tables course will teach you to work with pivot tables on Excel 2013. During the course you will explore dynamic worksheets that can be reorganised by the user, with data generated from a database or a table. 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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Overview:

This excellent Excel 2013 – Pivot Tables course will teach you to work with pivot tables on Excel 2013. During the course you will explore dynamic worksheets that can be reorganised by the user, with data generated from a database or a table. 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?

  • Understand the advantages of a Pivot Table
  • Learn the proper terminology of Pivot Tables
  • Customise the appearance of your Pivot Tables
  • Learn to use formulas with Pivot Tables

Course outline: 

  • Module 1. Getting Started
  • Module 2. Creating & Deleting
  • Module 3. Custom Appearance & Layout
  • Module 4. Printing Options & Copying a Pivot Table
  • Module 5. Summarising with Totals & Formulas
  • Module 6. Refreshing Data
  • Module 7. Pivot Charts
  • Module 8. Sparklines and 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 2013 – 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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.