Nationally Recoginised Training
Business Training Courses

Microsoft Excel Intermediate

This course is designed to provide candidates with the skills and knowledge to use intermediate Microsoft Excel functions and formats, including protecting data, range naming and working in more complex worksheets.

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).

Protecting Data
  • Password protection
  • Cell protection
Range Names
  • Use of range naming
  • Defining ranges
  • The autofill feature
  • Applying names
  • Using names in formulas
  • Using constants
  • Pasting names
Group and Outline
  • Group and ungroup data
  • Auto outlining
Working with Multiple Worksheets
  • Calculating across worksheets
  • Inserting and renaming sheets
  • Linking across sheets
  • Linking between workbooks
  • Group mode
 Absolute Cells
  • Absolute cell referencing
  • Partial absolute cells
Advanced Functions and Formulas
  • Calculations using dates
  • The IF statement
  • Rounding functions
  • VLOOKUP function
  • The PMT function
  • Text functions
Lists
  • Creating, modifying lists
  • Sorting and filtering
  • Subtotals



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

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