Who is this course for?

Foundation Level: Know, Comprehend and Apply.
During a Foundation course you'll learn how to:
Know
Recall data or information.
Examples: Recite a policy, Quote prices from memory to a customer Know the safety rules.
Comprehend
Understand the meaning, translation, interpolation, and interpretation of instructions and problems. State a problem in one's own words.
Examples: Rewrite the principles of Enker writing, Explain in one's own words the steps for performing a complex task, Translate an equation into a computer spreadsheet.
Apply
Use a concept in a new situation or unprompted use of an abstraction. Apply what was learned in the classroom into novel situations in the workplace.
Examples: Use a manual to calculate an employee's vacation time, Apply laws of statistics to evaluate the reliability of a written test.

Who is this course for?

Intermediate Level: Comprehend, Apply and Analyse.
During a Intermediate course you'll learn how to:
Comprehend
Understand the meaning, translation, interpolation, and interpretation of instructions and problems. State a problem in one's own words.
Examples: Rewrite the principles of Enker writing, Explain in one's own words the steps for performing a complex task, Translate an equation into a computer spreadsheet.
Apply
Use a concept in a new situation or unprompted use of an abstraction. Apply what was learned in the classroom into novel situations in the workplace.
Examples: Use a manual to calculate an employee's vacation time, Apply laws of statistics to evaluate the reliability of a written test.
Analyse
Separates material or concepts into component parts so that its organisational structure may be understood. Distinguish. between facts and inferences.
Examples: Troubleshoot a piece of equipment by using logical deduction. Recognise logical fallacies in reasoning Gathers information from a department and selects the required tasks for training.

Who is this course for?

Advanced Level: Analyse, Create and Evaluate
During a Advanced course you'll learn how to:
Analyse
Separates material or concepts into component parts so that its organisational structure may be understood. Distinguish. between facts and inferences.
Examples: Troubleshoot a piece of equipment by using logical deduction. Recognise logical fallacies in reasoning Gathers information from a department and selects the required tasks for training.
Create
Build a structure or pattern from diverse elements. Put parts together to form a whole, with emphasis on creating a new meaning or structure.
Examples: Write a company operations or process manual, Design a machine to perform a specific task, Integrates training from several sources to solve a problem, Revises and process to improve the outcome.
Evaluate
Make judgements about the value of ideas or materials.
Examples: Select the most effective solution,Hire the most qualified candidate,

What you’ll learn:

This half-day course is designed to build on your basic skills in Excel and help you use time saving tools and features as well as explore some of the more advanced formulas.

After, you’ll be able to…

  • Set up Excel to find key commands more easily
  • Apply custom formats to key data
  • Analyse tables of data
  • Use Logical, Date, Text and Lookup functions
  • Report on data with Pivot Tables and Charts
  • Add charts to Excel


Pricing

  • Member (Early Bird) $240.00 + GST  
  • Member (Standard) $310.00 + GST
  • Non Member (Standard) $370.00 + GST

Next Sessions

  • Excel for Intermediate Users 10/02/2021 - 10/02/2021
    EMA Northern 145 Khyber Pass Road Grafton Auckland NEW ZEALAND
    Register

You may also be interested in:

  • Excel Advanced 2 February 3rd Are you an intermediate to advanced Excel user? This session is designed to provide you with further Computer Training Book a Ticket 
  • Excel for Advanced Users February 3rd Reinforce your competency in Excel to achieve complex tasks Computer Training Book a Ticket 
  • Excel Fundamentals February 10th Get an introduction to Excel and its key features Computer Training Book a Ticket 



Save on courses by becoming an EMA member

Learn more Join EMA