Provides basic knowledge of Microsoft Excel; create new workbooks, enter and format data, perform basic calculations and set-up the spreadsheet for printing.

For those who use Excel but struggle with basic calculations such as entering simple formulas, using the AutoSum and basic functions.

Provide more tools to manipulate data easily, such as naming ranges, using date/time and IF functions, linking sheets and books, standard database tools such as sorting and filtering, working with multiple sheets and creating 3D formulas.

Provide the student with the knowledge to create charts and present data efficiently.

Students will use a set of tools to analyse data captured in a database, summarize values and present it in way that is easy to read in either data form or through a chart

Learn a full understanding of functions, how they can be nested into each other in order to manipulate data.