Microsoft Excel Advanced Course

Microsoft Excel Advanced Course

Course Overview

This Advanced Excel course will further enhance on your existing Excel skills.  Increasing your knowledge by understanding advanced functions and productivity tools. Following this course, you will work use a large range of functions.  Analyse data effectively and quickly using Pivot Tables and Charts.  You will gain a practical ability to use Excels productivity tools and Advanced Functions.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.

Delivery Modes

MTA Training Facility in Osborne Park or on-site delivery with you

Requirements

  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.
  • Lunch:  Subway Catering is provided, or you are welcome to bring your own (microwave and fridge available). Tea, Coffee and biscuits available.
  • Parking is available on site, or it is a short walk from Glendalough Train Station.

Duration

Two (2) Days

Content

  • Revision Exercise
  • Defined Names
  • Protecting Data, Worksheets and Workbooks
  • Logical Functions
  • Validating Data
  • Creating Drop Down boxes
  • Lookup Functions
  • Vlookup, Hlookup, Match
  • Summarising Data using Subtotals
  • Grouping and Outlining
  • Data Linking
  • Data Consolidation
  • Pivot Tables
  • Pivot Table Techniques
  • Macros
  • Attach Macros to buttons, Access Tootlbar and Worksheets

Learning Outcomes

At the completion of the program Excel Advanced participants should be able to:

  • Create If Functions to analyse data
  • use logical functions to test whether a statement is true or false
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • create summaries in your spreadsheets using subtotals
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create recorded macros in Excel

If you would like a proposal on how this training may benefit staff of your company, please contact us today.

bd@minetrainingaustralia.edu.au

(08) 9221 1803 OR 1300 354 309

  • Make an appointment to visit: Our administration offices (Level 1, 46 Edward Street, OSBORNE PARK WA 6017)