Excel Intermediate 2013

02-Feb-2016
Barossa Valley

  • Option to resit within 6 months
  • Group or One-on-one
  • Tailored on site options
  • Experienced trainers
The skills and knowledge acquired in Microsoft Excel Intermediate 2013 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.

The skills and knowledge acquired in Microsoft Excel Intermediate 2013 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.

Learning outcomes

Training is customised to meet the specific needs of the participants and may include:

  • using filling techniques
  • using a range of techniques to work with worksheets
  • applying a variety of page setup techniques
  • applying borders to cells and ranges in a worksheet
  • using popular and common worksheet functions
  • creating more complex formulas and functions
  • using a variety of financial functions
  • using the date and time functions to perform calculations
  • creating and using┬ádefined names in a workbook
  • applying a range of number formatting techniques to worksheet cells
  • applying conditional formatting to ranges in a worksheet
  • using goal seeking to determine the values required to reach a desired result
  • understanding and using Excel’s Quick Analysis tools
  • working with tables in Microsoft Excel
  • understanding and creating simple PivotTables
  • using a range of elements and features to enhance charts
  • selecting and changing the format of objects in a chart

View the full course information