BIS Safety Software Canada

BIS Safety Software

Excel: Data Analysis with Pivot Tables

Excel: Data Analysis with Pivot Tables is a comprehensive guide to using Pivot Tables as a potent tool for the analysis of voluminous data in Excel. This course will equip you with skills to organize, visualize, and summarize your data effectively using Pivot Tables. Microsoft trainer, Kathy Jones, will be at the helm, guiding you through the intricacies of Excel 2013 and 2016.

Excel: Data Analysis with Pivot Tables

COURSE OVERVIEW

Excel: Data Analysis with Pivot Tables is a course designed to make you proficient in using Pivot Tables for data analysis in Excel. The course provides deep insights into how to summarize, visualize, and tabulate your data with Pivot Tables and is a must-have skill set for anyone using Excel for data storage and reporting. Led by Microsoft trainer Kathy Jones, this course will guide you on the effective use of Pivot Tables in Excel 2013 and 2016.

Upon completion of the course, you will be proficient in:

  • Creating a pivot table from a local data source, multiple local data sources, and external sources
  • Structuring data inside a pivot table
  • Adjusting pivot table options


COURSE TOPICS

The course encompasses the following topics:

  • Data Preparation and Pivot Table Creation
  • Working with Local and External Data Sources
  • Summarizing, Organizing, Filtering, and Formatting Pivot Tables
  • Refreshing and Modifying Pivot Table Data
  • Working with Pivot Charts
ONLINE COURSE DURATION

Estimated completion time is 150 minutes

PASS MARK

The course includes various tests to reinforce the material presented. A minimum score of 80% is required to pass the course. Participants have the option to retake the course up to three times to achieve the passing score. 

CERTIFICATE OF COMPLETION

Upon successful completion of this online course, a certificate of completion will be available for you to download and print.

COURSE PREVIEW

Course Details

Course Length

This course will take roughly 150 minutes

Passing Mark

To pass this training course, you need to score 80% or higher on the quiz

Certificate

Upon the successful completion of this course a certificate with your name will be stored on your profile and available to print

Additional Training Courses

ICC Shipping Lithium Batteries by Ground (US)

ICC Shipping Lithium Batteries by Ground (US)

WB-LITH10UGR This course equips learners with regulatory understanding on the transportation of lithium batteries by ground in the US in line with the 49...

Sécurité incendie : utilisation d’extincteurs – International

Sécurité incendie : utilisation d’extincteurs – International

En cas d'incendie sur votre lieu de travail, sauriez-vous si vous devez l'éteindre ou évacuer les lieux? Si vous choisissez de l'éteindre, savez-vous comment...

Comprehensive Fall Protection Training: Awareness, Donning, and Inspection Package

Comprehensive Fall Protection Training: Awareness, Donning, and Inspection Package

MULTI-COURSE BUNDLE DEAL! --- This Comprehensive Fall Protection Training package provides an in-depth approach to fall protection, highlighting system awareness, harness use, and equipment...