Microsoft Excel Archives - Forsythes Training

View our courses

Microsoft Excel Office 365 – Introductory (Face-to-Face)

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBTEC201 Use business software applications from the Business Services Training Package.

Microsoft Excel Office 365 – Introductory (Online Virtual Classroom)

Accredited Virtual

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBTEC201 Use business software applications from the Business Services Training Package.

Microsoft Excel Office 365 – Intermediate (Online Virtual Classroom)

Accredited Virtual

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBTEC302 Design and produce spreadsheets from the Business Services Training Package.

Microsoft Excel Office 365 – Intermediate (Face-to-Face)

Accredited Face-to-face

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBTEC302 Design and produce spreadsheets from the Business Services Training Package.

Microsoft Excel Office 365 – Advanced (Face-to-Face)

Accredited Face-to-face

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBTEC402 Design and produce complex spreadsheets from the Business Services Training Package.

Microsoft Excel Office 365 – Advanced (Online Virtual Classroom)

Accredited Virtual

Using VBA with Excel 2016 (Face-to-Face)

Non-Accredited Face-to-face

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel.

Using VBA with Excel 2016 (Online Virtual Classroom)

Non-Accredited Virtual

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel.

Microsoft Business Document Essentials (Face-to-Face)

Face-to-face

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

FAQs

Pre-Course Assessment questions

Level 1

If you answer “no” to two of these questions, you should consider doing Excel Level One:

Can you create simple formulas in Excel?
Can you use the SUM, AVERAGE, MAX, MIN and COUNT functions?
Can you create a simple chart?

Level 2

If you answer “no” to two of these questions, you should consider doing Excel Level Two:

Can you use the IF and VLOOKUP functions?
Can you use Conditional Formatting?
Can you sort data and apply complex filters?

Level 3

If you answer “no” to two of these questions, you should consider doing Excel Level Three:

Can you create a Pivot Table?
Can you record and edit macros?
Can you link data across workbooks?

Now is the time to get qualified.

Discover our areas of learning.

Forsythes Training is an established, trusted, quality training provider with an extensive list of corporate clients and individuals who have attended our training courses over the last twenty years in a variety of learning areas: