MS Excel (Level 2)

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways.

The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

Objectives:

• Use the IF function to automate tasks using tests.
• Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data, eg. an expenses sheet that takes the monthly totals and displays them on a summary sheet.
• Filter a spreadsheet to show only the records that meet a specific criteria, eg. all surnames beginning with A.
• Display data in various graphical formats that can be easily understood by anyone not using Microsoft Excel.