Get Free Course Guide

Advanced Excel Package & Advanced Xero Package

$1,795.00

It’s all about confidence, find it, grow it, use it

Gather sought-after administration and office management skills with a comprehensive package that includes training to manage payroll items, employee leave requests, and payslips using templates in Xero Excel. Use Excel and Xero study to understand how to handle large data tables and discover troubleshooting tips when formulas don’t calculate as expected on your worksheets. Along with a section introducing you to recording macros, you will grow more confident with Microsoft 365 functions and discover ways to streamline admin tasks with vital shortcuts. Enrol today to round out your natural talent with measurable skills.
Or Call 1800 837 550

100% Online Delivery

Get instant access

Plus receive unlimited tutor support via phone & email from experienced professionals.

Course Duration

6 Months Access
 | ~130 Hours
Study at your own pace – students generally complete one module per-week. See our free course guide for detailed duration information.

Get qualified & Earn More

Become an expert in Xero

Be awarded with a Xero Certified certificate of achievement on completion of this course.

Investment & Payment

Improve your career prospects from just $25 per week.
Enrol with a flexible payment plan or pay upfront and save.

Enrol now.

INDUSTRY
RECOGNISED

Microsoft-Excel-Logo
Trustpilot

I FELT LIKE THERE WAS A CLEAR OUTCOME WITH WHAT I COULD DO WITH THE CAREER ACADEMY'S COURSES!

Almost immediately, it was the AAT Accounting Technician Pathway Program that caught her eye. ‘It offered me the accounting theory that I needed, with the option to add “Accounting Technician” status to my name, along with applying all my theoretical knowledge into practice through the use of accounting software such as Xero. It was also a lot more value for money than other courses I had researched.

CAREER BENEFITS

  • Learn to use multiple worksheets in Excel
  • Explore time-saving functions that speed up admin tasks
  • Grow your confidence across Excel & Xero – highly marketable skills
  • Gain two qualifications to add to your CV
  • Learn to perform advanced accounting functions with Excel and Xero study
  • Fit your study in around your current work with flexible online courses
  • Receive access to Xero’s official advisor certification in addition to your course qualification

COURSE CONTENTS

  • 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
  • Introduction to Xero Online
  • Xero Chart of Accounts
  • Managing Contacts with Xero
  • Xero Sales, Invoices, Quotes & Inventory
  • Xero Purchases & Bills
  • Reconciliation and 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 & Leave Requests with Xero
  • Pay Templates in Xero
  • Pay Runs in Xero
  • Payslips & 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

International Accreditation at the highest level

  • ICOES is an International Organisation that accredits credible and verifiable qualifications, so you can rest assured you’re completing a qualification that you can have faith in
  • This internationally accredited certificate  holds immense value, not only boosting market recognition but also serves as a prominent testament of accomplishments.

Flexible Payment Options

$1,795.00

POPULAR

PAY IN FULL AND SAVE $400

Discounted price

$1,795.00 + GST

Pay your course fees upfront and benefit from a $400 discount, with a 7 day money-back guarantee.

Pay a total of $1,795.00 + GST around your schedule with our flexible, interest-free payment plan, that also includes a 7 day money back guarantee.

Get all the info you need

  • Course duration, qualifications and module details
  • Pricing and payment options
  • Compare other related courses
  • Receive a free course consultation

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

Frequently
Asked
Questions

There are no entry requirements or prerequisites to enrol on this course. You can enrol online directly by clicking “Enrol Now” and following the prompts. Alternatively, you can enrol over the phone with our friendly student advisors – call 1800 837 550 or email info@thecareeracademy.com.au

This course costs $1,795 + GST or only $25 per week on a no-deposit, interest-free payment plan. Click here to get started now.

This course takes approximately 80 hours, and you’ll have up to 6 months to complete. Study in your own time, at your own pace. Most of The Career Academy courses are designed so that you do one module a week, but if life gets busy, you can apply for a course extension if you need more time.

Upon completing this course, you could obtain work as an Administration Assistant.

Contact a friendly student advisor on 1800 837 550 to learn about potential career outcomes and where our courses could take you. Employers often approach The Career Academy looking for students and advertise jobs in our Career Centre, which you can access once enrolled. You’ll also receive a FREE CV review.

Your course is delivered through our online learning platform, which you can access from any web browser 24/7 to 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 necessary resources at your fingertips. There are no set course start dates; you can start whenever you are ready, and your tutors and student services will check in on your progress and help you every step of the way.

Watch this video to see how online learning works:  

Absolutely! You’ve got an 7-day cooling-off period (trial period) at the start of your course. Take that time to review all your learning material and get a feel for online learning. If you decide the course isn’t for you within the trial period, you’ll get a full money-back guarantee*.

The Official Xero Advisor Certification is provided/delivered by Xero. Once you have completed your training course with TCA, you undertake the official Xero Advisor Certification process. Upon achieving successful Xero Advisor Certification, Xero will award you the certification.