Course overview
Gain an advanced workforce-ready skill set in Excel
It’s one of the most highly awarded courses that you could take. The Advanced Microsoft Excel Package for accountancy, bookkeeping and administration roles is loaded with specially rated achievements. These include certificates in Microsoft Excel, Intermediate Microsoft Excel, and Advanced Certificate in Excel. If you want to be quickly acknowledged and highly rewarded, then this package is the one.
Job outcomes
- Administrator
Recognition
Study method
- Online
- Blended
- In-class
Duration study load
- 6 Months Access | 90 hours
Study at your own pace – students generally complete one module per week.
Entry requirements
There are no entry requirements or prerequisites to enrol on this course.
Course features
- Upskill and gain 3 Microsoft Excel Certificates to add to your CV.
- Gain advanced Microsoft Excel skills.
- Learn online, at your own pace, with tutor support by phone and email.
- Gain a comprehensive and practical understanding of how to use Excel to turn meaningless numbers into useful information.
- Enhance your Excel skills and become confident and savvy with Excel, learning essential skills to perform advanced excel functions.
- Flexible online study – work at your own pace, in your own time.
- The content of this course has been certified by the CPD Certification Service. Gain 90 CPD hours on completion.
Professional recognition
Approved by CPD
Accredited by ICOES
Delivery
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.
Subjects
- Introducing Excel
- Entering Data
- File Operations
- Performing Calculations
- Modifying the Worksheet
- Formatting
- Printing
- Sorting and Filtering
- Working with Large Tables of Data
- When Formulas Don’t Calculate as Expected
- Using Multiple Worksheets
- Time-Saving Functions
- Conditional Formatting
- Introduction to Recording Macros
- Protecting
- Microsoft 365 Functions
- Importing and Saving Plain Text Files
- Lookup and Cross-Reference
- Preparing Data for Reporting
- Using Tables
- Pivot Tables
- Pivot Charts
About The Career Academy
We're an internationally recognised online education provider, who partners with the industry to deliver you the latest and most up-to-date content. We have almost 15 years of experience in online education and help change the lives of over 20,000 students every single year.
- Upskill and be awarded a certificate of achievement to help you reach your potential & earn more.
- Flexible online learning so you can study whenever and wherever you want.
- Get free access to the career centre which will review and improve your CV to help you succeed.
- 83% of our graduates say our qualifications improved their ability to get a new job or promotion.
