Microsoft Excel Advanced – Data Analysis

Microsoft Excel

Advanced – Data Analysis

Course Overview

On this Excel Advanced – Data Analysis 1 day course, participants will add to their already extensive knowledge to gain an understanding of Excel’s advanced features, including Arrays and What If Analysis, as well as other useful features.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding some automation to their workbook tasks.

Am I Ready For This Training?

Participants should have a thorough understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Microsoft Excel Intermediate training course, or have solid experience using Excel Spreadsheets, including creating formulas, using functions, and working with data, including sorting and filtering.

Course Details

Course Skill Level

Advanced

Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

1 Day Training Course

Class Times

9:00am – 4:00pm

Your Course Includes

Price

$550.00

Upcoming Public Courses

Courses

There are no upcoming courses at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

Read our Course Terms and Conditions

Course Content

Working with Range Names

Naming Ranges
Navigating with Range Names
Using Range Names in Formulas
Modifying Range Names

Preparing your Data

Working with Raw Data
Converting Lists to Tables

Working with Arrays

Creating Arrays
Modifying Arrays
Trend Functions
Other Array Functions

Using SumIF and CountIF

Setting up SumIF Functions
Creating CountIF Functions

What If Analysis

Goal Seek
Data Tables
Scenario Manager
Solver

Using IFError

Uses for the IFError Function
Applying the IFError Function

Validating Data

About Data Validation
Setting up Validation Rules
Input Messages
Error Alerts

*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.

Learn Today Face to Face Online with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily.

When you complete our training course, you will be ready to apply your new skills right away.

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us at info@keystrokelearning.com.au

(03) 9999 7780

Training Centre