Diploma in Excel and Bookkeeping

Gain an advanced workforce ready skill set in Excel

What a great course this is. You’ll learn to balance the books, prepare VAT returns, keep business accounts;  analyse and interpret a profit and loss statement and balance sheets. 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, Advanced Certificate in Excel. If you want to be quickly acknowledged and highly rewarded, then this package is the one.
ICOES Logo
AAT Logo
Sage Logo
International Asociation of Bookkeepers Logo
Excel Logo

All the right credentials

  • Upskill and gain 3 Microsoft Excel Certificates to add to your CV
  • 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
  • Work from home, start your own Bookkeeping business
  • The Career Academy is an Official Xero and IAB and Education Partner – get the latest functions, tips and tricks
  • Developed and delivered by an Accredited Training Centre – International Association of Bookkeepers and Institute of Certified Bookkeepers.

Course Summary

Investment: €899 or €25/week on an interest free payment plan

Qualification information: Upon successful completion, you will receive the following certificates, including a Diploma in Microsoft Excel: 

  • Certificate in Microsoft Excel
  • Intermediate Certificate in Excel
  • Advanced Certificate in Excel
  • Certificate in Bookkeeping

Pre-requisites: None

Delivery: Online with tutor support via email

Duration: Fit study around your schedule, in your own time and expect to take around 250 hours.

Access Time: You will have access to this course for up to 12 months until you complete.

Course content

  1. Introducing Excel
  2. Entering Data
  3. File Operations
  4. Performing Calculations
  5. Modifying the Worksheet
  6. Formatting
  7. Printing
  8. Sorting and Filtering
  1. Working with Large Tables of Data
  2. When Formulas Don’t Calculate as Expected
  3. Using Multiple Worksheets
  4. Time Saving Functions
  5. Conditional Formatting
  6. Introduction to Recording Macros
  7. Protecting
  8. Microsoft 365 Functions
  1. Importing and Saving Plain Text Files
  2. Lookup and Cross-Reference
  3. Preparing Data for Reporting
  4. Using Tables
  5. Pivot Tables
  6. Pivot Charts
  1. Accounting and Bookkeeping Fundamentals
  2. General Journal
  3. General Ledger and the
  4. Trial Balance
  5. Depreciation
  6. Accruals and Prepayments
  7. Financial Statements
  8. Fundamentals of VAT
  9. Fundamentals of Payroll
  10. Accounting with Sage and Quickbooks
  11. Accounting with Xero Budgeting, Forecasting, and Cashflow Management
  12. Bookkeeping Using Microsoft Excel

This Course is accredited by ICOES

The International Council for Online Educational Standards (ICOES) guarantees you a high standard of content with measurable outcomes from a reputable training organisation. ICOES is the accrediting body that monitors and continually develops the educational standards of online teaching institutions.

ICOES Logo
Tutor Portrait

Receive unlimited support from experienced tutors!

Our professional tutors at The Career Academy are industry experts who are passionate about helping students succeed.

They’re committed to providing exceptional online course support and personal tutoring to help you succeed. Throughout your course, you’ll receive unlimited tutor support via phone and email.

Be awarded with an Industry & Employer Recognised Certificate

Upon successful completion of your course, you’ll be presented with a Professional Certificate by The Career Academy. This is an industry recognised certificate which will go a long way to helping you get a new job or promotion. You’ll also be given access to our exclusive Career Centre and be eligible for a free CV Review.

TCA Certificate

Download a FREE course guide to find out more

Fill in this form to discover where The Career Academy can take you!

Complete this form & learn about:

✓ Pricing and payment options

✓ Course information

✓ Compare other related courses

✓ Receive a FREE course consultation

✓ Everything you need to know before enrolling!

  • Enter your details below *

Your information is safe with us. By submitting this form, you agree to our Privacy Policy
0

Your Cart