Excel 2010 Foundation Courseware

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

 

Excel 2010 Foundation Courseware
Rate this post