Microsoft Office Training Materials – Excel 2013 Intermediate Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft Office 2013 Training Resources
Microsoft Excel 2013 setup and viewing options
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and footers
- Header and footer fields
- Viewing workbooks side by side
- Zooming the view
Microsoft Excel 2013 functions and formulas
- Getting help with functions
- Nested functions
- Consolidating data using a 3-D reference sum function
- Mixed references within formulas
Microsoft Excel 2013 time & date functions
- Inserting the current time and date
- Today function
- Now function
- Day function
- Month function
- Year function
Microsoft Excel 2013 mathematical functions
- Round function
- Rounddown function
- Roundup function
Microsoft Excel 2013 logical functions
- If function
- And function
- Or function
Microsoft Excel 2013 mathematical functions
- Sumif function
Microsoft Excel 2013 statistical functions
- Count function
- Counta function
- Countif function
- Countblank function
- Rank function
Microsoft Excel 2013 text functions
- Left function
- Right function
- Mid function
- Trim function
- Concatenate function
Microsoft Excel 2013 financial functions
- Fv function
- Pv function
- Npv function
- Rate function
- Pmt function
Microsoft Excel 2013 lookup functions
- Vlookup function
- Hlookup function
Microsoft Excel 2013 database functions
- Dsum function
- Dmin function
- Dmax function
- Dcount function
- Daverage function
Microsoft Excel 2013 named ranges
- Naming cell ranges
- Removing a named range
- Named cell ranges and functions
Microsoft Excel 2013 cell and range formatting
- Applying styles to a range
- Conditional formatting
- Custom number formats
Advanced worksheet manipulation within Microsoft Excel 2013
- Copying or moving worksheets between workbooks
- Splitting the window view
- Hiding rows
- Hiding columns
- Hiding worksheets
- Un-hiding rows
- Un-hiding columns
- Un-hiding worksheets
Microsoft Excel 2013 templates
- Using templates
- Creating an Excel 2013 personal template
- Editing an Excel 2013 personal template
- Deleting an Excel 2013 personal template
Paste special options within Microsoft Excel 2013
- Using paste special to add ranges
- Using paste special to subtract ranges
- Using paste special to multiply ranges
- Using paste special to divide ranges
- Using paste special ‘values’
- Using paste special transpose option
Proofing and printing
- Spell checking
- Previewing a worksheet
- Visually checking your calculations
- Scaling your worksheet to fit a page(s)
- Displaying gridlines when printing
- Printing titles on every page when printing
- Printing the Excel row and column headings
- To 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
Other Office training manuals
Word 2013 Foundation
Word 2013 Intermediate
Word 2013 Advanced
Excel 2013 Foundation
Excel 2013 Intermediate
Excel 2013 Advanced
PowerPoint 2013 Foundation
PowerPoint 2013 Intermediate
PowerPoint 2013 Advanced
Access 2013 Foundation
Access 2013 Intermediate
Access 2013 Advanced
Publisher 2013 Foundation
Project 2013 Foundation
Visio 2013 Foundation