MS Excel - an introduction

Unlock the power of Microsoft Excel 2003. Excel is a spreadsheet package that provides the tools to access, process, analyse and display numeric and financial information, accurately and professionally.

This is the first of three MS Excel courses offered by Tooling Intelligence, if you already have a basic understanding of Excel you may want to look at our MS Excel Intermediate and MS Excel Advanced courses.

Course outline

  • General Worksheet Techniques
    • Excel Workbooks
    • Toolbars
    • Command Menus
    • Help Menus
    • Creating a Workbook
    • Entering Text and Values
    • Entering Dates and Times
    • Editing Data
    • Copying and Moving Data
    • Undo / correcting Mistakes
  • Creating Formulas
    • Entering Formulas
    • Mathematical Operators
    • Mixed and Absolute Cell References
    • Built in Formulas
    • AutoSum Tool
  • Copying and Filling
    • Using the Fill Handle
    • Customised Lists
  • Worksheet Appearance
    • Changing Fonts
    • Adding Borders and Shading
    • Changing Column Widths and Row Heights
    • Inserting Columns and Rows
  • File Management
    • Opening Workbooks
    • Saving Workbooks
  • Printing
    • Previewing and Printing the Workbook
    • Headers and Footers