Microsoft Exel

This course will give learners the opportunity to gain more knowledge, experience and confidence using Microsoft Excel through completion of a wide range of tasks.

Content:

At the end of this course you will be able to:

• Performing common tasks in Excel, such as opening, editing, saving and printing documents.
• Learn how to perform and use formulas and functions such as: ‘IF’, ‘VLOOKUP’, ‘SUM’.
• Formatting a spreadsheet.
• Sorting and filtering.
• Perform Conditional Formatting.
• Create Pivot tables.
• Creating and modifying tables and charts.
• Inserting page borders and headers and footers.