Microsoft Excel – Intermediate / Advanced

Business

This course covers the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

Course Content

This course will help you learn how to work more effectively with Excel workbooks and worksheets. 

Using hands-on exercises, topics include logical and date functions, advanced formatting, absolute referencing, charting, data list creation, management and analysis methods and more advanced data entry and workbook set-up techniques.

Skills and techniques you will learn during the course include:

  • Data validation
  • PivotTables and Pivot Charts
  • Lookup and Reference Functions
  • Linking Data
  • Financial Functions
  • Recorded Macros

Free to students enrolled in BSBITU402 with Work & Training.

Upcoming Courses

15
August

Moonah

Microsoft Excel - Intermediate / Advanced

1 Bowen Rd, Moonah TAS 7009

Time: 9.30am – 2.30pm | Facilitator: Jessica Dean | Cost: $150