Microsoft Excel specialists

The programme and exam

Programme overview
What you get
Assignments
Exams
Sample exam questions
Speciality papers

Programme overview

This is a self-study programme. You can download coursework, submit assignments, and book online exam(s) at any time throughout the year.

There is the main paper (Paper 1) and four optional speciality papers (Papers 2 – 5).

Each paper has 5 parts, each with quizzes, and an assignment.

Once you have submitted an assignment for a part, you can book the online exam for the part. You get a certificate for passing each part. Once you have passed all five parts of the main paper, you gain the qualification. To prove you have the qualification, you get a certificate and an online account that can be made temporarily available to others to verify your passes.

Assignments make up 20% of the final mark and the exam 80%.

Enhance the qualification with any of the four speciality papers.

What you get

If you purchase the qualification coursework and exam, you get an online account where you download the PDF coursework and assignments. From the account, you upload your completed assignments. With your online account, you also have access to the quizzes that appear at the end of each topic.

If you are a manager, you can order papers and allocate them to employees as you see fit. You can track employee progress on downloads, quizzes, assignments and exams.

Online quizzes help you learn

Work through PDF coursework

Optionally, play videos for some topics

Submit assignments and get feedback

Prove your capability with online verification and with certificate

Assignments

When you purchase an exam unit, in addition to the exam, you receive an assignment to complete. Assignment files need to be downloaded and uploaded from your online AbleOwl account given to you. You will receive feedback on your submitted assignment.

What are the assignment rules?

  • You must not have the assistance of any other person in any way in     completing any assignment. The work submitted is all your own.

    Exams

    How is the exam structured?

    The exam for one part is 40 minutes and contains multiple choice questions and a practical.

    The exam runs at your choice of location and date and is invigilated by means of webcam and mic.

    How should I prepare for the exam?

    The best way to prepare for an exam is to work through the coursework for the qualification part, answer the quiz questions, complete the assignment and use the sample exam as a mock exam. For many of the qualification parts, it is most unlikely that you can pass the exam unless you have studied the coursework. One reason for that is that you won’t otherwise be familiar with the conventions applied to spreadsheets. So, prior experience, however extensive, does not guarantee that you will pass the exam.

    Can I access sample questions?

    Multiple-choice questions are like those in the quizzes. Practical exam questions are like those of the assignments. Access an example exam.

    How much do the exams cost?

    An exam (which includes an assignment) for one qualification part costs NZ$49+GST; AUS$46+GST; US$38

    What is the exam booking procedures?

    From your AbleOwl account, select a date and time for the exam. If you don’t yet have an AbleOwl account, you will be provided one on purchase.

    Within one working day of booking your exam, we will email you a GotoMeeting link for your exam. If you have not used GotoMeeting before on your PC, you should test that the link works in advance. There is no refund if the GotoMeeting fails to run on your laptop.

    For detailed procedure, go to either corporate administrator user guide or personal user guide.

    What setup do I need to take the exam?

    You need:

    A closed room that has no one else in the room.

    A PC that runs Windows and Excel 2007 or later version and that has mic and speakers.

    An internet connection.

    To be able to run desktop GoToMeeting web-meeting software. You can test now whether you have any issues in doing that.

    How can I test GoToMeeting?

    To ensure that GotoMeeting works on your computer, do one of the following:

  • A. Book and attend an AbleOwl free 10-minute Excel tips Webinar, which uses GoToWebinar (similar to GoToMeeting). To register click Webinar.
  • B. Use the free GoToMeeting. For instructions click here.

    Will the exam cover material not in the course work?

    No

    What are the exam rules?

    See exam rules

    Sample exam questions

    Multiple-choice - Formulas

    To check whether two numbers in A1 and A2 are effectively the same, which of the following formulas is the simplest, reliable one to do so:

    (a)   =SUM(A1-A2)<0.001

    (b)   =SIGN(A1-A2)<0.001

    (c)   =ROUND(A1-A2,0)<0.001

    (d)   =ABS(A1-A2)<0.001

    (e)   =A1=A2

    To make the total of M22:M33 equal the sum of the formatted values:

    (a)   Enter total formula =SUMPRODUCT(ROUND(M22:M33,0))

    (b)   Enter total formula =ROUND(SUM(M22:M33),0)

    (c)   Enter total formula =SUMROUND(M22:M33,0)

    (d)   Switch on the Precision as Displayed option.

    (e)   A and D

    If the Status Bar Calculate indicator does not disappear after you press F9, the possible reasons are:

    (a)   The number of formula references is beyond a certain limit.

    (b)   There is a circular reference calculation and a certain iteration option is on.

    (c)   There is some other option that has been switched on.

    (d)   A and B

    (e)   A, B and C

    Possible causes of slow calculation include:

    (a)   Lookup functions

    (b)   Volatile functions

    (c)   Array formulas

    (d)   A and C

    (e)   A, B and C

    Practical - Structure and presentation

    (1) Open ExTitlesBorders.xlsm and go to sheet rKey.

    (2) Improve the report shown below, which is in the range K10:R38.

             

    Figure 99 – Sheet to be reformatted.

    File: ExTitlesBorders.xlsm, sheet: rKey

    The side of the report needs to be improved to show how it is divided vertically. The report has financial and physical figures. There are direct and indirect costs.

    An additional month will be inserted each month and, so, the sheet needs to be altered so that is quick to do.

    Improve the formatting in other ways to make the report as clear and readable as possible.

    Sample exam

    Open the file below and see the instructions on the GuideExam sheet.

    http://www.ableowl.com/Publications/Samples/SampleExamPaper1Part1.xlsm

    Speciality papers

    Model construction and analysis
    Available for purchase and download in Qtr2 - 2018

    Data extraction and analysis with MS Query, PivotTables and Power BI
    Available for purchase and download in Qtr3 – 2018

    Reporting with charts, tables and dashboards
    Available for purchase and download in Qtr4 - 2018

    Macros for automating tasks
    Available for purchase and download in Qtr1 - 2019