Microsoft Office Training Materials – Excel 2010 Intermediate Training Manuals

Microsoft Excel 2010 Intermediate Training Materials

Excel 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

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.