The Ultimate Accounting Boot Camp- Dec Mel

The Ultimate Accounting Boot Camp

This course is designed for university graduates who wish to have a practical view of entry level accounting jobs including Accounts Payables, Accounts Receivables, Assistant Accountant, Payroll officer, Junior Accountant or Business Services Accountant. The course is designed based on real case scenarios and all practice materials are from real working environment, which will bring students into a real working environment and prepare them for real job market challenge.

What is covered:

Commercial Accounting -Financial Reporting -36 Hours (MYOB, SAP, Excel)
Public Accounting -Business Service Accounting – 45 Hours （Handisoft, MYOB & Excel）
Intermedium to advance Microsoft Excel – 12 Hours
Interview skill & CV workshop – 6 Hours
Professional Career Development program -24 Hours（Mock interview with Recruitment Agent & Assessment centre day）
3 months local mid to large size company finance department internship

We are popular because we offer:

Real cases, real exerises, real trainings, put your foot into the real shoes in a work place;
Independent working environment just like in a real office, combined with tutors' training and guidance, in order to get students to be real "hands-on";
Real world problems and issues tackling techniques, problem solving skills building;
Upgraded soft skills enhancement, first class training module - PCD (Professional Career Development Program);
100% guaranteed internship placement, 3 months internship in local firms, get your hands on mid-mega size firms' finance team.

Suitable for:

Accounting major students or graduates
Preliminary accounting experiences is required.

Course Modules 课程模块介绍

Part One: Commercial Accounting Modules

Total :36 hours

Module	Section	Hours	Software	Teacher
Module 1 Introduction + Accounts Receivable	Section 1 Introduction +AR (Mid-size company)	3 Hours	MYOB Excel	James
Module 1 Introduction + Accounts Receivable	Section 2 Introduction + AR (Big Company)	3 Hours	SAP Excel	Karen
Module 2 Accounts Receivable + Accounts Payable	Section 3 AR+AP (Mid-size company)	3 Hours	MYOB Excel	James
Module 2 Accounts Receivable + Accounts Payable	Section 4 AR+AP (Big Company)	3 Hours	SAP Excel	Karen
Module 3 Accounts Payable	Section 5 AP (Mid-size company)	3 Hours	MYOB Excel	James
Module 3 Accounts Payable	Section 6 AP (Big Company)	3 Hours	SAP Excel	Karen
Module 4 Accounts Payable + Payroll	Section 7&8 AP +Payroll	6 Hours	MYOB	James
Module 5 Accounts Payable + Assistant Accountant	Section 9 AP + AA	3 Hours	SAP Excel	Karen
Module 6 Month- end	Section 10 &11 Month End Procedures	6 Hours	MYOB Excel	James
Module 7 Month End + Assistant Accountant	Section 12 Month End + Assistant Accountant	3 hours	SAP Excel	Karen

Part Two: Public Accounting Modules

Total : 45 hours

Module	Section	Hours	Software	Teacher
Module 1 Industry Introduction+ Partnership BAS	Section 1 Industry Introduction &Partnership Introduction	3 Hours	Handisoft Excel	Rick
	Section 2 GST BAS& PAYG, Inventory System	3 Hours	Handisoft Excel	Rick
	Section 3 Data entry & BAS processing	3 Hours	Handisoft Excel	Rick
	Section 4 Q2,3,4 BAS processing &Month End Reconciliation	3 Hours	Handisoft Excel	Rick
	Section5 Year End Entry & Depreciation	3 Hours	Handisoft Excel	Rick
Module 2 Partnership & Individual Tax Return	Section 6 Partnership Tax Return & Business Schedule	3 Hours	Handitax Excel	Maggie
	Section 7 Individual Tax return	3 Hours	Handitax Excel	Maggie
	Section 8 Rental Schedule & CGT	3 Hours	Handitax Excel	Maggie
Module 3 Company Tax Return	Section 9 Company Introduction & Bookkeeping	3 Hours	MYOB Excel	Rick
	Section 10 Hire Purchase & Division 7A	3 Hours	Handisoft Excel	Rick
	Section 11 Company Tax Reconciliation & Return	3 Hours	Handitax Excel	Maggie
Module 4 Trust Tax Return & FBT	Section 12 Trust Introduction	3 Hours	Handisoft Excel	Rick
	Section 13 General Entries & FBT Introduction	3 Hours	Handisoft Excel	Rick
	Section 14 Trust Tax Return	3 Hours	Handitax Excel	Maggie
Module 5 ATO Administration	Section 15 Variable Time to Finalize Case & ATO Administration	3 Hours	Excel	Maggie

Part Three: Excel Skills – Course Outline

Total: 12 hours

Day

Topic

Detail

Day 1 Morning 10am-1pm

Data Manipulation

• Dealing with columns/rows

• freezing panes & Autofill

• Absolute/Relative cell addressing

• Paste Special - Format Painter

• Indenting/rotating cells - Wrap/merge

• Customising quick access toolbar - Comparing side by side

• Filter/Advanced Filter

• Go to “Special”

• Find & Replace

• Watch Window

Auto-Calculate Feature

• Different auto-calculate functions

• Range names

• Lookups functions

• Vlookup

• Hlookup

• Index/match

• Row/column

• Indirect

• Address

Scenario Functions

• Choose

• Offset

• Goal seek

Day 1 Afternoon 2pm-5pm

The IF Function

• Using the IF function

• Using the IF function to display messages

• Nesting functions

• Using Boolean logic (AND, OR)

Arithmetic & Logical Functions

• Average

• Min/max

• Large/small

• Countif/countifs

• Sumif/sumifs /Abs

• Iferror /Product

• Sumproduct/Irr /Npv

Text & Formatting Functions

• Concatenate

• Today

• Edate

• Lower/upper/Proper

• Left/right/mid

• Trim /Find /Search/Replace

• Len/Value

Day

Topic

Detail

Day 2 Morning 10am-1pm

Data Validation

• Worksheet Protection

• Protecting a worksheet

• Removing the Protection

• Protecting a spreadsheet

Charts

• Titles

• Gridlines

• Legend

• Borders

• Axes

• Axis Titles

• Colours

• Secondary Axis

• Data Labels

• Combination Charts

Data Handling Techniques

• Text To Columns

• Remove Duplicates

• Grouping/Hiding

• Auditing Worksheets

• Identifying formulas in the spreadsheets

• Tracing precedents/dependents

Day 2 Afternoon 2pm-5pm

PivotTables

• Create, rearrange, design

• PivotTable Options

• Grouping/Ungroup

Macros

• Recording/Running a Macro

• Absolute and Relative referencing in Macros

• Viewing/Editing Macros

• Creating Macro buttons

Printing Techniques

• Using Page Break Preview - Page setup: Orientation

• Scaling

• Centre on page

• Header/footer

• Gridlines

• Rows/columns to repeat

Case Study 1 - AR Aging Report

Case Study 2 - Accrued Expense

Excel Keyboard Shortcuts

Part Four: Professional Career Development Program

Total: 30 Hours

In this module, students will be set under real interview environment with our local recruiters. Students are expected to go through one to one mock interview and assessment centre day like working in a real company scenario, which are all designed according to international hiring standards and recruitment process

Part 1. Resume and cover letter writing

Basics of resume writing
Different kind of resumes and which one to use
Dos and Don’ts
How to summarize your school/work history in less than 2 pages
How to tailor your resume and cover letter to specific jobs and companies

Part 2. Resume rescue workshop & Interview Preparation

Practical hands on resume writing activity
How to brainstorm ideas for showcasing yourself in the best light
How to identify and highlight your achievements on paper
What’s missing from your resume and what you should include

Part 3: Interview preparation workshop

One on one help and review by career coach
Common interview questions
How should you prepare for telephone interview
Behaviour questions types and how should you structure your answers

Part 4: 1 to 1 Mock interview with local recruiter and video recording

Each student will be given a real job description to prepare for the interview targeting specific jobs
Each student will be interviewed by our local recruiter
Video recording will be conducted while students are being interviewed
All interviews are conducted in English only

Part 5: 1 to 1 interview feedbacks and improvement advice

Interview videos will be reviewed one by one by recruiter
Specific feedbacks will be given out according to each students’ interview performance
Common interview mistakes will be analysed and explained in detail
Recommended answers will be given in order to improve students interview skills

Part 6: Group interview assessment centre day

Following the submission of the application form and psychometric testing, some employers may conduct testing in an assessment centre.
Assessment centres are commonly used by large companies throughout the world.
They are collections of tests and exercises designed to simulate an employer’s business environment.
They generate objective information about applicants, such as those with the most suitable personal attributes and problem solving or teamwork skills.
They can also determine who would fit best and excel within the organisation’s structure and culture.

Activities including: