| Computers : Excel Advanced
Is your business ready to take it's spreadsheet to the next level? This course will cover spreadsheet development and include linked spreadsheet solutions, automation and standardisation of spreadsheet operation, data import and export and graphing using numerical data. BSBITU402 Develop and use complex spreadsheets FSKDIG03 Use digital technology for routine workplace tasks
Westfield Penrith Weekend on Sunday Weekends
Beginning 30/6/2019 from 9:30:00 to 17:30:00
for 1 Day
Topics Covered include:
Identify task and purpose, audience and presentation requirements. Using technology perform and review task Learn the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents Analyse task and determine specification for spreadsheets, identify task requirements, data entry, storage, output, reporting and presentation requirements Utilise spreadsheet design functions and formulae, link spreadsheets, format cells and test formulae Learn the skills and knowledge required to use digital technology to undertake routine workplace tasks Create, use and edit macros, develop edit and use templates Enter, check and amend data, import and export data between compatible spreadsheets, use manual and online help to overcome problems, preview, adjust and print spreadsheet Determine style of graph, create graphs with labels and titles, save view and print
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