Course Description

This course describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents.

It applies to individuals employed in a range of work environments who require skills in the creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.

Skills Covered

This course covers the following key areas:

·Spreadsheet design; analysis, appropriateness, avoidance of blank rows and columns , embedding cell references in formulae, formatting and reformatting, functions, headers and footers, headings and labels, identification and parameters, import and export of data, labels, linked formulae, multi-page documents, pivot tables, relative and absolute cell references and split screen operation.

·Functions; basic financial functions, date functions, logical functions, mathematical functions, simple nested functions, statistical functions.

·Formulae; addition, average, comparison, division, exponentiation, multiplication, percentage, subtraction and combinations of above.

·Macros; printing sections of a spreadsheet.

·Importing and exporting; proofreading, reformatting and split screen (if available).

·Graphs; bar, line, pie, scatter, stack and 3D and creating graphs include data range, keys and legends, labels and titles, naming, sizing, using graph menu  and X and Y axis.

Accredited Courses BSBITU402 Develop and use complex spreadsheets