Microsoft Office Training Materials – Excel 2013 Intermediate Training Manuals

Microsoft 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