CITN1003 – Advanced Certificate in Microsoft Excel

Go beyond the basics and become an expert!

Master Microsoft Excel with our online training course developed by a Microsoft expert. Go beyond the basics and learn the advanced features and functions of Microsoft Excel including manipulating data, advanced chart features, macros and protecting your spreadsheet.

Rated 4.13 out of 5 based on 52 customer ratings
(52 customer reviews)
Product Reviews

52 reviews for CITN1003 – Advanced Certificate in Microsoft Excel

  1. Rated 5 out of 5

    Annielyn Brooks

    Each topic was explained very well and had a good video instructions that’s easy to follow. I would like to receive any feedback on how I am doing with my studies like now I am running behind with my schedule. I think it would be best to inform students how much time they have and how many courses they have left to do, just so they can assess. Sometimes we get so busy or so tired from work to study and forget to work on our deadlines.

  2. Rated 3 out of 5

    Rui Wang

    I think all of the material of the course would be very outstanding, if the example could be more practicable. The advance design the course would give me the comprehensive understanding of the financial statement and report, which would be very reasonable for me to make progress of the application. I wonder whether the calculation would be more useful being introducted in the Excel advanced function

  3. Rated 4 out of 5

    Rui Wang

    I think all of the material of the course would be very outstanding, if the example could be more practicable. The advance design the course would give me the comprehensive understanding of the financial statement and report, which would be very reasonable for me to make progress of the application. I wonder whether the calculation would be more useful being introducted in the Excel advanced function

  4. Rated 3 out of 5

    Simon Pollard

    online and in your own time

  5. Rated 4 out of 5

    Sarita Bergh

    Convenience and it suited what I needed I found the print option for macro a bit of a challenge as my computer is not
    Connected to a printer and maybe just get the macro to save a copy. Not everyone has a printer

  6. Rated 5 out of 5

    Sascha Martin

    Maybe a larger work load? Recommended by Karleen Elphick

  7. Rated 3 out of 5

    Emma Clarkson

    I studied through the career academy before and really enjoyed the course For an advanced course I was hoping to delve a little deeper in to Formulas and Macros than what was briefly touched on. I did however learn a couple new tricks for which I am grateful. I felt that macro module was still very basic.

  8. Rated 4 out of 5

    Sue Way

    I chose to study with the career academy because it is easy to fit in with working full time – Nice to study from home I found the lessons/explanations a bit brief and instructions did not relate to my version of Excel so I spent extra time googling for instructions.

  9. Rated 5 out of 5

    Anna-Maree Dixon

    I chose to study with the career academy because i could do it at home.

  10. Rated 2 out of 5

    Thuy Hatch

    It would be very helpful if this course focusing more functions in advance Excel. For example, the assignment should have asked students to apply more functions and be able to explain what those functions assist users to analyse the data. The listed functions on model seem to be at immediate level.

  11. Rated 5 out of 5

    Olivia Jo-Anne Rea

    I made the decision to use The Career Academy because it fits around my busy schedule.

  12. Rated 2 out of 5

    Nick Polson

    Improve my excel skills and gain CPD hours. I think what was in the course was covered very well. However some more breadth could have been added to the course i.e use of hot keys (However I know this could not be tested). I think some more advanced formulas could have been added i.e sum if formulas. If you were to offer another course that built upon your advanced course I would certainly pay for it if completing this course could be classed as CPD hours.

  13. Rated 5 out of 5

    Juleen De Lange

    I chose the career academy because i wanted improve my knowledge in my work field and hope to get improvement in role by doing extra studies

  14. Rated 3 out of 5

    Catherine Johnson

    I chose the career academy because Flexibility, good payment structure I found Excel tutorials lacking in good, clear explanations. Even my friend who is very good at Excel but mostly self taught, said this was the worst she'd ever seen as far as being well laid out and explained. And sheets got more alphabet letters after her name than anyone I know. However, after many hours, late nights, early mornings, I muddled through and finally understood enough to give me a pass. Excel is far more complex than I had imagined.

  15. Rated 4 out of 5

    Sandra Masters

    Thank you I learnt alot – I am sure you could offer more advanced courses in different areas – linking worksheets, more complicated vlookups, macros and formulas – especially aimed at Accountants (so financial worksheets). I download files from accounting systems (eg MYOB) and then want to manipulate the data – so things along that line would be great. I found the ability to stop and rewind the tutorials great as you miss stuff the first time. You may want to fix the tutorial where there is no sound, it made a big difference.Have a great weekend and thanks for helping me hit my 30th June CPD deadline so easily and relevantly

  16. Rated 4 out of 5

    Cathy Jansen

    Enjoyed it

  17. Rated 5 out of 5

    Megan Goff

    easy to follow and very good, can do in my own time

  18. Rated 4 out of 5

    Lee Clark

    No complaints – really enjoyed the course

  19. Rated 5 out of 5

    Alan Chan

    Easy to understand tutorials and examples.

  20. Rated 5 out of 5

    Catherine Lapwood

    The strengths of this course were the video instructions that could be replayed to enable understanding and the “How can I help” pop-ups.

  21. Rated 4 out of 5

    Michelle Krynen

    I chose to study with The Career Academy to gain a recognized qualification by studying online.

  22. Rated 5 out of 5

    Swapnali Joshi

    Excellent tutors, very knowledgeable. Would like to do other courses. Already recommended to friends.

  23. Rated 4 out of 5

    Brigitta Sinton

    I chose to study with The Career Academy because it suits my personal circumstances. Currently it would be difficult for me to travel to a learning institution, online study at times that suit me works better for me.

  24. Rated 3 out of 5

    Jody ann Laws

    Thanks for the timely marking of the assignment, really great!

  25. Rated 5 out of 5

    Whika Douglas

    As it contains all courses I was to study and pursue a career in! and also the payment plan is an excellent idea!! An improvement would be to maybe not using video? as I was not able to view it on certain PC (while at work

  26. Rated 5 out of 5

    Christine Winkelnkemper

    handy for me due to being online as I am working full time. This course was easy to go through and easy to understand with the video tutorials.

  27. Rated 5 out of 5

    Roxana Castro

    I took this course because I wanted to find a new job and to improve my skills. I have learned a ton since I signed up. It is very practical and easy to understand. The videos are great and the tutors help to answer any questions I have.

  28. Rated 4 out of 5

    Joel Renzenbrink

    It was good, I didn’t need much help from the tutors but they were good at responding to assessments. The content was pretty easy to get through.

  29. Rated 5 out of 5

    Olivia Jo-Anne Rea

    I enjoyed this course, it was easy to follow, I had never worked with Excel before and I was able to complete the assessment with a good result so I would say the content was great. I choose to study with The Career Academy because it worked around my busy schedule of being a mother and a sports coach.

  30. Rated 4 out of 5

    Dwayne Jackson

    Good course, nice content.

  31. Rated 5 out of 5

    Anonymous

    I found the course quite challenging but I really enjoyed how nice it was to progress with the course in my own time.

  32. Rated 5 out of 5

    Pixie Haupapa

    I think your course is pretty cool and look forward to continuing to the next module after getting the hang of it.

  33. Rated 4 out of 5

    Pauline Cochrane

    There is a wide range of courses for use in the accounting field. Also the academy is affiliated to CA ANZ. I think a bit more information/investigating for the various lessons should be requested from the students. E.g. when making charts. They should be requested to use the Sparklines tools/design to add high points, low points etc.

    Also, when watching the video for each lesson I found some were moving too fast around the spreadsheet and had to re-watch them several times.

  34. Rated 5 out of 5

    Leanne Jensen

    This course really helped me gain more skills in Microsoft Excel. The information that I was given was easy to follow and help was there when I needed.

  35. Rated 5 out of 5

    Jofrey Valendez

    I am happy with the course and will be able to apply my knowledge learned in the future.

  36. Rated 4 out of 5

    Harshad Sohoni

    Great! Could study at my own pace.

  37. Rated 5 out of 5

    Baoyi Liu

    Great course

  38. Rated 4 out of 5

    Laura Shaw

    It was a flexible and more ideal option for me working as an accountant.

  39. Rated 4 out of 5

    Teresa Mcleod

    Thank you so much for the feedback, its funny but every time I hand in my work, I get butterflies waiting for the results. I’m so happy that everything is going good so far, and your feedback means so much to me, thank you again.

  40. Rated 4 out of 5

    Corey Stark

    Best suited my situation for learning.

  41. Rated 4 out of 5

    Shona Reilly

    Good overall.

  42. Rated 4 out of 5

    Gitavkumar Patel

    Good overall

  43. Rated 5 out of 5

    Dorothy Harrison

    This course was a great refresher course and I gained a lot of new skills and knowledge concerning Excel that I did not know about. Thank you for the opportunity to upgrade my skills.

Add a review

Your email address will not be published. Required fields are marked *

Get a FREE course guide!

All courses include:

null
Developed and delivered by industry experts
null
Practical course content to get you workplace ready!
null
Learn in your own time and at your own pace
null
Unlimited expert tutor support
null
Select a payment plan that suits you and your income

Course structure.

Covering the module CITG102 

1. Advanced Functions

  • Absolute referencing
  • Range names
  • Using the IF function
  • Using the VLookup function
  • Nesting functions

2. Advanced Chart Features

  • Formatting chart objects
  • Trendlines
  • Creating pivot charts
  • Manipulating pivot charts

3. Securing Spreadsheets

  • Protecting your worksheet
  • Protecting your workbook, including using passwords

4. Using Excel Macros

  • Creating macros with the macro recorder
  • Running a macro

5. Excel Data Tools

  • Removing duplicates
  • Text to columns
  • Goal seek
  • Scenario manager

Key benefits

  • Learn advanced Microsoft Excel Skills and gain an accredited certificate
  • Developed by a highly qualified Microsoft Excel expert
  • Learning online allows you to study anytime, at home or the office
  • Receive tutor support via email or by calling our toll free number

You will learn how to

  • Apply advanced functions to access multiple sheets and manipulate data
  • Apply advanced chart features to visually represent your data
  • Protect your spreadsheet from accidental or intentional harm
  • Automate activities within your spreadsheet using macros
  • Gain a deeper understanding of your data using the data tools

Endorsed by AAPNZ

 

Course Summary

Investment: $149 + GST or only $25 per week on a payment plan

Assessments: Case studies, quizzes, written assessments and practical exercises

Duration: 8-10 hours

About the course developers: This course has been developed by the team at The Career Academy and members of Chartered Accountants Australia & New Zealand.

Course Level: 4

NZ Tech Logo

Accredited by ICOES

ICOES, the International Council for Online Educational Standards guarantees you a high standard of content with measurable outcomes from a reputable training organisation. ICOES is the accrediting body that establishes, monitors and continually develops the educational standards of online teaching institutions.

What our students say

★★★★★ “This was recommended by my manager who is the Fixed Accountant and I work under her, she thought a basis in accounting would be useful as we touch multiply parts of the business included Balance Sheet and P&L. The course was very well structured and easy to follow what was required”
Stefanie Downes

Developed by members of the International Web Association

 

Contact us

Don’t put off your career dream any longer. Unlock doors to opportunities you never thought possible with The Career Academy. Contact us today and let us help you take that next step.

Get a FREE info pack!

Fill in this form to recieve more information.