Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Search
Close this search box.
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 2 Day Advanced

Microsoft Excel 2 Day

Advanced

Microsoft Excel Computer Training Course

Course Overview

On this 2 day Excel Advanced course, explore the advanced capabilities of Excel. Gain expertise in PivotTables, Data Consolidation, and Sheet Protection. Delve into the essentials of Recording Macros, understanding Arrays, and conducting What-If Analysis.

This course reveals a range of other powerful functions within Excel. If you’re looking to elevate your analytical skills and incorporate automation into your Excel projects, this course is for you.

What you need to Bring

  • Laptop with the relevant software installed.

People feel more comfortable using their own laptop, since they will be familiar with its layout and options. Having access to all of your applications and customisations will come in handy through the training.

  • No laptop? Please get in contact with us.

If you don’t have a laptop, please let us know beforehand so we can supply one on the training day.

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

2 Days Training Course

Class Times

9:00am – 4:00pm

Your Course Includes

Price

$770.00

Upcoming Public Courses

Courses

Course Delivery Style

Face to Face Training Delivery

Face 2 Face 

Online Training Delivery

Online

Still Need Approval?

Want to reserve a seat but you still need approval?

No problem, simply call us on (03) 9999 7780 and we will hold a seat for you.  There’s zero risk, if you don’t get approval, we’ll cancel the reservation.

Course Content

Data Consolidation
  • Linking to Source Data
  • Consolidate by Position
  • Consolidate by Category
Creating PivotTables
  • Building a PivotTable Shell
  • Adding Fields
  • Grouping Items
  • Filtering
Recording Macros
  • Preparing Excel for Recording
  • Recording Macros
  • Storing Macros
  • Adding Comments
  • Testing Macros
Absolute vs Relative Macros
  • Absolute and Relative Recording
  • Testing types of Recording
  • Viewing and Editing Macros
  • Drilling Down
  • Changing Layouts
Advanced PivotTable Features
  • Using Slicers
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages
Workbook Protection
  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files
Building Templates
  • Using Existing Templates
  • Creating Templates
  • Modifying Templates
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.

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
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.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success in Melbourne

Melbourne Training Centre

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

Venue Access Hours

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

Are you Running Late???

Skip to content