Language:

简体中文
English

需要帮助 请联系我们

Contact Us

在线招生中

DNC ONLINE ENROLLMENT

我们的教师团队由多名CFA持证,在国际投资银行工作多年,有教学和工作双重经验的分析师组成。主讲包括德意志银行法兰克福总部工作多年的副总裁和国际四大会计师事务所金融咨询部门的高管领队

远大精英培训由会计和金融就业服务及猎头服务三部分组成。

More than half the people in top MBA programs and a significant number of college seniors flirt with the idea of becoming a management consultant after graduation. It's a high-paying, high-profile field that offers students the opportunity to take on a lot of responsibility right out of school and quickly learn a great deal about the business world.

The big names in management consulting are well known. Bain & Co., the Boston Consulting Group (BCG), McKinsey & Co., and a solid crop of similar firms vie for contracts from the Fortune 500. Each firm has a slightly different focus, culture, and approach.

“Consulting” is a big, one-size-fits-all term that includes virtually any form of advice-giving in a business setting. The management consulting segment of the industry includes firms that specialize in providing advice about strategic and core operational issues, such as finding new channels for selling products or reducing the costs involved in producing a product. Although some of the highest profile firms populate this segment, they're not the only ones doing consulting.

Thousands of other organizations and individuals call themselves consultants and make money selling their advisory services, and they offer plenty of opportunities for employment. If you like the idea of advising businesses and you have a particular interest in computers, human resources, corporate communications, mobile communications, health care, financial services, real estate, e-commerce, or some other specialized field, there's a good chance that you can find a position within an organization doing precisely that.

Overall, the outlook for the management consulting industry is positive. We predict a steady 7% annual increase in consulting revenue across the board through the end of the decade.

WHO ARE CONSULTANTS 【谁是咨询师】

Consultants tackle a wide variety of business problems and provide solutions for their clients. Client companies hire consultants when they are up against problems that require expertise beyond what their staffs can provide, or when they need the fresh perspective of an outsider.

For consultants, this means constantly being exposed to the greatest challenges companies face: how to integrate staff and work processes after an acquisition, how to restructure after bankruptcy, where to set up manufacturing facilities abroad, how to attract and retain the right employees. Depending on the size and chosen strategy of the firm, these problems can be as straightforward as researching a new market or as complex as rethinking the client's entire organization.

By and large, the things insiders like about consulting are similar across the board. They enjoy the variety afforded by working in different industries for many different clients, the intellectual challenge of pushing themselves to the limit as they tackle complex business problems, and the people with whom they work. And they like the money and the perks. The industry pays very well, and consultants travel in style. Consulting insiders also have a litany of complaints: 60-hour workweeks are standard, extended travel is the rule, and personal plans often must be put on hold. Clients-not you-drive the deadlines, which can severely cut into your social life. In addition, at some point most consultants long for the opportunity to actually implement their great ideas.

CAREER TRACKS 【职业发展道路】

 


As each firm has its favourite buzzwords, it also has unique terminology for its rank and file. While the titles might vary from firm to firm, the roles can basically be divided as follows: analyst (also called research associate or staff consultant at some firms), consultant (or senior consultant), manager, and partner or vice president. In addition, consulting firms hire a cadre of highly capable nonprofessional staff to fill administrative and support positions.

·         ADMINISTRATIVE ASSISTANT

Most consulting firms have a fairly large pool of college-educated administrative assistants and support staff on board.

 

·         ANALYST/RESEARCH ASSOCIATE/STAFF CONSULTANT

This is the position at the bottom of the professional pyramid. The vast bulk of analysts are young, talented, and hungry college graduates.

 

·         ASSOCIATE/CONSULTANT/SENIOR CONSULTANT
This is the typical port of entry for newly minted MBAs (and increasingly for other graduate students as well). Senior consultants often perform research and analysis, formulate recommendations, and present findings to the client.

·         MANAGER
After a few years, a senior consultant will move up to manager. As the title implies, this usually means leading a team of consultants and analysts toward project completion.

·         PARTNER OR VICE PRESIDENT
This will be a role that you earn and receive congratulation from your school fellows.

 

WHAT DOES OUR PROGRAM OFFER【我们的项目提供了什么

We offer inspired students a broad range of knowledge and practical experiences stepping into management consulting industry.

Course Structure: Real consulting case study and interview preparation process delivered by experts from top management consulting firms

Course Duration: 72 hours’ full time training that is designed in line with the standard, requirement and procedure of consulting firms’ recruitment process.

Suitable for: Anyone who is looking to break into management consulting industry and meet the threshold requirements of hiring.

Course Schedule: Only open three sessions each year, limited seats per session (Please make inquiry to our consultants for course timetable) 

COURSE OUTLINES 【课程大纲】

 

Module Descriptions - Section 1

*    Advance Excel Warm Up

 

 

 

 

 

 

 

 

 

 

 

 

 

 

     

Day 1

 

 

Custom Number Format

  • Understand the structure of Custom Number Format
  • Format number in thousands, millions, billions
  • Apply special symbols in custom number format
  • Permanently hide numbers

Data manipulation

  • Popular text formulas – left, right, mid, find, concatenate, substitute
  • Find and Replace shortcut
  • Quick remove duplicate & remove blank
  • Text to columns

Most popular shortcuts

  • Format different numbers and dates
  • Quickly select big dataset
  • Turn on & turn off filter
  • Select whole row and whole column
  • Move across worksheets, workbook

Most Popular Formulas

  • Math and rounding functions (special rounding tricks)
  • The AND function, OR function
  • Nested IF function
  • The VLOOKUP function, HLOOKUP function
  • Transposing data
  • INDEX and MATCH functions

Most Popular Formulas

  • Math and rounding functions (special rounding tricks)
  • The AND function, OR function
  • Nested IF function
  • The VLOOKUP function, HLOOKUP function
  • Transposing data
  • INDEX and MATCH functions

Advanced Formulas Application

  • Array Formulas
  • Sumproduct Formulas
  • Indirect Formula
  • Offset Formula
  • 3-D Lookup, 4-D Lookup
  • Lookup for 2nd, 3rd, 4th … match

 

Name Managers

  • Understand what is name and how to use names
  • How to use shortcut to quick create multiple names and bring up names list
  • Use offset formula to create dynamic named range
  • Use dynamic named ranges to create dynamic chart
  • Use indirect and named range to automate calculation

Conditional Formatting

  • Apply format based on cell value
  • Use formulas to determine format
  • Data bar, heat map, icon set
  • Conditional Formatting – Budget Variance Analysis
  • Conditional Formatting – Project progress

Protect your data

  • Protect worksheet – locked or hidden
  • Protect workbook structure
  • Protect workbook with password to open

Work with massive workbook

  • Quickly enter data into multiple worksheets
  • Quickly change formulas in multiple worksheets
  • Manager data more efficiently across multiple worksheets
  • Change calculation method

 

 

 

 

Day 2

 

Part 1 -Advanced Charting

Create Chart

 

  • Use shortcut to create a chart
  • Put chart in a separate worksheet
  • Use different chart type

Chart Design Tips

 

  • Apply different chart styles
  • Change chart type
  • Change data source
  • Save as template

Chart Layout Tips

 

  • Understand chart area, plot area, chart titles, legends
  • Manager chart axis, gridline
  • Apply data labels and customise data labels
  • Insert pictures and shapes
  • Format Shapes

Create Special Charts

 

  • Waterfall chart
  • Speedometer chart
  • Thermometer chart
  • Funnel chart
  • Sparkline

Dynamic Chart

 

  • Data validation
  • How to use data validation to create dynamic chart

 

 

 

 

 

 

 

Day 2

 

Part 2- Pivot Table

Creating PivotTables

  • Introducing PivotTables
  • Use shortcut to create a PivotTable
  • Configuring a PivotTable – row, column, value, filter
  • Managing PivotTables

Pivot Table Design

  • Applying different PivotTable style
  • Different table layout
  • Manage grand total and subtotal
  • Row & Column header, banded row and column
  • Managing subtotals and grand totals

Manage PivotTable

  • Change PivotTable data source
  • Refresh PivotTable
  • Filtering and soring PivotTable
  • PivotTable group selection
  • Change PivotTable calculation Method
  • Add calculated fields

PivotChart

  • Creating a PivotChart
  • Apply different chart styles
  • Change chart format and layout
  • Select Data and change chart type
  • Hide all buttons
  • Use slicer to create dynamic chart
  • Customise slicer into your own style
  • Move PivotChart

PivotTable Troubleshoot

  • Can’t create PivotTable
  • Calculation not as expected
  • Remove Blank

 

 

 

Module Descriptions - Section 2

*    Case Study & Interview Preparation

Capability Area

 

Module

Content Outline

Consulting Industry

What is management consulting

·     An introduction to the management consulting industry

·     Overview of types of consulting firms

·     The Australian consulting market

·     Career paths and typical career entry points

·     Life as a consultant

·     Life after consulting

Strategic concepts

Strategic concepts 1 (strategy fundamentals)

·     What is strategy

·     Corporate vs. business unit strategy

·     Common strategy frameworks (Porters 5 forces, 3Cs, 7Ss etc.)

·     Strategic segmentation

·     Exercise

Strategic concepts 2 (corporate strategy principles)

·     Corporate strategy - the role of the parent

·     Core capability principles (Prahalad, Hamel)

·     Recent strategy concepts (Profit from the core, repeatability)

·     Exercise

Research techniques

Research techniques 1 (primary research)

·     Purpose of primary research

·     Primary research techniques

·     Common statistical analytical techniques

·     Exercise

Research techniques 2 (secondary research)

·     Secondary research overview

·     Common data sources

·     Analysing company reports

·     Exercise

Valuation analysis

Valuation analysis

·     Valuation fundamentals for consulting (net book value, multiples, DCF)

·     Exercise

Excel modelling

Excel modelling 1

·     Strategic modelling concepts

·     Modelling golden rules

·     Developing a model logic structure

·     Exercise

Excel modelling 2

·     Revenue model development exercise

·     P&L model development exercise

·     Balance sheet and cash flow model development exercise

Excel modelling 3

·     Introduction to advanced modelling concepts

·     Scenario analysis

·     Simulation analysis

·     Exercise

Operational analysis

Operational analysis

·     Operational concepts

·     Introduction to process analysis

·     Process mapping and opportunity identification

·     Exercise

Implementation

Implementation

·     Program management principles

·     Program architecture

·     Project planning

·     Exercise

General consulting skills

Strategic problem solving

·     Overview of strategic problem solving techniques

·     Overview of key concepts (MECE, 80/20, decision trees)

·     Example decision trees

·     Exercise

Working in teams

·     Consulting team structures and roles

·     Working effectively in a team

·     Personality profiling exercise

Pack structuring

·     Effective written communication principles

·     The pyramid principle

·     Examples

·     Exercise

Effective presentations

·     Effective presentation principles

·     Practice exercises

Work planning

·     Work planning concepts

·     A functional module approach to work planning

·     Exercise

Case simulation

Case simulation 1

·     Briefing

·     Work planning / team structure

·     Management interviews

·     Hypothesis development

·     Research / data gathering

Case simulation 2

·     Financial analysis / modelling

·     Pack development

·     Client presentation

Securing a consulting position

How to get a job in consulting

·     Application process

·     Screening process

·     Cover letter / CV

·     Networking

 

 

 

WHAT WILL YOU GAIN 【你能得到什么】

1.         Real world management consulting case studies and case research with professional team;

ü  On every case, study how to look at the business from a chief executive’s perspective.

ü  Start by asking the right questions, and then dig deep into the numbers to unearth the right solutions.

ü  Don’t settle for off-the shelf solutions, and learn how to customize recommendations and approach for target clients.

ü  Have some general understanding about these industries: Airlines & Transportation, Consumer Products, Financial Services, Healthcare, Industrial Goods &Services, Media, Metals &Mining, Oil & Gas, Private Equity, Retail, Social & Public Sector, Technology, Telecommunications and Utilities & Alternative Energy etc.

2.         Full scope of interview preparations;

ü  The behavioral portion: how to show your ability to effectively interact with others, make your case, convince doubters, work collaboratively in a team based on your own experience.

ü  The case portion: how to show your structured, logical thinking and problem solving ability, how to answer these questions:

*      "What is the market size for a cancer diagnostic technology in the U.S.?"

*      "How many airplanes leave from Boston's Logan Airport on Monday?"

*      "How many passengers fly through LAX in a calendar year?"

 

3.         First class networking opportunity with professionals from top tier consulting firms such as Bain & Company and McKinsey & Company

斯里兰卡是一个风景秀丽的旅游胜地,但是这里也有很多需要帮助的人们。2004 年末的海啸夺走了斯里兰卡成千上万的生命,白色的浪牙留下了成千上万的孤儿,这些孤儿无人照顾,无处上学,我们看到了他们,用爱采取行动。

与中国相似,斯里兰卡有很多女性外出打工,他们的孩子也成了留守儿童,变成了时代发展,家庭生存的牺牲品。斯里兰卡的经济发展无法与当今中国相比,这里的学生在缺乏课本的条件下无法继续学习,这里的学生几乎无法出国看到外面的世界。国际公民服务团在当地组建了学校,并联系全球合作伙伴一起提供支持,直到 2013 年,这里有了学校,有了书本,学习用具,有了国外的义工,有了知识与希望,有了仁爱。

如今,远大精英咨询集团与国际公民服务团达成官方合作,双双携手在中国、澳大利亚一起开展国际志愿者招募活动,希望有更多的学生、社会人士一起为斯里兰卡儿童献上爱心,用实际行动为他们带来教育、关怀、知识与爱,并深入了解斯里兰卡的历史、文化、宗教、人民。斯里兰卡是一个充满微笑与奇遇的国度,我们期待您的参与。

活动特点

国际志愿者义工行动是传递爱心最实际的方式;

是实现自我担当、社会责任感、增强团队合作、交际沟通能力非常有力的方式;

是深入了解世界各地风土人情最直接的方式。

 

1. 国际志愿者活动中的义工服务都是需要实实在在去完成任务的,不是旅游,也不轻松。但旅游时我们终归是过客,义工行动却可以入乡随俗,成为归人。我们拒绝传统的走马观花,拍照发朋友圈式的游游看看,而是深入当地文化中感知生活与文化。旅游可能会使你身心得到放松,但国际志愿者却能升华你的精神与心灵,我们会在义工活动中及结束后安排斯里兰卡当地旅行,带来前所未有的关于“爱在路上”的感受。

 

2.与很多义工组织不同,我们每期义工活动至少有两位专业领队带领团队,在保证团队安全、活动有序进行。同时,在出发前也会为参与者带来专业的一系列专业素质拓展和职业能力培训,使学习与旅行同时在路上。

 

3. 项目结束后,每位国际志愿者都可以获得SCI颁发的国际志愿者义工证书,并由远大精英咨询统一安排,为每位参与者提供由中共中央统战部海外人才库官方鉴定的国际志愿者履历鉴定证明,全面使国际志愿者经历升华。

 

4.最重要的是:在整个活动过程中,我们会评估各位在志愿期间的表现建立反馈机制。在结束后给大家公平的机会参与面试比赛,每期会通过面试选拔推送给1-2位同学澳洲区、中国区国际投资银行、券商等金融机构的实习或全职工作。

 

国际志愿者计划综合概述

实训部分:本项目通过五年以来的经验积累和不断改进,精心设计,划分为多个层次和章节,多维度学习和练习综合素质,包括Ice Breaking, Public Speaking, Leadership Skill, Professional CV and Cover Letter, Interview Skill, Preparation for Global Volunteer Experience and its effect on Career Development, Career Plan and practice.

国际志愿者部分:为提高学生的综合素质,海外履历。锻炼吃苦耐劳的品性、开拓眼界、培养社会责任心、组织能力、领导能力、提高英语交流能力,以及增强未来的求职能力,国际志愿者项目通过带领学员去往全世界不同国度,参与重要且有意义的义工活动来强化综合素质,提高自身水平,培养个人责任感。

1. 全方位综合能力提升:

通过参与本次国际志愿者系列义工行动,你可以获得多方面的综合能力和生活能力的提升,包括:

ü  深入体验国际志愿者精神和意义

ü  提炼个人综合能力及竞争力

ü  增强社会责任感

ü  提高英语交流能力

ü  锻造团队组织能力和领导力

ü  提升动手能力及生存能力

ü  融入斯里兰卡当地文化、传统、生活

ü  学习当地语言和歌舞

ü  领略大自然神奇风景

 

通过对专业知识、综合技能的培养,并参与当地房屋建设、义务支教、活动组织、动手能力、生存实战训练、语言歌舞学习、文化领悟、原始森林和山川大河以及热带海洋游历全面让大家体会和感悟这段一辈子难得的行程!

2.专业职业能力提升

在实战培训部分,不仅从沟通能力、表达能力、领导力方面训练大家,更会从专业的猎头角度来训练大家,配合国际志愿者的优良经历来全面塑造未来在职业领域的自身综合竞争力。专业训练包括专业简历写作、面试实战能力提升、比赛训练及反馈,职业猎头及高管团队亲自训练职业规划及细分领域职业培养,包括:会计、金融、管理咨询(不分专业背景)。

通过我们的专业能力拓展,实战面试训练、比赛反馈、高管直训、分组演练,由专业人士带队,多方面多维度的实战参与性活动,所有参与国际志愿者项目的学生可全方位体验职场文化,同时也可提升综合交流能力,综合竞争力和企业所需的多元化人才的要求

3.国际金融机构实习/全职职位推送

在整个活动过程中,我们会评估各位在志愿期间的表现建立反馈机制。在结束后给大家公平的机会参与面试比赛,每期会通过面试选拔推送给1-2位同学澳洲区、中国区国际投资银行、券商等金融机构的实习或全职工作,志愿期间表现出的综合能力将成为考量的重点参考之一。

4SCI国际简介

国际公民服务团(Service Civil International, SCI)由瑞士工程师皮埃尔.施莱索尔先生于 1920 年创建。他于第一次世界大战结束后组织的和平人道活动为今天的国际公民服务团奠定了基础。至今为止,这个组织在全球已经拥有 45 个分部,100 多个合作伙伴。

SCI 相信与不同背景的人们一同工作、生活能够帮助志愿者们消除歧视和偏见,并且让参与者体会到世界充满尊重与理解。使公益志愿就变成一种和平与合作的显示。

SCI国际公民服务团中国部现与远大精英咨询集团合作,由远大精英咨询方面独家提供专业综合素质和职业能力培训、志愿者团队所有相应规划及安排、中国区/澳洲区国际大型企业实习或全职工作内推岗位。

项目结束后,每位国际志愿者都可以获得SCI颁发的国际志愿者义工证书,并由远大精英咨询统一安排,为每位参与者提供由中共中央统战部海外人才库官方鉴定的国际志愿者履历鉴定证明,全面使国际志愿者经历升华。

双方合作,致力于为中国青年以及海外中国留学生提供更多国际文化交流的机会,提供多种志愿机会,并体现个人和企业的社会责任价值。其中,斯里兰卡国际志愿者项目是我们重要项目之一。

行程安排

斯里兰卡村庄校园支教具体安排:

我们要支教的学校坐落在斯里兰卡中部Kattiyawa 的一个小村庄。政府为学校提供教师,但是教学资料及教学设施非常有限。每个人都应该受到高质量的教育,但是这所学校因为位置偏僻,无法从外界获得关注与支持。

学校缺少足够的师资,尤其是英语老师。学校校长希望斯里兰卡当地及外国志愿者可以来学校支教,为这里的孩子带来新的希望,同时,志愿者们会用通过义工形式,为学校带来更美好的校园环境。学校缺乏一些基础设施,诸如图书馆、电脑室等。教学材料如书、铅笔、纸张等也很紧缺。

我们的工作:英语课教学;中华文化课程;国际文化传递;培育当地学生综合能力;修筑篱笆;修筑水泥墙壁;粉刷墙壁;美化学校环境等。 

招收志愿者人数:15 -20

领队:大地(SCI 负责人),远大精英咨询澳洲及中国区各区负责人 Jagath (斯里兰卡负责人

国际志愿者专业素质拓展实训部分

 

章节

内容

      时间

    地点

                   备注

章节一

志愿者专业素质拓展

Day 1

Preparation for

Sri Lanka Volunteer

 

10am-12am

Sydney/China            Volunteer Work 

                                   Preparation in Sri Lanka

                                       

Ice Breaking

 

12pm-1pm

                                   Exercise

Public Speaking

 

2pm-3pm

                                           Exercise

Leadership and Team Building

3pm-6pm

                                   Professional Training

                                   & Exercise

 

章节二

国际志愿经历运用

&个人职业素质培养

Day 2

Professional CV Workshop

 

10am-12am

 

    Sydney/China           

         CV Structure

         Design, Writing

How to upsell in interview

 

1pm-3pm

   

         Formal Dress

               

Interview

& Feedback

 

10am-5pm

   

                   

 

章节三

高管&猎头

职业规划专业训练

Day 3

Comprehensive Ability &

Career Plan

 

10am-12pm

Sydney/China             Professional

                                   Senior Recruiter

Professional Accounting 

 

1pm-3pm

                                   Senior Level Mentor

Finance 

 

1pm-3pm

                                   Management Level Mentor

Management Consulting

1pm-3pm

                                   Management Level Mentor

               

国际志愿者专业素质拓展实训部分

 

章节

内容

      时间

    地点

                   备注

章节一

志愿者专业素质拓展

Day 1

Preparation for

Sri Lanka Volunteer

 

10am-12am

Sydney/China            Volunteer Work 

                                   Preparation in Sri Lanka

                                       

Ice Breaking

 

12pm-1pm

                                   Exercise

Public Speaking

 

2pm-3pm

                                           Exercise

Leadership and Team Building

3pm-6pm

                                   Professional Training

                                   & Exercise

 

章节二

国际志愿经历运用

&个人职业素质培养

Day 2

Professional CV Workshop

 

10am-12am

 

    Sydney/China           

         CV Structure

         Design, Writing

How to upsell in interview

 

1pm-3pm

   

         Formal Dress

               

Interview

& Feedback

 

10am-5pm

   

                   

 

章节三

高管&猎头

职业规划专业训练

Day 3

Comprehensive Ability &

Career Plan

 

10am-12pm

Sydney/China             Professional

                                   Senior Recruiter

Professional Accounting 

 

1pm-3pm

                                   Senior Level Mentor

Finance 

 

1pm-3pm

                                   Management Level Mentor

Management Consulting

1pm-3pm

                                   Management Level Mentor

               

项目须知

1.请最迟在项目开始1个月前确定报名。

 

2.没有护照的同学请尽快办理护照,以防错过最佳购买机票时间。 如有需要,我们可以帮大家统一购买机票,所行成员统一随各地出发团队统一乘坐其相应的飞机出行。

 

3.如有需要,签证我们可以集中帮同学们办理,24 小时内获得电子签。

 

4.项目费用不包括往返斯里兰卡机票费用、签证费用、自己购物费用。我们所收取的部分项目费用我们会捐助当地学校,用以购买教学设施。

 

5.项目为义工和旅行,会有体力活动及支教活动,不是去享受但很有意义,终生难忘,请怀着志愿精神报名。

 

6.具体活动详情请关注远大精英咨询官方微信公众号或官网往期项目推送,或与工作人员联系。 

 

 

 

 

 

 

 

 

 

Assistant Accountant (Intermediate - Senior)PRICE:$0.00
Course Start Date Class Time Enroll Status
AA-Month End & Reconciliation (Intermediate - SeniPRICE:$0.00
Course Start Date Class Time Enroll Status
AA-Year End GL Reconciliation (Intermediate - SeniPRICE:$0.00
Course Start Date Class Time Enroll Status
AA-Revising & Reporting (Intermediate - Senior)PRICE:$0.00
Course Start Date Class Time Enroll Status

火热招生中

PROFESSIONAL RECOMMENDATION

Course Start Date Class Time Price
Junior Public Accounting (Tax Based)2015年3月26日初中级Public Accounting (Tax based) 03/26/2015 2015年3月26日-5月2日 $0.00
回到顶部

网上报名CLOSE

Not see, tap