Microsoft Excel 2013 Intermediate Courseware

Microsoft Office 2013 Training Resources

Download IT Courseware Samples

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

Download IT Courseware Samples