TOUR OF EXCEL

• Starting Excel
• The Word screen
• Using tabs and ribbons
• Backstage View
• Dialog boxes
• Using the Quick Access Toolbar

CREATING A NEW WORKBOOK

Typing text and numbers

• Typing dates
• Typing formulas
• Saving a new workbook
• Frequently used formulas
• Saving a new workbook
• Checking spelling
• Printing options
• Using workbooks
• Navigating
• Using Go To
• Data editing
• Overwriting cell contents
• Editing in the formula bar
• Clearing data and formatting in cells

SELECTING TECHNIQUES

• Selecting contiguous ranges
• Selecting non-contiguous ranges
• Selecting rows and columns
• Using ranges with the keyboard

FORMULAS

• Understanding how formulas work
• Creating formulas for multiplication, division, addition and subtraction
• SUM function
• AVERAGE function
• MIN and MAX functions
• COUNT function
• Entering and editing a function manually

COPYING DATA

• Fill and AutoFill commands
• Copying from one cell to another
• Copying relative formulas
• Drag and drop moving

FORMULA REFERENCING

• Absolute versus relative referencing
• Creating absolute references
• Creating mixed references

FONT FORMATTING

• Live Preview
• Changing font style, size and colour
• Bold, italic and underlining
• Changing background colour
• Using the Format Painter

CELL ALIGNMENT

• Aligning right, centre and left
• Rotating text
• Indenting cells
• Vertical alignment
• Wrap text
• Row and column formatting

COLUMN WIDTH AND ROW HEIGHT

• Hiding rows and columns
• Unhiding rows and columns

NUMBER FORMATTING

• Applying general formatting
• Currency formatting
• Percentages formatting
• Date formatting
• Using the thousands separator

PRINTING

• Print Preview
• Printing a selection
• Printing an entire workbook
• Specifying the number of copies

CREATING CHARTS

• Creating a new chart
• Choosing the chart type
• Modifying an embedded chart
• Changing the chart type, layout and style
• Resizing and dragging a chart
• Pasting a chart in Word or PowerPoint