Microsoft Excel Advanced – Data Analysis
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.
Course Details
Advanced
10 Students (max)
1 Day Training Course
9:00am -4:00pm
$480+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.
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
Learn Today Face to Face Online with Keystroke Learning
Today
Face to Face
Online
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