12 Months Access | 300 Hours Diploma in Xero and Diploma in Excel

This comprehensive package combines the Diploma in Xero and the Diploma in Excel, equipping you with the practical skills needed to excel in accounting, bookkeeping, finance, and administration roles. Develop a deep understanding of these essential tools and gain in-demand expertise to boost your career prospects. Enrol today and take the next step towards professional success!

Covering 6 Certificates

Certificate in Xero

1. Introduction to Xero Online
2. Xero Chart of Accounts
3. Managing Contacts with Xero
4. Xero Sales, Invoices, Quotes & Inventory
5. Xero Purchases & Bills
6. Reconciliation & Managing Accounts in Xero
7. Introduction to Xero Reporting
8. Introduction to Xero Add-ons
9. Certificate in Xero Assessment

Certificate in Xero Payroll

1. Introduction to Learn Xero Online
2. Setting up Xero Payroll
3. Managing Payroll Items with Xero
4. New Employee & Time Off Requests with Xero
5. Pay Templates in Xero
6. Pay Runs in Xero
7. Payslips, Reporting & Filing in Xero

Advanced Certificate in Xero

1. Introduction to Xero Online
2. Aged Receivables & Payables in Xero
3. Managing Fixed Assets with Xero
4. Budgeting with Xero
5. Tracking Categories in Xero
6. Report Preparation and Analysis in Xero
7. Customising Templates in Xero
8. Introduction to Projects and Expenses
9. Advanced Certificate in Xero Assessment

Certificate in Microsoft Excel

1. Introducing Excel
2. Entering Data
3. File Operations
4. Performing Calculations
5. Modifying the Worksheet
6. Formatting
7. Printing
8. Sorting and Filtering

Intermediate Certificate in Microsoft Excel

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

Advanced Certificate in Microsoft Excel

1. Importing and Saving Plain Text Files
2. Lookup and Cross-Reference
3. Preparing Data for Reporting
4. Introduction to Dynamic Tables
5. Pivot Tables
6. Pivot Charts