Microsoft Office Training Materials – Excel 2010 Intermediate Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft 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.
Other Microsoft Office Training Materials
Word 2010 Foundation
Word 2010 Intermediate
Word 2010 Advanced
Excel 2010 Foundation
Excel 2010 Intermediate
Excel 2010 Advanced
Access 2010 Foundation
Access 2010 Intermediate
Access 2010 Advanced
Outlook 2010 Foundation
PowerPoint 2010 Foundation
PowerPoint 2010 Intermediate
PowerPoint 2010 Advanced