Course overview
Get two industry-recognised qualifications and become a Xero & Excel expert!
This package combines the Diploma in Xero and the Diploma in Excel. It will give you a comprehensive and workforce-ready understanding of both Excel and Xero, giving you essential and highly sought-after skills for any accounting, bookkeeping, finance or administration role.
Job outcomes
- Office Administrator
Study method
- Online
- Blended
- In-class
coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.
Enrol in a course today to unlock exclusive deals.
Duration study load
- 80 Hours | 6 Months Access
Study in your own time, at your own pace. Students generally complete one module per week.
Entry requirements
There are no entry requirements or pre-requisites to enrol on this course.
Course features
- Upskill in Xero & Excel and gain two qualifications to add to your CV
- Enhance your Excel and Xero skills and become confident and savvy with Excel and Xero, learning essential skills to perform advanced accounting functions
- Receive comprehensive one-on-one tutor support
- Flexible start dates – enrol online and start when you are ready
- Updated courses with the latest Xero functions, tips and tricks
- Upon successful completion, receive Xero’s official advisor certification in addition to your course qualification
- Flexible online study – work at your own pace, in your own time.
Subjects
- Introduction to Xero Online
- Xero Chart of Accounts
- Managing Contacts with Xero
- Xero Sales, Invoices, Quotes and Inventory
- Xero Purchases and Bills
- Reconciliation & Managing Accounts in Xero
- Introduction to Xero Reporting
- Introduction to Xero Add-ons
- Introduction to Xero Online
- Setting up Xero Payroll
- Managing Payroll Items with Xero
- New Employees and Leave Requests with Xero
- Pay Templates in Xero
- Pay Runs in Xero
- Payslips and Payroll Reporting with Xero
- Filing Obligations Using Xero
- Introduction to Xero Online
- Aged Receivables & Payables in Xero
- Managing Fixed Assets with Xero
- Budgeting with Xero
- Tracking Categories in Xero
- Report Preparation and Analysis in Xero
- Customising Templates in Xero
- Introduction to Projects and Expenses
- 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
The Career Academy offers a range of employer recognised courses as well as specialist courses to improve job performance. Our focus is on mentoring, inspiring and supporting people through training so their career or business can reap the rewards. The Career Academy’s course delivery is flexible, so our students can study with minimal disruption to their daily life. We offer flexible payment plans so anyone wanting to learn has the opportunity no matter their circumstances.
- The Career Academy gives you the work-ready skills you need to step into your dream career
- Study in your own time, at your own pace, and fit your learning around your lifestyle
- All while receiving exceptional support from our team of expert tutors
- Our extensive range of accredited online courses will allow you to step into our courses with your dream job in mind, and step out with your dream job in sight
- 94% of our graduates say that studying with The Career Academy has given them valuable skills to use in the workforce!
- 83% of our graduates say that The Career Academy improved their prospects of getting a new job or promotion!
- 96% of our graduates say that The Career Academy provided them with up-to-date and industry-relevant skills