Microsoft Excel 2013 Level 2 (Powerful spreadsheet techniques and data manipulation)


General Description

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 are designed for existing users of Excel who would like to expand their knowledge and learn more of the techniques associated with creating better and more productive workbooks. It covers formulas and function techniques, advanced formatting, setting complex printing options, using advanced charting features and data manipulation tools such as Pivot Tables and goal seeking. A large range of functions are examined which cover a broad occupational spectrum and requirement. 

Outcomes

At the completion of this course participants will 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 the dozen or so most popular and 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 
  • use a range of elements and features to enhance charts 
  • select and change the format of objects in a chart.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Good Stuff (Rating based on 45 reviews)

98%
of respondents recommend this course to a friend.


Click here to Read Reviews

Course Info


Schedule

  • Melbourne
  • 17/09/2019 - 17/09/2019
  • 12/11/2019 - 12/11/2019
  • Canberra
  • 17/09/2019 - 17/09/2019
  • Sydney
  • 4/09/2019 - 4/09/2019
  • Brisbane
  • 3/09/2019 - 3/09/2019
  • Adelaide
  • 11/09/2019 - 11/09/2019
  • Perth
  • 21/08/2019 - 21/08/2019
  • 19/09/2019 - 19/09/2019
  • Darwin
  • 17/09/2019 - 17/09/2019

Next Step

Book Course Now
Enquire Now
Tell a Friend
Email Course Outline

Course files