Advanced Excel Package & Advanced Certificate in MYOB Package Course Guide
Upskill and improve your career prospects and earning capabilities with The Career Academy. Watch this video and download your free info pack to find out more.
Call Us 24/7 on 1800 837 550
83% of graduates say we improved their ability to get a new job or promotion.
83%
Advanced Excel Package & Advanced Certificate in MYOB Package Course Guide
Certificate in Microsoft Excel
This course will provide an introduction to the key features of Excel, including but not limited to Excel screen components, how to start Excel and the basic layout of worksheets.
This course will provide an introduction to entering data effectively into a worksheet. It will include but not be limited to the fundamentals of data entry, how to enter and remove data from a worksheet, how to adjust a worksheet to accommodate data, and quick data entry techniques.
This course will provide an introduction to the file operations necessary for saving and accessing Excel files, including but not limited to how to save a workbook, how to open and close an existing workbook and how to move between open workbooks.
This course will provide an introduction to the fundamentals of creating calculations in Excel, including but not limited to understanding how to write formulas and use the built-in Excel functions, and the way Excel performs calculations (BEDMAS).
This course will provide an introduction to modifying the layout of a worksheet and how to copy data. It will include but not be limited to how to move and copy data in a worksheet and between worksheets and workbooks, how to make modifications to data, and how to create formulas with absolute cell references.
This course will provide an introduction to formatting commands necessary for effective presentation, including but not limited to setting the number format for cells and how to change the appearance of data using formatting options.
This course will provide an overview of print settings, including but not limited to how to preview a worksheet before printing to ensure the layout is correct and how to print all or part of a workbook or worksheet.
This course will provide an overview of the Sort and Filter features of Excel and their powerful ability to help manipulate lists of data and keep track of information in an orderly fashion. It will include but not be limited to how to sort a table of data, how to filter a table of data and how to work with filtered data.
Complete a practical case study based assessment using Excel.
Intermediate Certificate in Excel
This course will provide an introduction to the Data Sort, Filter and Subtotal features of Excel, powerful tools that enable the user to manipulate lists of data and keep track of information in an orderly fashion. It will include but not be limited to how to prepare, sort and subtotal data, how to filter data and how to trouble-shoot common Sort and Filter issues.
This course will provide an introduction to dealing with calculations that produce unexpected results. It will include but not be limited to how to check the formula is calculating as it should, how to confidently copy cell content as well as understanding how Excel treats cell references, and how to create a formula using absolute and relative cell addressing.
This course will provide an introduction to using multiple worksheets in Excel, including but not limited to how to quickly update and cross-reference between multiple worksheets in an open workbook, how to copy and move data between worksheets and how to apply formats and commands to multiple sheets.
This course will provide an overview of some of the most popular functions used within Excel to build time-saving calculations. It will include but not be limited to the different types of functions, how to insert a function, popular maths functions and logical functions, and date and time functions.
This course will provide an introduction to advanced formatting techniques, including but not limited to the application of conditional formatting to cells in a worksheet, how to manage rules and how to delete rules.
This course will provide an introduction to Macros which are excellent for reducing repetitive tasks and speeding up productivity. It will include but not be limited to recording and storing macros in current workbooks, how to record and store a macro in your personal macro workbook, assigning macros to buttons or the Quick Access toolbar, and removing macros from a file.
This course will provide an introduction to protecting data in Excel, including but not limited to how to protect your data within a worksheet, how to protect your workbook from being changed, password protection for files and removing protection from files.
This course will provide an overview of some of the key features of Microsoft 365, using Excel. It will include but not be limited to the IFS function, the FILTER function arguments, the SORT and SORTBY functions and how to fix SPILL and CALC errors.
Complete a practical case study based assessment using Excel.
Advanced Certificate in Excel
This course will provide an introduction to the basics of the different files used within excel including but not limited to text files, csv files, and how to save, import and export data.
This course will provide an introduction to how to use the various Lookup functions to cross-reference data within Excel, including but not limited to vertical lookups, horizontal lookups, the MATCH and INDEX features and the VLOOKUP, HLOOKUP and XLOOKUP functions.
This course will provide an introduction to a range of tasks that allow you to prepare data within Excel for reporting purposes. It will include but not be limited to Conditional Formatting, Rules, how to convert cell formats, how to remove duplicates, how to insert leading zeros and how to replace a formula with its result.
This course will provide an introduction to using tables in Excel, including but not limited to the use of Freeze panes, Table Filtering and Slicers, how to create a calculated column and how to analyse data using a Total Row.
This course will provide an overview of Pivot Tables, including but not limited to how to create them, how to manage the data in the table, how to display percentages, how to group data and add formulas and how to refresh the data.
This course will provide an overview of Pivot Charts, including but not limited to how to create them, how to change the design and layout, how to add and hide elements and how to create combined charts.
Certificate in MYOB Business Essentials
This course will provide an introduction to the software package MYOB Business Essentials, including but not limited to the purpose of using MYOB and cloud accounting, browser requirements, and how to navigate the software.
This course will provide an introduction to banking and the Chart of Accounts within MYOB Business Essentials, and will include but not be limited to the process for setting up the MYOB bank feed facility, the process for reconciling transactions in MYOB Business Essentials, allocation rules for new transactions, and importing statements.
This course will take a close look at working with contacts in MYOB Business Essentials, including but not limited to setting up business contacts and setting up customers and suppliers.
This course will provide an overview of setting up items in MYOB Business Essentials, the goods and services that a business may buy, sell, hire, lease or otherwise offer for payment. It will include but not be limited to setting up stock items, how to add stock or service items to quotes and invoices, and how to filter and search for items.
This course will provide an introduction to managing sales in MYOB Business Essentials, including but not limited to sending quotes to customers, how to view, create and edit customer invoices, and how to process payments, returns and credits.
This course will provide an overview of managing bills in MYOB Business Essentials, including but not limited to the process for creating bills using MYOB, how to enter payments against bills, and creating supplier returns.
This course will provide an introduction to reporting within MYOB Business Essentials, including but not limited to how to navigate the reports menu, how to generate reports and what each of the reports represents.
Complete a practical case study based assessment using MYOB Business Essentials.
Certificate in MYOB Payroll
This course will provide an introduction to the MYOB Payroll software, including how to create and activate a company file and how to load tax tables.
This course will provide an overview payroll categories within MYOB, including but not limited to the process for viewing the wages tab, the process for exempting categories from Tax and Deductions and payroll category classifications available in MYOB AccountRight.
This course will provide an introduction to employee cards and timesheets in MYOB Payroll, including but not limited to setting up employee cards, how to enter superannuation details for employees and how to review employee timesheets.
This course will provide an introduction to preparing and processing a pay run in MYOB Payroll as well as employee termination pay. It will include but not be limited to the information required to process employees’ pay, how to process a termination payment and the process for displaying the report that determines outstanding entitlements.
This course will provide an introduction to payroll liabilities, superannuation and the reporting available within MYOB Payroll. It will include but not be limited to the process for viewing a payroll liability report, the process for paying superannuation amounts for an employee and how to create a superannuation fund for employees.
Complete a practical case study based assessment using MYOB Payroll.
Here’s why they chose us:
Over 7,000 Trustpilot ratings with a 4.8 average score
Unlimited Tutor Support
Industry recognised & accredited courses
Online and available
everywhere, anytime
Start from just $25 a week
interest-free
Rolling intake
start anytime
FAQs about our MYOB courses
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,295 + 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*.
Applicants who attend job interviews with proof that they can use these standard administrative tools are more likely to succeed. These are also essential organising tools for keeping your business on track if you are self-employed.
