MS Excel, Microsoft Excel Training Courses

Microsoft Excel, or MS Excel, remains one of the most powerful and versatile office tools. Among the most common business uses are: business analysis, people management and managing operations.

Here are some short but intense training courses to show you the power of MS Excel and quickly bring your skills up to speed.

Microsoft Excel 2007 – Level 1

Duration: 1 Day, Class Size: Max 10 Students, Time: 9.00am – 4.30pm, Price: $350 incl GST

This introductory course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel effectively.  It is ideal for people who need to produce reports, budgets and lists.

Who Should Attend: 

This course is primarily designed for people who need to know how to use Microsoft Excel. It is ideal for people who need to produce reports, budgets, lists and the like.

Course Pre-requisites: 

This course is intended for people who have had minimal or no exposure to MS Excel. However, a general understanding of computers and the Windows operating system would be beneficial.

Course Objectives: 

At the completion of this course participants will be able to:

  • work within the basic Excel environment
  • create a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand, create and work with formulas and functions used to perform calculations
  • understand and use formula cell referencing to create more complex formulas
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use font formatting techniques to greatly enhance the look of a worksheet
  • align the contents of cells in a number of ways
  • format rows and columns in a worksheet
  • understand and use the number formatting features in Excel
  • print your workbook data
  • create effective charts in Microsoft Excel

Course Content: 

  • Getting to Know Excel
  • Creating a New Workbook
  • Working with Workbooks
  • Editing in a Workbook
  • Formulas and Functions
  • Formula Referencing
  • Selecting Ranges
  • Copying Excel Data
  • Font Formatting
  • Cell Alignment
  • Row and Column Formatting
  • Number Formatting
  • Printing
  • Creating Charts

Microsoft Excel 2007 – Level 2

Duration: 1 Day, Class Size: Max 10 Students, Time: 9.00am – 4.30pm, Price: $350 incl GST

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, and perform analysis using functions and to use the sorting and filtering features to manage and analyse data.

Who Should Attend: 

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Students should have already completed Excel 2007 Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.

Course Pre-requisites: 

This course is aimed at participants with a working knowledge of Microsoft Excel who wish to extend their understanding of the automated and time saving features of the application.

Course Objectives: 

At the completion of this course participants will be able to:

  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • use a range of formula techniques
  • use a range of logical functions
  • apply a range of number formatting techniques to data
  • apply conditional formatting to ranges in a worksheet
  • apply borders to cells and ranges
  • work with various elements of a worksheet
  • use a range of techniques to work with worksheets
  • use a range of find and replace techniques
  • apply a variety of page setup techniques
  • sort data in a list in a worksheet
  • filter data in a table
  • use a range of techniques to enhance charts
  • apply formatting techniques to text on charts

Course Content: 

  • Filling Data
  • Moving Data
  • Formula Techniques
  • Logical Functions
  • Number Formatting Techniques
  • Conditional Formatting
  • Applying Borders
  • Working with a Worksheet
  • Worksheet Techniques
  • Finding and Replacing
  • Page Setup
  • Sorting Data
  • Filtering Data
  • Charting Techniques
  • Chart Text Formatting

Microsoft Excel 2007 – Level 3

Duration: 1 Day, Class Size: Max 10 Students, Time: 9.00am – 4.30pm, Price: $350 incl GST

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. It includes advanced analysis tools, especially pivot tables, Solver, outlining and summarising and automating workbook operations using macros.

Who Should Attend: 

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.Students should of already completed Excel Level 1 & 2 courses or should know how to create and save excel workbooks, create formulas, use functions and perform simple formatting of the data before doing this course.

Course Pre-requisites: 

Good working knowledge of Microsoft Excel to an intermediate level. Students should already know how to create and save workbooks, create formulas, use functions and perform simple formatting.

Course Objectives: 

At the completion of this course participants will be able to:

  • use a range of lookup and reference functions
  • modify Excel options
  • create and use labels and names in a workbook
  • protect data in worksheets and workbooks
  • summarise data using subtotals and relative range naming
  • use data linking to create more efficient workbooks
  • use the Data Consolidation feature to combine data from several workbooks into one
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • use goal seeking to determine the values required to reach a desired result
  • group cells and use outlines to manipulate the worksheet
  • use Solver to solve more complex and intricate problems
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros

Course Content: 

  • Lookup Functions
  • Setting Excel Options
  • Chart Object Formatting
  • Labels and Names
  • Protecting Data
  • Summarising and Subtotaling
  • Data Linking
  • Data Consolidation
  • PivotTables
  • PivotTable Techniques
  • PivotCharts
  • Goal Seeking
  • Grouping and Outlining
  • Solver
  • Recorded Macros
  • Recorder Workshop