Office 2013 Training Manuals – Microsoft Excel 2013 Intermediate Courseware
Office 365 training materials from the Cheltenham Group Free SamplesMicrosoft Office 2013 Courseware
Course Outline
Excel 2013 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)
- Visually checking your calculations
- Displaying gridlines when printing
- Printing titles on every page when printing
- Printing the Excel row and column headings
- Spell checking
- Previewing a worksheet
- Viewing workbooks side by side
- Zooming the view
- Printing options
- Setting the number of copies to print
- Selecting a printer
- Selecting individual worksheets or the entire workbook
- Selecting which pages to print
- Single or double sided printing
- Collation options
- Page orientation
- Paper size
- Margins
- Scaling
- Printing
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
- Inserting the current time and date
- Today function
- Now function
- Day function
- Month function
- Year function
Mathematical functions
- Round function
- Rounddown function
- Roundup function
Logical functions
- If function
- And function
- Or function
Mathematical functions
- Sumif function
Statistical functions
- Count function
- Counta function
- Countif function
- Countblank function
- Rank function
Text functions
- Left function
- Right function
- Mid function
- Trim function
- Concatenate function
Financial functions
- Fv function
- Pv function
- Npv function
- Rate function
- Pmt function
Lookup functions
- Vlookup function
- Hlookup function
Database functions
- Dsum function
- Dmin function
- Dmax function
- Dcount function
- Daverage function
Excel 2013 named ranges
- Naming cell ranges
- Removing a named range
- Named cell ranges and functions
Excel 2013 cell formatting
- Applying styles to a range
- Conditional formatting
- Custom number formats
Manipulating worksheets within Excel 2013
- Copying or moving worksheets between workbooks
- Splitting a window
- Hiding rows
- Hiding columns
- Hiding worksheets
- Un-hiding rows
- Un-hiding columns
- Un-hiding worksheets
Excel 2013 templates
- Using templates
- Creating Excel templates
- Editing Excel templates
Paste special options within Excel 2013
- Using paste special to add, subtract, multiply & divide
- Using paste special ‘values’
- Using paste special transpose option
- Word 2013 Intermediate
- Word 2013 Advanced
- Excel 2013 Foundation
- Excel 2013 Intermediate
- Excel 2013 Advanced
- PowerPoint 2013 Foundation
- PowerPoint 2013 Intermediate
- PowerPoint 2013 Advanced
- Outlook 2013
- Access 2013 Foundation
- Access 2013 Intermediate
- Access 2013 Advanced
- Publisher 2013 Foundation
- Project 2013 Foundation
- Visio 2013 Foundation
- Windows 8.1 Foundation
- Internet Explorer 11