Excel 2007 - Tutorials

The New Interface mini excel icon

  • Navigate the New Interface
  • Explore Interface Tabs
  • Customise Q A Toolbar
  • Explore the New Office Button
  • Explore the mini toolbar
  • Customise Excel
  • Format Tables
  • Save in a different Version image of a mini pdf icon

Formulas mini excel icon

  • Basic Formulas
  • Order of Preference
  • Relative Referencing
  • Absolute Referencing
  • Formula Ribbon image of a mini pdf icon

Advanced Functions mini excel icon

  • Concatenate Function
  • Sum If Function
  • Vlookup & Hlookup Functions
  • If Functions image of a mini pdf icon

Formatting Tables mini excel icon

  • Insert, Columns Rows &Tables
    Delete, Rename, Add, Worksheets
  • Adjust size of Columns and Rows
  • Use Set Formats for Tables
  • Freezing Rows &Columns
  • Modifying Rows and Columns
  • Formatting Fonts
  • Use Colour
  • Apply and Remove Filters
  • Format Cells(set condition of cells) image of a mini pdf icon

Basic Functions mini excel icon

  • Explore the Function Tools
  • Use AutoSum Functions - Add & Max
  • Turn off AutoFormat Settings
  • Use Text Functions Trim, Left & Upper. Download image of a mini pdf icon



CTRL D to Bookmark
AddThis Social Bookmark Button

resources icon
image of adobe acrobate reader icon


You will need Adobe reader to view the lessons, get the latest one free for your computer.

chart image 1
Chart sample image