This course covers the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.
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.