Excel 2010 Intermediate Courseware

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.

 

Excel 2010 Intermediate Courseware
3 (60%) 2 votes