(03) 9999 7780

(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

(03) 9999 7780

Training Centre

[email protected]

Keystroke Learning - Main Menu
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 
Advanced – Data Analysis

Microsoft Excel
Advanced – Data Analysis

Microsoft Excel Computer Training Course

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.

Course Details

Course Skill Level

Advanced

Class Size

6 Students (max)

Course Duration

1 Day Training Course

Class Times

9:00am -4:00pm

Price

$350+GST

Upcoming Public 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.

Download Course Outline (PDF)
Download

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
Keystroke Learning - Building Computer Skills to Enable Success

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 @ info@keystrokelearning.com.au

Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
Contact Us
Go
Keystroke Learning - Building Computer Skills to Enable Success

© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759

Privacy Policy      Terms and Conditions

Melbourne Training Venue

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Call (03) 9999 7780

Keystroke Learning - Building Computer Skills to Enable Success

Log in