For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Mastering Data Analysis

Who it's For:

Office workers, business people, teachers, support staff, and anyone who wants to use the computer to track, figure out, and report information.

What it is:

Excel is the world's most popular spreadsheet program, and these videos show how you can master data analysis while working in this popular program.

What You'll Learn:

This course will teach you how to use some of the tools built into Excel that enable you to mine the answers hidden in your data records and unlock the analysis power of Excel.

Topics

  • Introduction
  • Converting Records Lists into Tables
  • Sorting and Filtering Records
  • Using Summary Based IFs Functions