Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration

Microsoft Excel - Level 2

Excel Data Management and Collaboration
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 337.50 +GST
Learn more

Topics covered

Managing workbooks
Named ranges
Tables
Presentation features
Advanced charts
Summarising data
Pivot tables
Collaboration
Learn more

Get certified with Skills Campus

How to manage workbooks and customize the Excel environment
How to use named ranges in formulas
About Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns
How to use special chart features, how to insert sparklines to take snapshots of data, and how to use Quick Access features to conveniently analyze data
How to consolidate data from more than one range or workbook, and how to use subtotals
How to use PivotTables to summarize and rearrange large amounts of data in a list, and how to use PivotCharts to present such data
How to use conditional formatting to format data when it meets a condition, how to create custom number and date formats, and how to insert and manipulate graphics
How to use permissions to control access to and prevent changes in your workbooks, and about sharing features, such as comments and change tracking
Learn more
Level: Intermediate
8
Min. study hours
Classroom trainer-led learning
Introductory price
NZD 355.50 +GST
Buy now

Overview

Topics covered

Managing workbooks
Named ranges
Tables
Presentation features
Advanced charts
Summarising data
Pivot tables
Collaboration
Learn more

After completing this course, you will know

How to manage workbooks and customize the Excel environment
How to use named ranges in formulas
About Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns
How to use special chart features, how to insert sparklines to take snapshots of data, and how to use Quick Access features to conveniently analyze data
How to consolidate data from more than one range or workbook, and how to use subtotals
How to use PivotTables to summarize and rearrange large amounts of data in a list, and how to use PivotCharts to present such data
How to use conditional formatting to format data when it meets a condition, how to create custom number and date formats, and how to insert and manipulate graphics
How to use conditional formatting to format data when it meets a condition, how to create custom number and date formats, and how to insert and manipulate graphics
Learn more
Level: Intermediate
8
Min. study hours
Classroom trainer-led learning
(Full day - 8 hours)
Introductory price
NZD 355.50 +GST
Buy now
Online live trainer-led learning
(Two half days - 4 hours)
Introductory price
NZD 337.50 +GST
Buy now
Online self-paced learning
Introductory price
Buy now

Overview

Topics covered

Managing workbooks
Named ranges
Tables
Presentation features
NZD 337.50 +GST
Advanced charts
Summarising data
Pivot tables
Collaboration
Learn more

After completing this course, you will know

How to manage workbooks and customize the Excel environment
How to use named ranges in formulas
About Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns
How to use special chart features, how to insert sparklines to take snapshots of data, and how to use Quick Access features to conveniently analyze data
How to consolidate data from more than one range or workbook, and how to use subtotals
How to use PivotTables to summarize and rearrange large amounts of data in a list, and how to use PivotCharts to present such data
How to use conditional formatting to format data when it meets a condition, how to create custom number and date formats, and how to insert and manipulate graphics
How to use conditional formatting to format data when it meets a condition, how to create custom number and date formats, and how to insert and manipulate graphics
Learn more
Level: Intermediate
8
months
Online self-paced learning
Introductory price
NZD 355.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.