ClickCease

You're well on your way to supercharging your career.

Upskill and improve your career prospects and earning capabilities with The Career Academy. Watch this video and download your free info pack to find out more.

Enrol now and get ahead

83% of graduates say we improved their ability to get a new job or promotion!

Study Psychology with The Career Academy and receive an industry-recognised certification.

See what you'll be learning in the Certificate in Advanced Certificate in Microsoft Excel

Certificate in Excel

This course will provide an introduction to the basics of the different files used within excel including but not limited to text files, csv files, and how to save, import and export data.

This course will provide an introduction to how to use the various Lookup functions to cross-reference data within Excel, including but not limited to vertical lookups, horizontal lookups, the MATCH and INDEX features and the VLOOKUP, HLOOKUP and XLOOKUP functions.

This course will provide an introduction to a range of tasks that allow you to prepare data within Excel for reporting purposes. It will include but not be limited to Conditional Formatting, Rules, how to convert cell formats, how to remove duplicates, how to insert leading zeros and how to replace a formula with its result.

This course will provide an introduction to using tables in Excel, including but not limited to the use of Freeze panes, Table Filtering and Slicers, how to create a calculated column and how to analyse data using a Total Row.

This course will provide an overview of Pivot Tables, including but not limited to how to create them, how to manage the data in the table, how to display percentages, how to group data and add formulas and how to refresh the data.

This course will provide an overview of Pivot Charts, including but not limited to how to create them, how to change the design and layout, how to add and hide elements and how to create combined charts.

Complete a practical case study based assessment using Excel.

 
 
 

Why learners choose The Career Academy

Unlimited Tutor Support
Industry recognised & accredited courses
Online and available
everywhere, anytime
Start from just €25 a week
interest-free
Rolling intake
start anytime

FAQs about this course

There are no entry requirements or pre-requisites to enrol into this course. You can enrol online directly by selecting your course and clicking on “Enrol Now” and follow the prompts. Alternatively, you can enrol over the phone with our friendly student advisors. Give them a call on 01 437 8559 or email them at info@careeracademy.ie

This course costs €399 or only €25 per week on a no deposit, interest free payment plan. Click here to get started now.

This course takes approximately 30 hours, and you’ll have up to 6 months to complete. Study in your own time, at your own pace. Most of The Career Academy courses are designed so that you do one module a week. But if life gets busy you can take longer and even apply for a course extension if you need more time.

Upon the completion of this course, you can obtain a job as an Administration Assistant. These jobs in Ireland earn approximately €27,300 per year but can be as high as €33,500 per year. (Payscale)

Contact a friendly student advisor on 01 437 8559 to find out about potential career outcomes and see where our courses can take you. Employers also constantly approach The Career Academy looking for students and employers also advertise jobs in the Career Centre (available once you enrol). You’ll also receive a FREE CV review.

This qualification is Internationally recognised. Our qualifications are highly sought after by employers around the world and accredited by global industry bodies such as ICOES.

Your course will be delivered through our online learning platform. You can access our online learning platform from any web browser 24/7 so you can work whenever and wherever you want. You can also interact with your tutors and other students within the learning environment. Online learning allows you to make the best use of your time and puts all the resources you need at your fingertips. There are no set course start dates, you can start whenever you are ready. Your tutors and student services will check in on your progress and help you every step of the way.

Watch this video to see how online learning works:

Absolutely! You’ve got a 14 day cooling off period (or trial period) at the start of your course. Take that time to look through all your learning material and get a feel for online learning. If you decide the course isn’t for you within the trial period, you’ll get a full money back guarantee.

Our students rate us
4.8 out of 5 stars on Trustpilot

Trustpilot is the platform we use to collect reviews from our students on their experience studying with The Career Academy

Get Started in 5 easy steps!

Need help? Got questions? We'd love to talk.