Excel 2013 Advanced – contact us for dates

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 Advanced 2013 are sufficient to allow a user to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

The skills and knowledge acquired in Microsoft Excel Advanced 2013 are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Learning outcomes

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

  • modifying Excel options
  • protecting data in worksheets and workbooks
  • importing data into Excel and export data from Excel
  • using data linking to create more efficient workbooks
  • grouping cells and use outlines to manipulate the worksheet
  • creating summaries in your spreadsheets using subtotals
  • using the Data Consolidation feature to combine data from several workbooks into one
  • creating, using and modifying data tables
  • creating and working with scenarios and the Scenario Manager
  • creating and editing a PivotChart
  • constructing and operating PivotTables using some of the more advanced techniques
  • using advanced filters to analyse data in a list
  • using a variety of data validation techniques
  • using a range of Information functions
  • using a range of text functions
  • creating and using a range of controls in a worksheet
  • sharing workbooks with other users
  • creating recorded macros in Excel

View the full course information