Online Diploma · Xero and Excel

For Admin Staff Looking to Get Into Reporting

Thinking about the report everyone waits on each month? Six certificates take you through Xero and Excel, right up to lookups and pivot charts. Three hundred hours, spread across a year.

From €29a week, interest free
6 Certificatesin one course
300 Hoursof study, roughly
12 Monthsof access
At a Glance

Course Snapshot

Study AreaXero and Excel
DeliveryOnline, self paced, start when ready
Access12 Months Access
Study HoursAbout 300 hours
AssessmentNo exams, ever
PaymentsFrom €29 per week
Comes with
  • No accounts background needed
  • No need to be good at maths
  • Xero Advisor Certification access
  • Both tools taken to advanced level
Who It’s For

Why Do This Course

Be The One Who Builds The Report

Every team has someone who owns the numbers.

Two Tools, One Course

Xero holds the books. Excel does the thinking.

Go All The Way Up

Both diplomas run to the advanced level, not the basics.

Where The Skills Fit

Where These Skills Could Take You

Reporting work sits between the books and the people reading them. The job is clean data in, then a report someone can act on.

Accounts Assistant

Keep the daily figures moving.

Xero and Excel Support Technician

Be the person who fixes the file.

Payroll Reporting Coordinator

Pull the pay numbers together.

Excel Reporting Analyst

Turn raw data into a monthly report.

Financial Software Administrator

Look after the systems holding the books.

Bookkeeping Software Specialist

Know the tools better than anyone.

Excel Modelling Assistant

Build the sheets other people rely on.

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

Xero from daily work to advanced, then Excel the same way.

01
Xero, Day To Day
The books, on the software.
Introduction to Xero Online
Xero Chart of Accounts
Managing Contacts with Xero
Xero Sales, Invoices, Quotes & Inventory
Xero Purchases & Bills
Reconciliation & Managing Accounts in Xero
Introduction to Xero Reporting
Introduction to Xero Add-ons
02
Xero Payroll And Advanced
Wages, then the harder features.
Setting up Xero Payroll
Managing Payroll Items with Xero
New Employee & Time Off Requests with Xero
Pay Templates in Xero
Pay Runs in Xero
Payslips, Reporting & Filing in Xero
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
03
Excel, Start To Advanced
From entering data to pivot charts.
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
Introduction to Dynamic Tables
Pivot Tables
Pivot Charts
Included

What You’ll Get

In the Course

  • Xero basics, invoices, bills, bank matching
  • Xero advanced, assets, budgets, tracking
  • Excel core, data, formulas, formatting
  • Excel advanced, lookups, pivot tables, charts

As a Student

  • Self paced, about 300 hours
  • No exams, none at all
  • Access, 12 months
  • Support, phone and email
Why This One

What Makes It Different

Three things worth knowing here.

01
Excel To Pivot Tables

Lookups, dynamic tables, pivot tables and pivot charts.

02
Xero To Fixed Assets

Aged accounts, assets, budgets and tracking categories.

03
Macros Are In There

Recording macros is part of the intermediate level.

The Credentials

What You'll Earn

DIPLOMA

Certificate of Achievement

Plus Xero Advisor Certification access

Certificate Of Achievement

Issued by the college on completion.

ICOES Accredited

Accredited by ICOES and the CPD Standards Office.

Xero Advisor Access

The official vendor certification.

Getting Started

How It Works

Step one

Tell Us The Target

A reporting role, or better sheets at work.

Step two

Ask The Questions

An advisor covers both diplomas.

Step three

Choose How To Pay

Upfront, or small amounts each week.

Step four

Get Started

Enrol and open the first workbook.

The Investment

How to Get Started

From €29 / week
Pay upfront, or weekly, fortnightly or monthly.
No deposit to start
No credit check
Interest free payment plan
A course advisor can price it with you
Enquire Now
Good to Know

Common Questions

Do I need an accounts background?

None. It assumes no Xero and no Excel to start.

Do I need to be good at maths?

The course does not ask for that. Excel does the sums.

How long does it take?

About three hundred hours, over twelve months of access.

Are there exams?

None, ever. You set the pace across the year.

How far does the Excel go?

To lookups, dynamic tables, pivot tables and pivot charts.

Is payroll covered?

Yes, inside the Xero side, from setup through to filing.

Is this course accredited?

It is accredited by ICOES and the CPD Standards Office. That is industry backing, not a QQI award. It is not a national qualification. For reporting work, employers ask what you can build in Excel.

What if I change my mind?

There is a money back window. An advisor confirms the terms first.

Delivered By

About the College

This course is delivered by The Career Academy.

It is accredited by ICOES and the CPD Standards Office. It is a Xero Partner and an IAB Accredited Training Provider. It has taught for over 15 years.

ICOES accreditedCPD Standards OfficeXero PartnerAAT Approved Provider
The Monthly Report

Enquire Today

Picture the meeting where your numbers are the ones on screen.

Enquire Now