Language:

简体中文
English

需要帮助 请联系我们

Contact Us

课程详细介绍

DNC ONLINE ENROLLMENT

2017-3-20

Camp Launch
5pm-7pm
Public Accounting
Session 1
7pm-9pm

2017-3-21

Public Accounting
Session 2
6pm-9pm

2017-3-22

Public Accounting
Session 3
6pm-9pm

2017-3-23

Public Accounting
Session 4
6pm-9pm

2017-3-25

Excel Day 1
10am-5pm

2017-3-26

Excel Day 2
10am-5pm

2017-3-28

Public Accounting
Session 5
6pm-9pm

2017-3-29

Public Accounting
Session 6
6pm-9pm

2017-3-30

Public Accounting
Session 7
6pm-9pm

2017-4-1

MYOB Session 1&2
10am-5pm

2017-4-2

SAP Session 1&2
10am-5pm

2017-4-4

Public Accounting
Session 8
6pm-9pm

2017-4-5

Public Accounting
Session 9
6pm-9pm

2017-4-6

Public Accounting
Session 10
6pm-9pm

2017-4-7

Professional CV
6pm-9pm

2017-4-8

SAP Session 3&4
10am-5pm

2017-4-9

SAP Session 5
MYOB Session 3
10am-5pm

2017-4-10

Interview Skills
6pm-9pm

2017-4-11

Public Accounting
Session 11
6pm-9pm

2017-4-12

Public Accounting
Session 12
6pm-9pm

2017-4-13

Public Accounting
Session 13
6pm-9pm

2017-4-14

Interview Practice
6pm-9pm

2017-4-15

MYOB Session 4&5
10am-5pm

2017-4-16

MYOB Session 7
SAP Session 6&7
10am-5pm

2017-4-17

Corporate English
6pm-9pm

2017-4-18

Public Accounting
Session 14
6pm-9pm

2017-4-19

Public Accounting
Session 15
6pm-9pm

2017-4-20

Group Interview
Practice
6pm-9pm

2017-4-21

DNC Assessment
Centre Day
10am-6pm

2017-4-22

Mock Interview
10am-6pm

2017-4-23

Interview Review
10am-5pm
Post Camp Party

2016-11-23

Camp Launch
5pm-7pm
Public Accounting Session 1
7pm-9pm

2016-11-24

Public Accounting
Session 2
6pm-9pm

2016-11-25

Public Accounting
Session 3
6pm-9pm

2016-11-26

Commercial Accounting MYOB Session 1&2
10am-5pm

2016-11-27

Commercial Accounting SAP Session 1&2
10am-5pm

2016-11-28

Public Accounting
Session 4
6pm-9pm

2016-11-29

Public Accounting Session 5
6pm-9pm

2016-11-30

Public Accounting Session 6
6pm-9pm

 

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 HoursMock 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

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

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

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:

  • work-typical exercises
  • group discussions
  • case studies
  • role-plays
  • presentations.

带队教师介绍

Sonia S.
Sonia S.

王牌讲师

James L
James L

王牌讲师

Rick S.
Rick S.

王牌讲师

Lauren L
Lauren L

王牌讲师

Eleanor H.
Eleanor H.

王牌讲师

Cindi W.
Cindi W.

王牌讲师

Ming Ye
Ming Ye

王牌讲师

Maggie
Maggie

王牌讲师

Wensu
Wensu

王牌讲师

回到顶部

网上报名CLOSE

Not see, tap