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.26 out of 5 based on 61 customer ratings
(61 customer reviews)
Product Reviews

61 reviews for Advanced Certificate in Microsoft Excel

  1. Rated 5 out of 5

    Levi Faulkner

    An improvement i can suggest is – faster marking

  2. Rated 5 out of 5

    Maryanne Ram

    Gained knowledge and understanding of studying online, was a good experience. I thoroughly enjoyed my studies, course materials were easy to understand I would not want to change anything.

  3. Rated 5 out of 5

    Justine Lucas

    I could access the course content anytime of the day, which really suited me with work and kids activities.

  4. Rated 5 out of 5

    Autumn Hill

    How well the course has helped me in my learning

  5. Rated 5 out of 5

    Deborah Jane Hollenberg

    You can do it at your own pace. Nothing on this subject, the Excel course was simple to follow and easy to understand

  6. Rated 5 out of 5

    Deboarh Jane Hollenberg

    You can do it at your own pace The Excel course was simple to follow and easy to understand.

  7. 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.

  8. 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

  9. 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

  10. Rated 3 out of 5

    Simon Pollard

    online and in your own time

  11. 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

  12. Rated 5 out of 5

    Sarita Bergh

    It was easy to research and enrol

  13. Rated 5 out of 5

    Sascha Martin

    Maybe a larger work load? Recommended by Karleen Elphick

  14. Rated 4 out of 5

    Sascha Martin

    I choose the Career Academy as I wanted to do a course online that I could work on when it suited my time frames and my expectations were met. Improvement: Nothing really I found that if you follow the instructions and work through each topic the information provided was detailed and easy enough to understand, although if you were new to the subject I think the extra support of a Tutor would be required and this is offered. thanks very much for everything I enjoyed the learning experience.

  15. Rated 5 out of 5

    Bojamma Kusha

    Excellent!

  16. Rated 4 out of 5

    Teressa Howe

    The instructional video clips are very good, very clear steps to follow and great that you can repeat them as often as you like.

  17. 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.

  18. Rated 4 out of 5

    Nick Polson

    I believe this school would help me fulfill my goal of becoming a Certified Bookkeeper of Ireland i just needed to update my knowledge and skills in Bookkeeping which used to be my job though. I would say that the course is 5 as it provides the topic i need. Thank you very much for the help you extended to me in finishing this course.Thanks so much for the help you extended to finish the course. If you could recommend me to companies for job I would appreciate it very much. Thanks again for making me one of the Certified Bookkeepers of Ireland.

  19. 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.

  20. Rated 5 out of 5

    Anna-Maree Dixon

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

  21. Rated 4 out of 5

    Sue Way

    It was my first foray into online study or indeed any study for some thirty odd years and noticed that there are quite a few different courses; if I am honest it was more a case of a pin and a blindfold. But having said that I have felt very comfortable with the experience and the encouragement I received from the different Tutors with their explanations and feedback helped me feel that I was actually understanding and learning, I felt there was connection and that had I needed it, I could have contacted them for a more in depth discussion. Nothing other than I have thoroughly enjoyed doing this course. Learning has done a lot for my self-esteem.

  22. Rated 3 out of 5

    Anna-Maree Dixon

    Because I could study in my own time with no pressure in the comfort of my own home.

  23. 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.

  24. Rated 4 out of 5

    Thuy Hatch

    I choose the Career Academy as I wanted to do a course online that I could work on when it suited my time frames and my expectations were met Nothing really I found that if you follow the instructions and work through each topic the information provided was detailed and easy enough to understand, although if you were new to the subject I think the extra support of a Tutor would be required and this is offered. No thanks very much for everything I enjoyed the learning experience.

  25. 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.

  26. Rated 4 out of 5

    Olivia Jo-Anne Rea

    I believe the course was a little bit brief. Could have a more comprehensive set of assignments Ability to dictate when and where I can complete the course.

  27. 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.

  28. 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

  29. 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.

  30. Rated 4 out of 5

    Lee Clark

    I appreciated the assistance of an extension to complete when I had some family issues arise that took me away from work and study. the customer service and understanding that was offered was fabulous. Thankyou it was a good starting point for re-entry into study. it was really flexible as to when and where I studied and completed my assignments this is the first online course I have done so I have nothing to compare it to, however it was easy to access and use.

  31. 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

  32. Rated 4 out of 5

    Cathy Jansen

    Enjoyed it

  33. Rated 3 out of 5

    Cathy Jansen

    Because a family member said it was Good and the courses for straightforward and Good for career you want to be In The help was great

  34. Rated 5 out of 5

    Megan Goff

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

  35. Rated 4 out of 5

    Megan Goff

    Because a family member said it was Good and the courses for straightforward and Good for career you want to be In Just topic 9/10 just needed better explaining. The help was great

  36. Rated 4 out of 5

    Lee Clark

    No complaints – really enjoyed the course

  37. Rated 5 out of 5

    Alan Chan

    Easy to understand tutorials and examples.

  38. 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.

  39. Rated 4 out of 5

    Michelle Krynen

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

  40. Rated 5 out of 5

    Swapnali Joshi

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

  41. 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.

  42. Rated 3 out of 5

    Jody ann Laws

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

  43. 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

  44. 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.

  45. 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.

  46. 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.

  47. 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.

  48. Rated 4 out of 5

    Dwayne Jackson

    Good course, nice content.

  49. 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.

  50. 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.

  51. 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.

  52. 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.

  53. 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.

  54. Rated 4 out of 5

    Harshad Sohoni

    Great! Could study at my own pace.

  55. Rated 5 out of 5

    Baoyi Liu

    Great course

  56. Rated 4 out of 5

    Laura Shaw

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

  57. 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.

  58. Rated 4 out of 5

    Corey Stark

    Best suited my situation for learning.

  59. Rated 4 out of 5

    Shona Reilly

    Good overall.

  60. Rated 4 out of 5

    Gitavkumar Patel

    Good overall

  61. 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!

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 - Call now 01 437 8559
null
Select a payment plan that suits you and your income

Course structure.

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

Covering these topics

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

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

Course Summary

Investment: 399 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.

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

What our students say:

★★★★★ “Course content and progression were very clear, and I did not have any need to contact the tutor for assistance. Overall great course – thanks.” – Alice Young

 

★★★★★ “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

Student Success Stories

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.