Course Outline - 1 Day

Revision of Excel Essentials

• Worksheet essentials
• Entering text and numbers
• Inserting & deleting columns & rows

Using Autofill Effectively

• Copying cells
• Work with series (AutoFill)

Essential Formulas in Excel

• Creating a formula
• Simple formulas
• Mathematical Operators (+. -, *, /)
• BODMAS

Essential Functions in Excel

• Use AutoSum
• Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)

Understanding the need for
Relative & Absolute Cell References.

•  Relative and Absolute cell referencing
• What's the dollar sign all about then?

Making the Spreadsheet Look Good

• Formatting Worksheets in Excel
• Apply predefined number formats
• Modify rows and columns
• Use the Format Painter
• Apply cell borders and shading
• Merge cells and Wrap text

Creating Charts and Graphs in Excel

• Types of chart
• Column, Line & Pie Charts
• Use the Chart Wizard to create a chart
• Simple Formatting

Working with Several Worksheets in Excel

• Creating formulae across sheets
• Linking workbooks
• 3D references

Printing in Excel

• Preview and printing on one page
• Change page orientation
• Set page margins and page breaks
• Set up headers and footers