Excel 2010 Intermediate Courseware

Microsoft Excel 2010 Intermediate Training Materials

Excel Training Materials

Download IT Courseware Samples

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

Functions and Formulas in Excel 2010

  •     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

 Excel 2010 Named Ranges

  •     Naming Cell Ranges.
  •     Removing a Named Range.
  •     Named Cell Ranges and Functions.

Cell Formatting in Excel 2010

  •     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 Templates.
  •     Editing Excel Templates

Paste Special Options.

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

Download IT Courseware Samples