This course is about working more efficiently with workbooks and worksheets, enhancing the appearance of data and worksheets, performing analysis using functions and using the sorting and filtering feature to manage and analyse data.
Who it’s for
This course is intended for current Microsoft Excel 2010 users who wish to extend their knowledge and skills to take advantage of the more complex features.
What you need to know already
You should have completed the Excel Essentials course or know how to create and save an Excel workbook, enter simple formulas and print and chart data
What you will learn and be able to do
Work with multiple workbooks
Format cells, columns and rows in a workbook
Use a variety of viewing techniques to view worksheets
Understand and use absolute referencing in a workbook
Use the fill technique to enter data into cells
Use names and labels
Use of logical functions
Use of Lookup functions
Sort data in lists in a workbook
Use Auto Filter to display data in lists selectively
At the end of this course, you will be able to create, edit and format large or multiple spreadsheets. You will also be able to perform calculations and functions within a workbook, manipulate data lists to maintain and present data in a professional environment.
What you will receive
Upon completion of an assessment you will receive the nationally accredited Unit of Competency BSBADM404A – Develop and use complex spreadsheets
Excel Advanced
What it’s about
This course is about working more efficiently with workbooks and worksheets, enhancing the appearance of data and worksheets, performing analysis using functions and using the sorting and filtering feature to manage and analyse data.
Who it’s for
This course is intended for current Microsoft Excel 2010 users who wish to extend their knowledge and skills to take advantage of the more complex features.
What you need to know already
You should have completed the Excel Essentials course or know how to create and save an Excel workbook, enter simple formulas and print and chart data
What you will learn and be able to do
At the end of this course, you will be able to create, edit and format large or multiple spreadsheets. You will also be able to perform calculations and functions within a workbook, manipulate data lists to maintain and present data in a professional environment.
What you will receive
Upon completion of an assessment you will receive the nationally accredited Unit of Competency BSBADM404A – Develop and use complex spreadsheets
How long will it take you
1 Day
$209 incl. GST With Skills Victoria Funding Check eligibility
$299 incl. GST Full Fee (Classroom Learning)