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
Maria Cordero
Oct 15, 2020Magda 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, 2020Cyrus 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, 2021Vrezh was very knowledgable, he made the course interesting and easy to understand.
Christopher Harlan
Nov 29, 2020Cyrus 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 ...
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.