Microsoft Excel 2013 - Level 2 (with Challenge Exercises)

INF1356
978-1-921939-69-3
B&W printed

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like PivotTables and goal seeking.

At the completion of this course you should be able to:

  • use filling techniques
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • use a variety of financial functions
  • use the date and time functions to perform calculations
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel's Quick Analysis tools
  • work with tables in Microsoft Excel
  • understand and create simple PivotTables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

INF1356 cover image

$29.50

Purchase: Add to Cart

Ebook edition

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip