Excel 2010 - Advanced

This course has no current classes. Please join the waiting list.

Excel 2010 Training in Newcastle!

This course aims to provide skills and knowledge which will allow the attendee to create lookup functions, set Excel working options, enhance charts, protect worksheet data, perform advanced data operations using summarising, PivotTables, data consolidations, goal seeking, and solver, and create and use macros.

Expected outcomes at course completion:

  • Use a range of lookup and reference functions
  • Modify MS Excel options
  • Customise the formatting of charts in MS Excel
  • Create and use labels and names in a workbook
  • Protect data in worksheets and workbooks
  • Create summaries in your spreadsheets using subtotals
  • Use data linking to create more efficient workbooks
  • Use the Data Consolidation feature to combine data from several workbooks into one
  • Understand and create simple PivotTable reports
  • Construct and operate PivotTables using some of the more advanced techniques
  • Create and edit a PivotChart
  • Use goal seeking to determine the values required to reach a desired result
  • Group cells and use outlines to manipulate the worksheet
  • Use Solver to solve more complex and intricate problems
  • Create recorded macros in MS Excel
  • Use the macro recorder to create a variety of macros

Prerequisites:

* This course is designed for users who need to use some of the more advanced features of Microsoft Excel 2010.

* Participants must have completed our Excel 2010 Intermediate class and be competent in computing and the Windows environment.

WEA Hunter offers a wide variety of Lifestyle & Leisure courses at various locations throughout Newcastle and the Hunter Region.
Course enrolment must be accompanied by a fee; we are unable to hold places for people or accept deposits on Lifestyle courses. Once enrolment is completed students will receive a course confirmation either in writing or by email. This course confirmation constitutes a receipt.

Please check your confirmation letter to ensure you have the correct time, date and location of your course as well as any necessary requirements. There is a room directory located at each venue directing you to your classroom. Vending machines are located at both Laman & King street venues and parking fees will apply.

Please choose carefully as WEA Hunter does not issue refunds of fees paid except in circumstances where WEA Hunter cancels a course – in which case students are entitled to receive a full refund. Alternatively if a course cancels WEA Hunter will transfer the student into another course with no administration charge.
Please contact one of our friendly staff if you have any enquiries or need to make any changes to your enrolment. Please note any changes need to be made at least 5 days prior to course commencement.

It’s your time…enjoy it!