Microsoft Excel Training

Microsoft Excel TrainingEasyPC Training provides customised Microsoft Excel training for groups and individuals across Australia, from beginners to advanced, using Microsoft Excel 2010 and 2013.

Create spreadsheets to collect, analyse, share and manage information to make the most informed decisions.

 

Microsoft Excel Training Courses available

Choose from our standard Microsoft Excel training courses:

…or make your own Customised Course

Microsoft Excel beginners

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to be able to create and edit basic spreadsheets containing simple calculations and links, and produce formatted reports and charts.

Pre-requisites:

  • Basic computer experience, including keyboard and mouse skills
  • Familiarity with Microsoft Windows
  • If you are not familiar with using a computer or Microsoft Windows, the Introduction to computers course will give you the skills to take this Excel course.
Course Content:

  1. Spreadsheets explained
  2. Finding your way around Excel
  3. Working with workbooks and worksheets
  4. Working with data in Excel
  5. Formulas and functions
  6. Formatting in Excel
  7. Printing and page set up
  8. Charts and graphs
  9. Sorting data

View Course Outline >>

View Dates and Prices >>

Microsoft Excel Intermediate

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who wish to extend their knowledge & skills beyond building simple Microsoft Excel workbooks. The course covers more complex functions, such as IFs and LOOKUPs, and data analysis tools.

Pre-requisites:

  • Basic experience in using Microsoft Excel
  • Knowledge of simple formulas and functions
  • Alternatively, completion of Excel Beginners training course
Course Content:

  1. Planning your workbook
  2. Creating custom lists
  3. Advanced formatting
  4. Linking data
  5. Absolute cell referencing
  6. Using names
  7. Protecting your data
  8. Data validation
  9. Logical functions
  10. Lookup functions
  11. Advanced sorting
  12. Filtering data

View Course Outline >>

View Dates and Prices >>

Microsoft Excel Advanced

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who wish to improve their analysis and reporting skills and automate system processes.

Pre-requisites:

  • Sound experience in using spreadsheets
  • Knowledge of more complex functions
  • Ability to sort and filter data
  • Alternatively, completion of Excel Intermediate training course
Course Content:

  1. Advanced filtering
  2. What-if analysis
  3. Data validation
  4. Data tools
  5. Outlining data
  6. Pivot tables
  7. Macros

View Course Outline >>

View Dates and Prices >>

Customised Microsoft Excel Training

Mix and Match topics from any of the 3 levels above to create your own customised training course…

  • For full day courses, choose between 10 and 12 topics
  • For half day courses, choose between 5 and 6 topics

We will discuss your training requirements with you, and can recommend a selection of topics suitable for your specific needs.

Get a Quote for your Microsoft Excel Training

Microsoft Excel Training 5.00/5 6 votes