Office 2013 Training Manuals – Microsoft Excel 2013 Intermediate Courseware

Microsoft 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