Microsoft Excel Training Melbourne - Blank Page
Microsoft Excel Training Melbourne - Blank Page
Microsoft Excel Training Melbourne - Blank Page
Microsoft Excel Training Melbourne - Blank Page

Microsoft Excel Training Courses

Microsoft Excel is the most widely used spreadsheeting application in the world today. It has a wide range of features available for every-day office documents and professional spreadsheets with complex calculations and Macros.

Microsoft Excel Basic

1 day course available

Get up to speed quickly by learning about the following topics:

  • Excel Environment
  • Excel Views
  • Entering Data
  • Constructing basic Formulas & Functions
  • Construct basic Formulas between Worksheets and Workbooks.
  • Copy and Paste data and formulas
  • Apply formatting
  • Page Setup & Printing
Course Outline (PDF)

Microsoft Excel Intermediate

1 day course available

Improve your Excel skills by learning about the following topics:

  • Time savers and shortcuts
  • Formulas
    • Relative and Absolute references
  • Functions
    • Commonly used functions
    • Date and Time functions
    • Logical functions
    • Finding and correcting errors
  • Custom formats
  • Outlining
  • Charts
  • Data Validation
Course Outline (PDF)

Microsoft Excel Advanced

1 day course

Take your Excel skills to the next level by learning about the following advanced topics:

  • Using Names
  • Using Tables
  • Advanced Functions
    • IF
    • AND / OR
    • IS
    • VLOOKUP
  • Advanced Sorting and Filtering
  • PivotTables
  • PivotCharts
  • Basic Macros
Course Outline (PDF)

VBA for Microsoft Excel

2 day course

Make Excel jump through hoops and automate any repetitive tasks by learning about the following topics:

  • Record Macros
    • Absolute Macros
    • Relative Macros
  • Using the VBA Editor
    • Project Explorer
    • Setting Break Points
    • Using Bookmarks
    • Stepping through Procedures
    • Running Macros
  • VBA Theory and Terminology
  • Creating Procedures
  • Using Variables
    • Variable Declarations
    • Variable Scope
    • Arrays
  • Using Excel Objects
    • Methods, Properties and Events
  • Programming Techniques
    • Using Message Boxes
    • Using IFs
    • Using Loops
  • Custom user Functions
  • Creating Custom Forms
  • Event-driven Procedures
  • Error Handling
Course Outline (PDF)