Excel Training Courses

Over 50,312 students trained and counting.

(4.26 out of 5)

About Microsoft Excel IconAbout Microsoft Excel:

Using advanced calculation features, graphing tools, pivot tables, and a macro programming language called VBA (Visual Basic for Applications). Microsoft Excel will organise your numeric or text data in spreadsheets that allow you to build context, and helps you make more informed decisions.

Which Excel Version IconWhich Excel are you?

 1 Day

SKILLS COVERED:

  • Navigate the Excel user interface
  • Use Excel commands
  • Create worksheet formulas
  • Insert functions
  • Modify fonts
  • Create and use templates
  • Add borders and colours to worksheets
  • Preview and print a workbook
  • Manage worksheets & workbooks

 1 Day

SKILLS COVERED:

  • Configure Excel options
  • Enable Excel add-ins
  • Use range names in formulas
  • Use specialised functions
  • Text and logical functions
  • Advanced conditional formatting
  • Create and modify tables
  • Sort & filter data
  • Create & modify charts
  • Create a PivotTable
  • Analyse PivotTable data

 1 Day

SKILLS COVERED:

  • Use 3-D references
  • Collaborate on a workbook
  • Protect worksheets and workbooks
  • Apply data validation
  • Work with forms and controls
  • Use lookup functions
  • Search for invalid data and formulas with errors
  • Watch and evaluate formulas
  • Use the goal seek feature
  • Activate and use the solver tool
  • Analyse data with analysis ToolPak tools
  • Use advanced chart features

 1 Day

SKILLS COVERED:

  • Navigate the Excel user interface
  • Use Excel commands
  • Create worksheet formulas
  • Insert functions
  • Modify fonts
  • Create and use templates
  • Add borders and colours to worksheets
  • Preview and print a workbook
  • Manage worksheets & workbooks

 1 Day

SKILLS COVERED:

  • Configure Excel options
  • Enable Excel add-ins
  • Use range names in formulas
  • Use specialised functions
  • Text and logical functions
  • Advanced conditional formatting
  • Create and modify tables
  • Sort & filter data
  • Create & modify charts
  • Create a PivotTable
  • Analyse PivotTable data

 1 Day

SKILLS COVERED:

  • Use 3-D references
  • Collaborate on a workbook
  • Protect worksheets and workbooks
  • Apply data validation
  • Work with forms and controls
  • Use lookup functions
  • Search for invalid data and formulas with errors
  • Watch and evaluate formulas
  • Use the goal seek feature
  • Activate and use the solver tool
  • Analyse data with analysis ToolPak tools
  • Use advanced chart features

 1 Day

SKILLS COVERED:

  • Navigate the Excel user interface
  • Use Excel commands
  • Create worksheet formulas
  • Insert functions
  • Modify fonts
  • Create and use templates
  • Add borders and colours to worksheets
  • Preview and print a workbook
  • Manage worksheets & workbooks

 1 Day

SKILLS COVERED:

  • Configure Excel options
  • Enable Excel add-ins
  • Use range names in formulas
  • Use specialised functions
  • Text and logical functions
  • Advanced conditional formatting
  • Create and modify tables
  • Sort & filter data
  • Create & modify charts
  • Create a PivotTable
  • Analyse PivotTable data

 1 Day

SKILLS COVERED:

  • Use 3-D references
  • Collaborate on a workbook
  • Protect worksheets and workbooks
  • Apply data validation
  • Work with forms and controls
  • Use lookup functions
  • Search for invalid data and formulas with errors
  • Watch and evaluate formulas
  • Use the goal seek feature
  • Activate and use the solver tool
  • Analyse data with analysis ToolPak tools
  • Use advanced chart features

 1 Day

SKILLS COVERED:

  • Navigate the Excel user interface
  • Use Excel commands
  • Create worksheet formulas
  • Insert functions
  • Modify fonts
  • Create and use templates
  • Add borders and colours to worksheets
  • Preview and print a workbook
  • Manage worksheets & workbooks

 1 Day

SKILLS COVERED:

  • Configure Excel options
  • Enable Excel add-ins
  • Use range names in formulas
  • Use specialised functions
  • Text and logical functions
  • Advanced conditional formatting
  • Create and modify tables
  • Sort & filter data
  • Create & modify charts
  • Create a PivotTable
  • Analyse PivotTable data

 1 Day

SKILLS COVERED:

  • Use 3-D references
  • Collaborate on a workbook
  • Protect worksheets and workbooks
  • Apply data validation
  • Work with forms and controls
  • Use lookup functions
  • Search for invalid data and formulas with errors
  • Watch and evaluate formulas
  • Use the goal seek feature
  • Activate and use the solver tool
  • Analyse data with analysis ToolPak tools
  • Use advanced chart features

Excel Training Delivery Options IconTraining Delivery Options:

New Horizons offers the following training modalities for Microsoft Excel courses:

Accreditations Icon  Accreditations:

Registered Training Provider Logo

Find the right Excel Course IconFinding the right Excel course:

The key to achieving learning outcomes from an Excel training course is to find the right course that matches your learning requirements at that moment in time. Use our Excel pre-course assessments to find what level of training will be most suited to achieve your learning and consequently your professional goals.
Learn more …

What is included in your Excel TrainingWhat’s included in your Excel training:

  • Complimentary Excel pre-course assessments.
  • Access to a Learning Solutions Advisor to discuss training requirement
  • Hands-on training delivered by Microsoft Certified Trainers
  • Printed courseware material in line with Microsoft Office specialisation requirements
  • Access to post course online course content
  • Access to a 60-day post course helpdesk support service
  • 6-month free course repeat/refresher option

Top reasons to choose New Horizons IconTop 5 reasons to choose New Horizons:

  • Over the past 18 years (since June 1998), we have trained more than 50,312 Excel professionals Australia wide.
  • We have been training Microsoft Excel courses since 1995 globally.
  • Our Excel instructors hold the Microsoft Office Specialist (MOS) certification.
  • Over 98% of our students would recommend us for training.
  • We are a Microsoft Gold Certified Partner.
    • We are an Australian Registered Training Organisation (RTO).
    • We run over 15 Excel classes each month to provide scheduling flexibility to our customers.
    • Every year we look after Excel training needs of more than 2795 business professionals working in the private and public sectors.
    • Our Excel instructors are certified by Microsoft.
    • We offer a variety of training delivery options to help meet your learning and business requirements (See below for details).

Our Excel Instructor IconMeet our Excel instructors:

Excel upgrade IconStress free upgrades/rollouts:

The success of a technology upgrade/rollout goes hand-in-hand with the effectiveness of the skills development plan for the people involved. Over the past 18 years, New Horizons has helped over 1323 organisations make a smooth and successful transition to the latest version of Excel through our detailed pre-training skills gap analysis, flexible training delivery options and post course learning support. Call 1300 794 006 to learn more.

top