Microsoft Excel 2010 Intermediate Training Materials

Courseware Training Materials

Training Course Outline

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

• 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.
• 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.

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.