Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

Name: Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables
Availability: InStock

Learn how to develop and apply formulas and perform useful data analysis with this free online Microsoft Excel training.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

List the most frequently used lookup and decision formulas
Outline the methods for creating and applying formulas in a spreadsheet to locate specific data
Identify the correct formula for calculating a specific value, counting cells, or adding the provided data
Explain the syntax of several new Excel functions
Discuss the concept of named ranges
Outline the tools that can be used to customize the named ranges
Recognize the range operators that appear in the formula syntax
Describe the operations that may be performed within an Excel table
Discuss the mechanics of a pivot table and its capabilities
Summarize the steps for counting, averaging, and running totals with pivot tables
Explain how to use filters, slicers, timelines, and pivot charts to display dynamic views of data
Describe the process of creating a pivot chart

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.