|
|
|
Q
|
How many papers do I need to complete to achieve the qualification?
|
|
|
|
|
|
A
|
Passing the main paper gives you the qualification, but you can enhance the qualification by adding any or all of the four speciality papers.
|
|
|
|
|
|
Q
|
What are the prerequisites for enrolling?
|
|
|
|
|
|
A
|
Main paper:
You will already have much experience of working with Excel. You will be familiar with creating formulas, applying formats, printing and such frequently-used features.
Though level is a relative term, you are probably already advanced compared to most Excel users. You may even consider yourself to be an expert already, but there is still plenty of room for improvement; there are sure to be many gaps in your knowledge. In addition to experience, you need to be bright. The study material even in the main paper delves into some advanced areas such as complex formulas and macros, though the main paper does not go too deeply into macros.
Specialist Paper:
The main paper is a pre-requisite for the specialist papers,
though we will not prevent you from purchasing in a specialist paper. Some
sections of the speciality papers, particularly in regard conventions, will be
difficult to understand without having studied the main paper.
.
|
|
|
|
|
|
Q
|
How much study is required?
|
|
|
|
|
|
A
|
To
achieve the Certified Professional in Excel for Finance qualification you have
to pass all 5 parts of the main paper (Paper1). Each part is an average of 24 hours study. The hours vary from
part to part.
|
|
|
|
|
|
Q
|
How does the qualification differ from the Microsoft Office Specialist qualification?
|
|
|
|
|
|
A
|
It differs in four ways:
- (A) It is at a noticeably higher level.
- (B) It is specific to those who work in Finance and Accounting, building applications needed in that function.
- (C) It covers not only Excel features, but also conventions. As an analogy, you not only learn words, but also the grammar to put those words together.
- (D) Instead of slowly building inconsistent, error-prone applications from scratch every time, you learn to build from standard components and employ tools to take advantage of that and the conventions applied.
|
|
|
|
|
|
Q
|
What are the costs?
|
|
|
|
|
|
A
|
Each part is NZ$89+GST; AUS$84+GST; US$69, which includes all coursework, access to online quizzes, and the assignment. If you go to the order page, you will see that there are discounts if you order 3 or more parts. The exam costs NZ$49+GST; AUS$46+GST; USD$38.
|
|
|
|
|
|
Q
|
How can I prove that I have the qualification and any speciality papers?
|
|
|
|
|
|
A
|
In addition to a certificate for each part passed, you have an online account which lists the parts you have passed.
|
|
|
|
|
|
Q
|
How do I enrol in the qualification?
|
|
|
|
|
|
A
|
Simply order one or more parts. You can do that at the order page. Each paper has 5 parts. When you wish, from your AbleOwl account,choose the parts to download coursework for. You have up to 2 years to download, complete the study and take the exam for each part ordered. When you are ready, from your AbleOwl account, download the assignment for a part. When you are ready, from your AbleOwl account, book an exam for a part.
For detailed procedure, go to either corporate administrator user guide or personal user guide.
|
|
|
|
|
|
Q
|
What can I do if I fail?
|
|
|
|
|
|
A
|
You will need to repeat the exam. To achieve the Certified Professional in Excel for Finance qualification, you need to pass the exams for all 5 parts. If you have done one exam for a part, the next time you do it, the exam will be a different one. If you fail an exam for the first time, you must wait 30 days before taking the next exam. If you fail again, you must wait 3 months. After each subsequent fail, you must wait 6 months.
|
|
|
|
|
|
Q
|
Can I still take the exam if I miss or don't complete an assignment?
|
|
|
|
|
|
A
|
Yes, you can still pass the qualification on the exam alone if you obtain a good mark (the exam counts for 80% of the marks).
|
|
|
|
|
|
Q
|
How do I submit my assignments?
|
|
|
|
|
|
A
|
You upload the files from your AbleOwl account.
|
|
|
|
|
|
Q
|
What if I need help in understanding coursework or assignments?
|
|
|
|
|
|
A
|
Initially, this service is free. We expect this service to remain free at least until the end of 2016. Email hotline@ableowl.com with any questions. Once we terminate this free service, you will need to purchase hotline time.
|
|
|
|
|
|
Q
|
Can I take the exam in a language other than English?
|
|
|
|
|
|
A
|
Currently, English is the only language available.
|
|
|
|
|
|
Q
|
How and when are exam results released?
|
|
|
|
|
|
A
|
You will be emailed exam results for each part within 1 week of the exam. It will also appear in your AbleOwl account. From there you can email others a link that verifies online your qualification passes. You also receive a certificate for each part and for the overall qualification when you pass all five parts.
|
|
|
|
|
|
Q
|
Who is the qualification relevant to?
|
|
|
|
|
|
A
|
Financial Controller, Management Accountant, Finance Manager, Financial Accountant, Cost Accountant, Business Analyst, Data Analyst, Financial Analyst, Group Accountant, Project Accountant, Systems Accountant, Production Accountant, Corporate Accountant, Fund Accountant, Company Accountant, Commercial Accountant, Finance Director, CFO, Head of Finance, Chief Accountant, Senior Accountant, Business Accountant, Operations Accountant and similar.
|
|
|
|
|
|
Q
|
Is there a discount if I order this qualification for everyone in the office?
|
|
|
|
|
|
A
|
Yes, the higher the value of the order of coursework and exam units, the higher the discount. You can see the discounts at the order page.
To allocate purchased units to staff members, you need to chooseCorporate at the order page. From the Corporate qualification page of yourAbleOwl account, you can allocate coursework and exam units to staff members.For details, see the corporate administrator user guide.
|
|
|
|
|
|
Q
|
I am having problems logging onto my user profile, who can I contact?
|
|
|
|
|
|
A
|
Email
admin@ableowl.com
Phone
Australia
Tel Melbourne +61 (3) 8400 4580
Tel Sydney+61 (2) 9496 2330
New Zealand
Tel +64 (7) 854 9276
|
|
|
|
|
|
Q
|
What is the difference between a personal qualification and a corporate qualification?
|
|
|
|
|
|
A
|
Personal:
If you are ordering for yourself, order a personal qualification.
Corporate:
If you are ordering papers for multiple employees of the organisation, choose Corporate.
The corporate user can monitor the progress of staff.
|
|
|
|
|
|
Q
|
How many CPD hours can I claim?
|
|
|
|
|
|
A
|
Each paper has 5 parts with an assignment and an exam for each part. Each part is an average of 24 CPD hours.
|
|
|
|
|
|
Q
|
How many papers are there to this qualification?
|
|
|
|
|
|
A
|
There are 5 papers to the Certified Professional in Excel for Finance Qualification. Passing the main paper proves a high level, all round capability in all aspects of Excel for finance, which includes formulas, PivotTables, charts, macros and conventions.
Main Paper: (pass this to gain the qualification)
1• Conventions, formulas and other essentials
Specialist Papers: (enhance the qualification with these papers)
2• Model construction and analysis
3• Data extraction and analysis with Microsoft Query, PivotTables and Power BI
4• Reporting with charts, tables and dashboards
5• Macros for automating tasks
|
|
|
|
|
|
Q
|
How many parts are there to the main paper - Paper 1?
|
|
|
|
|
|
A
|
There are 5 parts to paper1 - Conventions, formulas and other essentials
1. a) Efficient Operation
b) Formatting
c) Conventions to improve spreadsheets
2. Formulas andcalculations
3. a) Tables, import, exports and consolidation
b) Charts, conditional formatting, PivotTables and consolidation
c) Reconciliation, troubleshooting, protection, crosschecks errors and testing
4. Macros
5. Applications
|
|
|
|
|
|
Q
|
When do I need to finalise payment of the qualification?
|
|
|
|
|
|
A
|
Payment
must be processed before you can download your coursework.
|
|
|
|
|
|
Q
|
In the quiz questions, what is a try?
|
|
|
|
|
|
A
|
You
can attempt to answer the quiz questions three times. Each attempt is referred
to as a try.
|
|
|
|
|
|
Q
|
When are assignments due?
|
|
|
|
|
|
A
|
Assignments must be uploaded before you book your exam.
|
|
|
|
|
|
Q
|
Is there an assignment for every part?
|
|
|
|
|
|
A
|
Yes. Each part has one assignment.
|
|
|
|
|
|
Q
|
What portion of the mark is the assignment?
|
|
|
|
|
|
A
|
The assignment is 20% of the total mark. The exam is
80% of the mark.
|
|
|
|
|
|
Q
|
Is there a deadline for submitting an assignment?
|
|
|
|
|
|
A
|
Not really, except you must submit the assignment within two years of ordering the coursework and exam. To book an exam you, you must have purchased the coursework within the previous two years.
|
|
|
|
|
|
Q
|
How are discounts calculated?
|
|
|
|
|
|
A
|
Discounts are calculated like tax. There is no discount up to a certain amount. Then, for the next band, the rate is X. For the next higher band, the rate is Y, which is higher.
For the first $250 of the order, the discount is 0%
For the next $250, of the order, the discount is 20%
For the next $500, of the order, the discount is 25%
For the next $1000, of the order, the discount is 30%
For the next $2500, of the order, the discount is 35%
For the next $5000, of the order, the discount is 40%
So for example:
An order with a Subtotal before discount of $690 will fall into the three bands: For the first $250, the discount is 0%. The next $250 get a 20% discount. The next $190 ($690-$500=$190) get a 25%. Total discount = $97.50 ($0 + $50 + $47.50)
|
Band |
Up to $250 |
$250 |
$500 |
$1000 |
$2500 |
$5000 |
|
% discount |
0% |
20% |
25% |
30% |
35% |
40% |
|
Amount:$690 |
$250 |
$250 |
$190 |
|
|
|
|
Discount calculator |
$0 |
$50 |
$47.50 |
|
|
|
|
|
|
|