Excel 2007 - Level 4

Overview

1 Day $0  or FREE WITH SATVs (?)

In this course, students will use the advanced features of Microsoft® Office Excel® 2007 to attain a high degree of proficiency as an Excel power user.

  • Evaluate Sales Data Using Statistical Functions
  • Analyze Stock Data Using Statistical Functions
  • Mine Data Using the Lookup and Reference Functions

  • Develop an Investment Schedule Using Financial Functions
  • Make Investment Decisions Using Financial Functions

  • Manipulate Data Using Text Functions
  • Validate Data Using Information Functions

  • Create Advanced Templates
  • Create Advanced Charts

  • Retrieve and Paste Data
  • Determine the Conditional Sum
  • Identify Specific Data Using the Lookup Wizard
  • Clean Data in Workbooks

This course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis who wish to improve their skills in using Excel formulas and functions.
Before attending this course, students must have:

Maria Cordero

Oct 15, 2020
Magda was an excellent instructor, she provided many examples and walked through each process at a suitable pace. She was more than happy to answer questions and ensured each student understood the concept before continuing to the next task.

Natasa Rikaloska

Jun 26, 2020
Cyrus has great communication skills. He is also very approachable as well as patient. I will recommend this course and this instructor to my collegues.

Chiara Greyling

Feb 03, 2021
Vrezh was very knowledgable, he made the course interesting and easy to understand.

Christopher Harlan

Nov 29, 2020
Cyrus was a great instructor; he was very confident, knowledgable, interactive and engaging.

Instructors

Cyrus Mohseni

Having worked within the education and training industry for over ...

Magdalena Todor

With over 20 years experience as a facilitator and university ...

Alice Antonsen

Alice is one of New Horizons’ most experienced Desktop ...

Ben Kirk

With over 16 years of experience working as a Desktop Applications ...

Itvinder Mankoo

With nearly 20 years in the IT training industry, Itvinder is one ...

Steve Wiggins

Steve is a highly experienced technical trainer with over 10 years ...

Matthew Goodall

Matthew is a qualified Microsoft Office Specialist, Microsoft ...


REGISTER NOW
top

OLLAnywhere is a revolutionary way of utilising cutting-edge technology to allow students to attend live instructor-led training from anywhere in or outside of Australia.