Office 2010 Training Manuals – Excel Word 2010 Intermediate Courseware

Office 365 training materials from the Cheltenham Group
Free Samples

Microsoft Excel 2010 Intermediate Training Course Teaching Materials

Computer Courseware Training Materials

Training Course Outline

Excel 2010 Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(s)
  • Printing Titles On Every Page
  • Printing the Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options in Excel 2010

Excel 2010 Functions and Formulas

  • Getting Help With Functions.
  • Nested Functions.
  • Consolidating Data using a 3-D Reference Sum Function.
  • Mixed References within Formulas.

Time & Date Functions

  • TODAY.
  • NOW.
  • DAY.
  • MONTH.
  • YEAR.

Mathematical Functions

  • ROUND.
  • ROUNDDOWN.
  • ROUNDUP.

Logical Functions

  • IF.
  • AND.
  • OR.

Mathematical Functions

  • SUMIF.

Statistical Functions

  • COUNT.
  • COUNTA.
  • COUNTIF.
  • COUNTBLANK.
  • RANK.
  • TEXT FUNCTIONS
  • LEFT.
  • RIGHT.
  • MID.
  • TRIM.
  • CONCATENATE.

Financial Functions

  • FV.
  • PV.
  • NPV.
  • RATE.
  • PMT.

Lookup Functions

  • VLOOKUP.
  • HLOOKUP.

Database Functions

  • DSUM.
  • DMIN.
  • DMAX.
  • DCOUNT.
  • DAVERAGE

Named Ranges

  • Naming Cell Ranges within Excel 2010.
  • Removing a Named Range.
  • Named Cell Ranges and Functions.

Cell Formatting

  • Applying Styles to a Range.
  • Conditional Formatting.
  • Custom Number Formats.

Manipulating Worksheets

  • Copying or Moving Worksheets
  • Splitting a Window.
  • Hiding Rows, Columns & Worksheets.

Excel 2010 Templates

  • Creating Excel 2010 Templates.
  • Editing Excel Templates

Paste Special Options.

  • Using Paste Special to Add, Subtract, Multiply & Divide.
  • Using Paste Special ‘Values’.
  • Using Paste Special Transpose Option.