Online Package · Excel and Xero

Get Into Accounts Support Work

Whether you handle numbers at work or want to start, two tools open doors. This package runs Excel from basics to pivot tables, then Xero through payroll and reporting. It is built for office and accounts work.

From $29per week, no deposit
6 Monthscourse access
130 hoursof study, roughly
No Examsever
At a Glance

Course Snapshot

Study AreaExcel, Xero and Payroll
Course Access6 Months
Study HoursAbout 130 hours
Study ModeOnline, self-paced
AssessmentNo exams
PaymentsFrom $29 per week
Comes with
  • Start anytime
  • Six courses in one package
  • Xero Advisor Certification access
  • Unlimited tutor support
Who It’s For

Why Do This Course

Be The Spreadsheet Person

Every office has one, and they get asked for everything. Lookups, pivot tables and macros put you there.

Run The Books Too

Xero covers invoicing, reconciliation, payroll and reporting. Together with Excel, that is most of an accounts job.

Two Skills, One Enrolment

Six courses sit inside this package. You pay once and work through both tracks.

Where The Skills Fit

Where These Skills Could Take You

Small businesses, accounts teams and support roles all lean on these two tools. The day means clean data, tidy books, and reports that turn up on time.

Xero And Excel Specialist

Support a business across both tools. Depth in each is the whole point.

Accounting Systems Support Officer

Keep the finance systems running for a team. Setup and troubleshooting skills matter.

Management Reporting Analyst

Build the reports leaders read. Pivot tables and Xero reporting carry it.

Data Integrity Analyst

Check and clean the numbers before they go out. Lookups and validation are daily.

Roles where these skills are useful, not promised outcomes. Every role is different, and some need more study or experience.

The Course

What You'll Learn

Six courses: three levels of Excel, then Xero, payroll and advanced Xero.

01
Excel Foundations
From a blank sheet to sorted, formatted data.
Introducing Excel
Entering Data
File Operations
Performing Calculations
Modifying the Worksheet
Formatting
Printing
Sorting and Filtering
02
Excel At Work
Bigger data, and the shortcuts that save hours.
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
03
Excel For Reporting
The advanced end, where the reports get built.
Importing and Saving Plain Text Files
Lookup and Cross-Reference
Preparing Data for Reporting
Introduction to Dynamic Tables
Pivot Tables
Pivot Charts
04
Xero Essentials
Setting up and running the daily accounts.
Introduction to Xero Online
Xero Chart of Accounts
Managing Contacts with Xero
Xero Sales, Invoices, Quotes & Inventory
Xero Purchases and Bills
Reconciliation and Managing Accounts in Xero
Introduction to Xero Reporting
Introduction to Xero Add-ons
05
Xero Payroll
Paying people correctly, every cycle.
Setting up Xero Payroll
Managing Payroll Items with Xero
New Employees & Leave Requests with Xero
Pay Templates in Xero
Pay Runs in Xero
Payslips & Payroll Reporting with Xero
Employment Payment Summaries with Xero
06
Advanced Xero
The features that tidy up a client file.
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
Included

What You’ll Get

In the Package

  • Excel, three levels, basics to pivot charts
  • Xero essentials, invoices and reconciliation
  • Xero payroll, pay runs and payslips
  • Advanced Xero, assets, budgets, tracking

As a Student

  • 6 months access, start anytime
  • No exams, work at your own pace
  • Tutor support, phone and email
  • Career support, CV review and interview help
Why This One

What Makes It Different

Three things this package does that a single course cannot.

01
Excel To Pivot Tables

Three levels of Excel, ending at dynamic tables, pivot tables and pivot charts. That is the reporting end.

02
Payroll Included

Pay runs, leave requests, payslips and payment summaries all feature. Payroll is where small businesses get stuck.

03
Advanced Xero Too

Fixed assets, budgets, tracking categories and templates round it out. Not just the beginner file.

The Credentials

What You'll Earn

PACKAGE

Certificate of Achievement

Six courses across Excel and Xero, in one package

Certificate Of Achievement

Issued by the college once you finish the package.

Xero Advisor Certification

Access comes with the package, and Xero issues it.

A Credential To Share

A SEEK Pass credential comes with your certificate, ready for SEEK.

Getting Started

How It Works

Step one

Send An Enquiry

Tell us the package and a good time to talk.

Step two

Check The Level

A course advisor makes sure the starting point suits you.

Step three

Choose Payments

Upfront, or weekly, fortnightly or monthly.

Step four

Start On Either Track

Enrol and log in. Begin with Excel or Xero, your call.

The Investment

How to Get Started

From $29 / week
Pay upfront, or spread it weekly, fortnightly or monthly.
No deposit to start
No credit check
10-day money back guarantee
Fees are quoted plus GST
Enquire Now
Good to Know

Common Questions

Do I need to be good at Excel already?

Not at all. The package opens at the very beginning, with entering data and simple calculations.

How long does it take?

About 130 hours across six courses, with six months of access. Most people study a few hours a week.

Do I need accounting experience?

No. You do not need Xero, payroll or reporting experience on day one. Each track starts from scratch.

Which should I start with?

Either. Excel first suits people heading toward reporting. Xero first suits anyone about to take on the books.

Does it cover payroll rules?

It covers running payroll in Xero, including pay runs, leave, payslips and payment summaries. Award interpretation sits outside the course.

Is this package accredited?

It carries industry accreditation with ICOES and the CPD Standards Office, and the college is registered with the International Approval and Registration Centre. It is not a nationally recognised qualification, and the college is not an RTO. Employers hiring for these roles test the software, not the certificate.

Can I get a refund?

Yes. A 10 day money back guarantee applies from enrolment.

Delivered By

About the College

This package is delivered by The Career Academy.

The college has over fifteen years behind it and works with more than 25,000 students a year. It is a Xero Partner and an MYOB Approved Education Partner.

Over 15 years teachingXero PartnerMYOB Approved Education PartnerAAT Approved Training Provider
One Step Left

Enquire Today

Picture the day the reports come out of your hands, and nobody has to check them twice.

Enquire Now