Office 2010 Training Manuals – Excel Word 2010 Foundation Courseware

Office 365 training materials from the Cheltenham Group
Free Samples

Microsoft Excel 2010 Foundation Training Course Teaching Materials

Computer Courseware Training Materials

Training Course Outline

Using Excel 2010

  • The Excel Cell Referencing System
  • Entering Numbers and Text
  • Summing a Column of Numbers
  • Entering a Date
  • Worksheets and Workbooks
  • Saving a Workbook
  • Creating a New Workbook
  • Opening a Workbook
  • Switching between Workbooks
  • Help

Selection Techniques

  • Selecting a Cell, cell range, row & column.

Manipulating Rows and Columns

  • Inserting Rows & Columns
  • Deleting Rows& Columns
  • Column Widths
  • Row Heights

Manipulating Cells and Cell Content

  • Copying a Cell or Range Contents
  • Deleting Cell Contents
  • Moving the Contents of a Cell or Range.
  • Editing Cell Content
  • Undo and Redo
  • AutoFill
  • Sorting
  • Searching and Replacing

Worksheets

  • Renaming a Worksheet
  • Inserting a New Worksheet
  • Deleting a Worksheet
  • Copying and moving a Worksheet

Excel 2010 Font Formatting

  • Font Type
  • Font Size
  • Bold, Italic, Underline
  • Cell Border Formatting
  • Background Colour
  • Font Colour

Alignment Formatting

  • Aligning cell contents
  • Centring a Title Over a Cell Range
  • Cell Orientation
  • Text Wrapping
  • Format Painter

Number Formatting

  • Decimal Point Display
  • Comma Style Formatting
  • Currency Symbol
  • Date Styles
  • Percentages

Freezing

  • Freezing Row and Column Titles in Excel 2010

Excel 2010 Formulas

  • Creating Formulas
  • Copying Formulas
  • Operators
  • Using Operators In Formulas
  • Formula Error Messages
  • Relative Cell Referencing
  • Absolute Cell Referencing

Functions

  • Sum Function
  • Average Function
  • Max Function
  • Min Function
  • Count Function
  • The Counta Function
  • The Countblank Function
  • Using the If Function

Charts

  • Inserting different chart types.
  • Resizing and deleting a Chart
  • Chart Title or Labels
  • Chart Background Colour
  • Column, Bar, Line or Pie Slice Colours
  • Copying and Moving Charts

Customising Excel 2010

  • Modifying Excel 2010 Options
  • Minimising the Ribbon
  • Autocorrect Options