Microsoft Excel Advanced, South Melbourne - What's On St Kilda
Skip to main content

Microsoft Excel Advanced

Work with Excel’s advanced features, including PivotTables and Data Consolidation. You will also create templates and work with Macros.

About this Event

Take your skills to the next level to get more out of Excel’s advanced features, including PivotTables and Data Consolidation. You will also build on your existing knowledge by exploring worksheet and workbook protection. Work on spreadsheet automation by recording macros, then edit your macros for even greater functionality and flexibility.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding automation to their workbook tasks.

This is an advanced level course.

What you get

  • Class size kept to a maximum of 10 participants.
  • Average class is 4-6 people.
  • Qualified, experienced and approachable facilitators.
  • Training materials and take away practice files.
  • Lifetime post course support.

We encourage you to bring along your own laptop so you are familiar with its layout and functionality. If you do not have a laptop, we can supply one on the training day.

Microsoft Excel Advanced Workshop 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
  • Using Slicers

Advanced PivotTable Features

  • 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

If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.

See here for terms and conditions.

Due to COVID-19 some events may be operating differently than planned.
Please contact the event organiser directly to confirm.

Category Business

Please contact the event organiser directly for accessibility information.