Course Objectives

• Learn basic formulas and functions to improve office productivity
• Perform calculations, work with different types of charts and summarise data

Course Structure

• Shortcut keys
• Multiple worksheets
• Data entry
• The use of relative, absolute and mixed references in formulae
• Functions: SUM, AVERAGE, MIN, MAX, COUNT(A), ROUND, IF, AND, OR, NOT
• Formatting, custom number formats, conditional formatting & format painter
• Comments
• Freeze panes
• Manipulating dates
• Names
• Data validation
• Charting
• Data tables
• Protecting cells and worksheets
• Templates
• Form controls
• Basic macros
• Printing
• Solutions