Excel Training course

Who should take the Course

Ideal Trainees

Students, Teachers, Professionals, Educators, Inventors, Researchers, Writers, Mathematicians, Data Analyst, Accountants, Entrepreneurs, Programmers (Yes, we mean it), Engineers, Doctors, Managers, Team Leaders, Hobbyists, Technology enthusiasts, Farmers, Business Owners, Sales and marketing guys…yes you got the point. Anyone and everyone.

Generally speaking, anyone who has got anything to do with gathering & interpreting any kind of information (which we all do knowingly or not) to make sense of the core meaning for whatever purposes can benefit hugely by taking this practical usage oriented Excel courses.

“Good teacher explains. Great teacher Inspires. Skill up. Achieve more. Live inspired”


For the Basic course we offer, a little bit of Excel working knowledge would be advantageous. Things like how to create a excel file and save, rename etc. How to add some numbers in excel, create a table of data, formatting, etc. Said that, if you know absolutely nothing, well don’t worry; we will help you to get up to speed in no time. Just bring eagerness and curiosity with a bit of ambition!

For the Intermediate level course, basic knowledge (things from above), how to use charts, calculating sub totals, if-else formulas would be handy to have in your arsenal. However, just basic knowledge would suffice too as we are great instructors! :D

For the advanced or pro level course, basic concepts of macros, complex nested formulas, range definitions, basic concepts of programming would be very handy. However as always, basic-intermediate level knowledge should just get you there.

Our Recommendation

For most people who uses Excel for day to day random ‘go to’ tool, Basic can be skipped and Intermediate level followed by Advanced level a week later is the best recommended combination.

…and many more. Possibilities are boundless. Really.

Learning Outcomes

Along with a many great outcomes of any learning experience, you will be able to do at least the following things, as new skills or the same thing, more efficiently than ever before (assuming the candidate has taken all three or at least two courses)

  • Automatically calculate formulas and make decisions

  • Link consolidate and easily prepare reports and presentations

  • Clean noisy data tables and create meaningful interpretations easy to understand

  • Prepare custom made data forms for simple/complex data entry tasks

  • Handle large amount of co-related data tables across multiple worksheets even across multiple files!

  • Create great charts and define ranges

  • Extend excel beyond its standard functionalities

…and many more. Possibilities are boundless. Really.

Course Layout

Beginner Level Course : 4.5 - 5 hrs

Covers the basic introduction and the basic works that can be done by Excel.

  • Fundamentals of Excel

  • Entering and Editing text and formulas

  • Working with basic Excel Functions

  • Modifying an Excel Worksheet

  • Formatting data in an Excel Worksheet

  • Inserting images and shapes in Excel

  • Creating basic charts in Excel

  • Printing a worksheet

  • Excel templates

Intermediate Level Course : 4.5 - 5 hrs

This course will enable you to handle a large set of data by simplifying the complex calculation, data analysis, reducing the repetitive task and their time taken.

  • Working with Excel list

  • Excel List Function

  • Excel Data validation

  • Importing and Exporting Data

  • Excel PivotTable and PowerPivot Tools

  • Working with large sets of Data

Advanced Level Course : 13 - 14 hrs (over 2 days minimum)

This course will enable you to build your own function and tool to control any task through Excel VBA programming.

  • Excel’s Conditional Function

  • Excel’s Lookup Function

  • Excel’s Text based Function

  • Auditing an Excel worksheet

  • Protecting Excel worksheet and workbook

  • Excel’s “What If?” Tool

  • Automating task with Macro Recorder

  • Excel VBA concepts

How much do we charge?

Fees Structure T.1.pdf

Starts from as little as NZD $225 delivered right at your work desk in person! Comes with it TWO YEARS of free support services (phone & email) at NO ADDITIONAL COSTS!