Computers : Excel Level 3

This course will provide you with the skills and knowledge to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking and Solver and create and use macros. BSBITU402 Develop and use complex spreadsheets

Westfield Penrith Weekend on Sunday Weekends

Beginning 24/3/2019 from 9:30:00 to 17:30:00

for 1 Day


Topics Covered include:

Use a range of lookup and reference functions and modify Excel options Customise the formatting of charts in Excel Create and use labels and names in a workbook and protect data in worksheets and workbooks Create summaries in your spreadsheets using subtotals Use data linking to create more efficient workbooks and use the Data Consolidation feature to combine data from several workbooks into one Understand and create simple PivotTable reports Construct and operate PivotTables using some of the more advanced techniques Create and edit a PivotChart Group cells and use outlines to manipulate the worksheet, use Solver to solve more complex and intricate problems and create recorded macros in Excel Use the macro recorder to create a variety of macros

Course Outcome

Students will be able to use spreadsheet software to complete business tasks and produce complex documents.

On the first session bring

Notebook and pen. Please wear warm clothing in Autumn and Winter as the air conditioning can be cold.

and purchase during the course

Special Issues To Note

Workshop, no concession




Home | Courses | Enrolment | About Us | RTO Number 1223