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

(54 customer reviews)
Product Reviews

54 reviews for Advanced Skills in Microsoft Excel

  1. Werner ‘Vern’ Marais

    Flexible & easy

  2. Christopher Hays

    It would be great if there were other advanced offering with respect to Excel. Course was NZ based with reference to CAANZ

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

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

  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

  6. Simon Pollard

    online and in your own time

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

  8. Sascha Martin

    Maybe a larger work load? Recommended by Karleen Elphick

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

  10. Anna-Maree Dixon

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

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

  12. Olivia Jo-Anne Rea

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

  13. Alan Chan

    The course covered all the essential functions. I did not use the tutors but it was great to know there was backup if needed. Thanks

  14. Alan Chan

    The course covered all the essential functions. I did not use the tutors but it was great to know there was backup if needed. Thanks

  15. Alan Chan

    The course covered all the essential functions. I did not use the tutors but it was great to know there was backup if needed. Thanks

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

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

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

  19. Cathy Jansen

    Enjoyed it

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

  21. Cathy Jansen

    Enjoyed it

  22. Sandra Masters

    It was cheaper It offered a basic certificate course in accounting which I was after It was all online and therefore convenient Assignments were manageable and suited my current workload/ level of commitment Spelling and grammar of all info on this website and assignments need checking and correcting as I often found errors and this is recommended if you want to improve your professional look.Few questions in the assignments were also a little unclear and could have been worded better to make it easier to understand for the first time accounting student. Thank you for the fast turnaround of marking my assignments and overall this course has been a good and useful tool to developing my skills professionally and personally. The level of work and info given suits a first timer like me, so thank you. I will definitely consider coming back again in the future when I have the time and space to study again.

  23. Megan Goff

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

  24. Megan Goff

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

  25. Lee Clark

    No complaints – really enjoyed the course

  26. Lee Clark

    No complaints – really enjoyed the course

  27. Alan Chan

    Easy to understand tutorials and examples.

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

  29. Michelle Krynen

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

  30. Swapnali Joshi

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

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

  32. Jody ann Laws

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

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

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

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

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

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

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

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

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

  41. Dwayne Jackson

    Good course, nice content.

  42. Anonymous

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

  43. Pixie Haupapa

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

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

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

  46. Jofrey Valendez

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

  47. Harshad Sohoni

    Great! Could study at my own pace.

  48. Baoyi Liu

    Great course

  49. Laura Shaw

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

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

  51. Corey Stark

    Best suited my situation for learning.

  52. Shona Reilly

    Good overall.

  53. Gitavkumar Patel

    Good overall

  54. 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 0800 112 0911
null
Select a payment plan that suits you and your income

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

Course Summary

Investment: £399 + VAT or only £25 per week on a payment plan. Click here to enrol now

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

CITU1003 – Covering the module

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

Take your next step & get started today!

There are three easy ways to enrol

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.