(03) 9999 7780

Call for Queries?

Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 1 Day Advanced

Microsoft Excel 1 Day

Advanced

Microsoft Excel Computer Training Course

Course Overview

On this 1 day Excel Advanced course, participants will add to their already extensive knowledge to gain an understanding of Excel’s advanced features, including PivotTables and Data Consolidation, Protection, as well as Recording Macros.

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.

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.

Once you’ve completed this course, you may also want to attend our Excel Advanced Data Analysis course.

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.

Once you’ve completed this course, you may also want to attend our Excel Advanced Data Analysis course.

Course Details

Course Skill Level

Advanced

Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

1 Day Training Course

Class Times

9:00am – 4:00pm

Your Course Includes

Price

$550.00

Upcoming Public Courses

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

Data Consolidation
  • Linking to Source Data
  • Consolidate by Position
  • Consolidate by Category
Creating PivotTables
  • Building a PivotTable Shell
  • Adding Fields
  • Grouping Items
  • Filtering
  • Drilling Down
  • Changing Layouts
Advanced PivotTable Features
  • Using Slicers
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages
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
Workbook Protection
  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files
Building Templates
  • Using Existing Templates
  • Creating Templates
  • Modifying Templates

*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