Office 2010 Training Manuals – Excel Word 2010 Intermediate Courseware
Office 365 training materials from the Cheltenham Group Free SamplesMicrosoft 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.
- 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
- Project 2010 Foundation
- Windows 10 Foundation