| 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 2/12/2018 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
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