| 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. FSKDIG03 Use digital technology for routine workplace tasks BSBITU402 Develop and use complex spreadsheets
Westfield Penrith on Tuesday
Beginning 3/12/2019 from 9:30:00 to 17:30:00
for 1 Day
$152 Your training may be subsidised by the NSW Government. Contact the College to check your eligibility.
** This Course is Nationally Recognised Accredited Training. See the Description for the Units of Competency included **
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.
Items to be purchased during the course
Special Issues To Note
Workshop, no concession
NCC Code: 82EX3M419