Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features

Microsoft Excel - Level 3

Excel Advanced Analytical Features
Get the most out of your online learning experience with premium one-on-one tutor sessions.
Click here to find out more.

Overview

What to expect in this course

NZD 346.50 +GST
NZD 346.50 +GST
Learn more

Topics covered

Logical and lookup functions
Advanced formulas
Analysis
Special functions
Importing and exporting
Macros and forms
Learn more

Get certified with Skills Campus

Use function to make decisions and to return information from arrays and tables
Find and trap errors, control formula options, and use array formulas and functions
Perform calculations on dates, manipulate text, and use some statistical and financial functions
Import or create a connection to external data, use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
Perform what-if analyses by using a watch window, scenarios, and the Goal Seek utility; and use some of the tools available in the Analysis Toolpak
Record and run macros, and create a simple form
Learn more
Level: Advanced
8
Min. study hours
Classroom trainer-led learning
Introductory price
NZD 364.50 +GST
Buy now

Overview

Topics covered

Logical and lookup functions
Advanced formulas
Analysis
Special functions
Importing and exporting
Macros and forms
Learn more

After completing this course, you will know

Use function to make decisions and to return information from arrays and tables
Find and trap errors, control formula options, and use array formulas and functions
Perform calculations on dates, manipulate text, and use some statistical and financial functions
Import or create a connection to external data, use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
Perform what-if analyses by using a watch window, scenarios, and the Goal Seek utility; and use some of the tools available in the Analysis Toolpak
Record and run macros, and create a simple form
Record and run macros, and create a simple form
Learn more
Level: Advanced
8
Min. study hours
Classroom trainer-led learning
(Full day - 8 hours)
Introductory price
NZD 364.50 +GST
Buy now
Online live trainer-led learning
(Two half days - 4 hours)
Introductory price
NZD 346.50 +GST
Buy now
Online self-paced learning
Introductory price
NZD 346.50 +GST
Buy now

Overview

Topics covered

Logical and lookup functions
Advanced formulas
Analysis
NZD 346.50 +GST
NZD 346.50 +GST
Special functions
Importing and exporting
Macros and forms
Learn more

After completing this course, you will know

Use function to make decisions and to return information from arrays and tables
Find and trap errors, control formula options, and use array formulas and functions
Perform calculations on dates, manipulate text, and use some statistical and financial functions
Import or create a connection to external data, use Power Pivot and cube functions to access information in the Power Pivot Data Model, and export Excel worksheets to other formats
Perform what-if analyses by using a watch window, scenarios, and the Goal Seek utility; and use some of the tools available in the Analysis Toolpak
Record and run macros, and create a simple form
Record and run macros, and create a simple form
Learn more
Level: Advanced
8
months
Online self-paced learning
Introductory price
NZD 364.50 +GST
Buy now

Meet your trainer

Feroze Ashraff
CISSP, CASP, MCSE - IT Security Expert
Feroze Ashraff has been tinkering with IT hardware for over 30 years and teaching for over 18 years. To give you an idea how long that is, his first computer had an awesome 486 processor with a monochrome monitor. He has a master’s degree in security and professional IT certificates from vendors such as CompTIA, Cisco and Microsoft.

CompTIA and uCertify - Why should you trust them?

The CompTIA A+ certification validates skills needed for entry-level IT jobs. It covers a broader diversity of knowledge required of technicians today, making A+ relevant to many more job roles.
Level of difficulty
2/6
Popularity
5/6
Cost of exam
$452* USD
*Two exam at $226 USD each

Meet your trainer

Feroze Ashraff
CISSP, CASP, MCSE - IT Security Expert
Feroze Ashraff has been tinkering with IT hardware for over 30 years and teaching for over 18 years. To give you an idea how long that is, his first computer had an awesome 486 processor with a monochrome monitor. He has a master’s degree in security and professional IT certificates from vendors such as CompTIA, Cisco and Microsoft.

CompTIA and uCertify - why should you trust them?

CompTIA IT Fundamentals (ITF+) is an introduction to basic IT knowledge and skills that helps professionals decide if a career in IT is right for them. It also helps organizations prepare non-technical teams for digital transformation
Level of difficulty
1/6
Popularity
5/6
Cost of exam
$125 USD

Meet your trainer

Feroze Ashraff
CISSP, CASP, MCSE - IT Security Expert
Feroze Ashraff has been tinkering with IT hardware for over 30 years and teaching for over 18 years. To give you an idea how long that is, his first computer had an awesome 486 processor with a monochrome monitor. He has a master’s degree in security and professional IT certificates from vendors such as CompTIA, Cisco and Microsoft.

CompTIA and uCertify - why should you trust them?

CompTIA Security+ is the first security certification IT professionals should earn. It establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cyber security jobs.
Level of difficulty
4/6
Popularity
5/6
Cost of exam
$349 USD
More About
Course outlines
Discover more details about your course.
Download now

MentorPlus+

Get the most out of your learning with face-to-face mentoring provided by experienced mentors.

Find out more

Looking for something specific or in need of tailored training solutions for your business? Get in touch with us today!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.