Mac Excel Introduction

Course Contents

Spreadsheet Principles

• What is a spreadsheet?

Screen Layout

• Navigation with Excel, Menus, Toolbars or Ribbons(V2007), Spreadsheets etc

Entering Data

• Entering Text, Numbers, Dates
• Entering Auto Lists
• Deleting
• Editing
• Selecting data
• Moving and Copying
• Viewing the Clipboard
• Inserting new columns and new rows

Navigation

• Using the Scrollbars and Mouse
• Using the Keyboard
• Go To

Creating Formulae

• Concept
• Creating Formulae
• Editing
• Bodmas : Mathematical Order
• Copying Formulae

Functions

• Concept
• Using the AutoSum Icon
• Common Functions Sum, Min, Max, Average, Count

Cell References

• Concept
• Relative references
• Absolute references

Formatting

• Formatting Cells
• Number formats
• Changing font type and size
• Text alignment and orientation
• Wrapping text
• Applying borders and shading
• Autoformat
• Conditional formatting
• Format Painter
• Clearing Formats
• Formatting Columns and Rows

Printing

• Page Orientation
• Adding Headers and Footers
• Printing a selection
• Setting a print area
• Shrink to Fit
• Adjusting page breaks within Page Break Preview
• Repeating columns and rows
• Printing Gridlines
• Setting a print area