0
  • LOGIN

  • No products in the basket.

Excel Pivot Tables

Overview

Master Excel Pivot Tables and take your spreadsheet skills to the next level, with this complete step-by-step training course.

The Excel Pivot Tables course will equip you with the practical skills to analyse large sets of information quickly and easily using Excel Pivot Tables. It will teach you how to perform a diverse range of tasks such as creating Excel Pivot Table reports, using Pivot Table data for market analytics, identifying trends, and calculating profit.

This course is open to learners of all levels and is ideal for financial and market analysts, administrative assistants, project managers, and anyone whose role involves working with data. Gain in-demand analytical skills and learn up-to-date best practices.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Excel Pivot Tables is fully available to anyone, and no previous qualifications are needed to enrol. All Nano Training needs to know is that you are eager to learn and are over 16.

Course Curriculum

Section 01: Course Introduction
Excel Pivot Tables 00:03:00
Section 02: Data Insights with Pivot Tables
Overview about Store Dataset 00:02:00
Data Insights 00:02:00
Sales Profit Summary 00:03:00
Highlight the Data 00:01:00
Unprofitable Products 00:02:00
Create Crosstabs 00:02:00
Select Regions for Unprofitable Products 00:04:00
Section 03: Real Time Analytics with Pivot Tables
Real Time Analytics and Insights 00:02:00
Search Data for States with Slicers 00:06:00
Finding Trends 00:02:00
Find Data for Specific Date 00:04:00
Section 04: Reporting with Pivot Tables
Reporting Made Easy 00:02:00
Generate Reports with Pivot Tables 00:04:00
Section 05: Target Your Market with Pivot Tables Analysis
Marketing Analytics 00:02:00
Target Your Advertisements 00:05:00
Section 06: Summary
Become Analyst 00:01:00

FREQUENT ASKED QUESTION

It is shown by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the .accordion-body, though the transition does limit overflow.

It is hidden by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the .accordion-body, though the transition does limit overflow.

It is hidden by default, until the collapse plugin adds the appropriate classes that we use to style each element. These classes control the overall appearance, as well as the showing and hiding via CSS transitions. You can modify any of this with custom CSS or overriding our default variables. It's also worth noting that just about any HTML can go within the .accordion-body, though the transition does limit overflow.

Oops! We could not locate your form.