Intermediate Certificate in Microsoft Excel Course Guide
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.
83% of graduates say we improved their ability to get a new job or promotion.
83%
Intermediate Certificate in Microsoft Excel Course Guide
Modules
This course will provide an introduction to the Data Sort, Filter and Subtotal features of Excel, powerful tools that enable the user to manipulate lists of data and keep track of information in an orderly fashion. It will include but not be limited to how to prepare, sort and subtotal data, how to filter data and how to trouble-shoot common Sort and Filter issues.
This course will provide an introduction to dealing with calculations that produce unexpected results. It will include but not be limited to how to check the formula is calculating as it should, how to confidently copy cell content as well as understanding how Excel treats cell references, and how to create a formula using absolute and relative cell addressing.
This course will provide an introduction to using multiple worksheets in Excel, including but not limited to how to quickly update and cross-reference between multiple worksheets in an open workbook, how to copy and move data between worksheets and how to apply formats and commands to multiple sheets.
This course will provide an overview of some of the most popular functions used within Excel to build time-saving calculations. It will include but not be limited to the different types of functions, how to insert a function, popular maths functions and logical functions, and date and time functions.
This course will provide an introduction to advanced formatting techniques, including but not limited to the application of conditional formatting to cells in a worksheet, how to manage rules and how to delete rules.
This course will provide an introduction to Macros which are excellent for reducing repetitive tasks and speeding up productivity. It will include but not be limited to recording and storing macros in current workbooks, how to record and store a macro in your personal macro workbook, assigning macros to buttons or the Quick Access toolbar, and removing macros from a file.
This course will provide an introduction to protecting data in Excel, including but not limited to how to protect your data within a worksheet, how to protect your workbook from being changed, password protection for files and removing protection from files.
This course will provide an overview of some of the key features of Microsoft 365, using Excel. It will include but not be limited to the IFS function, the FILTER function arguments, the SORT and SORTBY functions and how to fix SPILL and CALC errors.
Complete a practical case study based assessment using Excel.
Here’s why they chose us:
Over 7,000 Trustpilot ratings with a 4.8 average score
Unlimited Tutor Support
Industry recognised & accredited courses
Online and available
everywhere, anytime
Start from just €25 a week
interest-free
Rolling intake
start anytime
STUDENT
REVIEWS
FAQs about our Excel course
There are no entry requirements or prerequisites to enrol on this course. You can enrol online directly by clicking on “Enrol Now” and following the prompts.
Alternatively, you can enrol over the phone with our friendly student advisors – call 01 437 8559 or email info@careeracademy.ie
This course costs €349.00 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 apply for a course extension if you need more time.
Upon completing this course, you could obtain work as an Administration Assistant.
Contact a friendly student advisor on 01 437 8559 to learn about potential career outcomes and where our courses could take you. You’ll also receive a FREE CV review.
Your course is delivered through our online learning platform, which you can access from any web browser 24/7 to 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 necessary resources at your fingertips. There are no set course start dates; you can start whenever you are ready, and 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 (trial period) at the start of your course. Take that time to review 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*.
Yes. You can complete a course with The Career Academy and get Excel certifications online. You will learn time-saving functions, conditional formatting, and other useful skills.
