Nationally Recoginised Training
Business Training Courses

Microsoft Excel Advanced

This course is designed to provide candidates with advanced Microsoft Excel skills and knowledge including using analysis tools, database lists, sort and filtering features, pivot tables, customise tools and macros.

MCO can offer this program onsite at your workplace as well as offering public scheduled courses at our premises, Unit 4/193 South Pine Road, Brendale, Queensland, 4500.

Note that our public scheduled computer courses generally run for a day, from 9.00 am to 4.00 pm. However, depending on requirements, we can run customised courses to suit employer needs (course cost, overview and duration to be quoted separately).

Analysis Tools
  • Goal seeker
  • Solver
  • Saving scenarios
Macros
  • What is a macro?
  • Recording macros
  • Running macros
  • Editing macros
  • The personal macro workbook
  • Relative cell addressing
  • Creating a macro button
  • Creating a keyboard shortcut
  • Testing the button and shortcut
Pivot Tables
  • Building the pivot table
  • Pivot table wizard
  • Customising the pivot table
  • Create a pivot chart
Advanced Functions
  • Nesting functions
  • Data validation
 Templates
  • Creating the template
  • Saving the template
  • Using the template
  • Add hyperlinks, comments
Excel Lists
  • What is a list?
  • Sorting
  • Data form
  • Searching for records
  • Autofilter
  • Custom filters
  • Advanced filter
  • The subtotal feature
  • Outlining
Customising Excel
  • Tools, options
  • Creating a new toolbar
  • Adding, modifying, removing toolbar buttons
Consolidating
  • Consolidating data
  • Using labels when consolidating



Click here for MCO's schedule of public course costs.

Click here for MCO's schedule of upcoming public course dates.