EXCEL INTERMEDIATE

  • Location: Fraser High C11
  • Start Date: Wednesday 23rd Oct, 2019.
  • End Date: Wednesday 11th Dec, 2019.
  • Time: 6.30 - 8.30.
  • 8 Weeks.
  • 2 hours per week.
  • Course Fee: $79.00.

 

 

 

ENROL NOW FOR TERM 4 2019

 

 

 

 

Tutor: John Richmond

 

 

 

 

People have varying abilities when it comes to technology. This course targets those already with a basic working knowledge of Excel.

 

There are just under Five hundred different equations in the program. You shall be using the most useful ones throughout the course.

Detailed notes on everything covered will be supplied on your USB drive (so please don't forget bring one;

4 GB will suffice).

 

 

 

 

Learn how to do the following with confidence…

 

Working with Data tables Searching, Sorting, Filtering and Data_manipulation.

 

Create and use dynamic hyperlinks

 

Using the Active cell to navigate

 

Create a Picture data base (I.e. A Stamp Collection)

 

Ranking Data (both alpha and numeric) and dealing with duplicates

 

Unordered Approximate searches using VLOOKUP

 

Drawing graphs and charts

 

Dealing with Error messages.

 

Interactive workbooks teaching some of Excels formatting techniques

 

Clever tricks and useful tips.

 

 

I.e. Nesting the If_Then function, Cell referencing, converting equations to text., Array formulas Etc.

 

 

 

 

Does this sound like something you'd like to have a go at?

 

 

 

 

This course is best suited to desktop computers and you are most welcome to use the schools facilities.

 

 

 

 

John has a very accomplished record when it comes to one-on-one tuition.

 

He is well aware of the four learning styles and accommodates all of them in the way in which he teaches.

 

 

 


Student Details - Add your Details

Book Here


This course is supported by the TEC (Tertiary Education Commission) to assist with literacy and numeracy needs of students. You must attend 80% of the class. At the same time we hope you will learn other useful and interesting skills and have a lot of fun learning with us.