First, the curriculum value

In the information age, in addition to building professional information software systems, it is more important to improve managers' information skills. MS Office is recognized as the best enterprise management tool at present, but not many people are really proficient in MS Office. The course of Huamao IBMP is to meet the call of the information age, cultivate management talents who are proficient in office applications, improve the efficiency of enterprise management by more than 10 times, and make the data of enterprise management standardized and accurate!

Two. Learning cycle

2-3 days (case setting can be changed according to different requirements of enterprises)

Three. lecturer

All the lecturers in our school are Office business application experts who have passed strict examination and certification by Microsoft and have many years of teaching experience.

Four. course features

1 Microsoft certified expert hands-on teaching;

Two cases come from practical work applications;

3. Pay attention to cultivate students' understanding of the essence of Office, so as to achieve the effect of drawing inferences from one instance;

4. Goal-driven, case-driven and task-driven teaching, so that students can master advanced skills in an easy-to-understand way;

5. Cultivate practical and expert intelligent management talents.

Verb (short for verb) course

(A) Excellent human resource management elite course

Enrollment targets: enterprise human resources managers, clerks, secretaries, office workers, etc.

Learning content:

1 data processing capability foundation;

2 employee information management: data validity, data extraction and comprehensive information generation by functional functions;

3 Analysis of enterprise talent structure: Pivot table function realizes multi-angle summary and composition analysis of enterprise employee status, and data perspective function realizes visual display and analysis of enterprise talent structure.

4. Labor relations and contract management: through the function function, labor relations processing and early warning reminder of expiration (probation period and contract expiration) in the process of labor contract management can be realized;

5. Intelligent calculation of personal income tax: combined with the national personal income tax law, the intelligent calculation of personal income tax is realized by using the fuzzy subsection query function of data.

6. Efficient summary of employee appraisal data: the reference summary between performance summary table and personal performance management table is realized by using the reference function of table lookup; Use the sorting function (menu, function) to realize the automatic sorting of performance quantitative results.

7. Training cost budget: realize the compilation and intelligent calculation of training cost budget table in the process of training management; By means of simulation and prediction, the change of budget funds caused by the change of number of people and duration can be realized.

8. Evaluation and analysis of recruitment effect: conduct statistical management on the candidates, interviews, probation and full-time employees in the recruitment process, and evaluate the recruitment channels, costs and work efficiency by using the multi-condition summary function;

Labor cost budget: according to the historical labor cost data analysis and recruitment plan, the labor cost budget for the new year is carried out.

(B) Excel Financial Management Advanced Application Course

Enrollment target: accounting, financial management or related personnel.

Learning content:

1Excel function basis;

2. The application of logical function and its nesting in financial management:

3 Financial application of data search and reference function: VLOOKUP function and HLOOKUP function are used for cases such as reconciliation, financial data summary, sales cost accounting and salary payment.

Advanced screening and macro-financial application: intelligent analysis of current account cases.

5 advanced data summary case: use Sumproduct function to realize personalized multi-condition financial data statistical analysis, such as sales statistics and cost statistics.

6. Pivot Table: Use pivot table for classification statistics, period statistics, percentage statistics, report consolidation, budget tracking, etc. In financial management.

Advanced chart analysis: analyze various costs, calculate break-even point, and make business forecast and trend analysis through charts.

8 simulation table: use simulation table to analyze financial budget, profit forecast, cost forecast, calculation of enterprise profit influencing factors, etc.

9 Regression analysis: predict the business data of the enterprise through unit and multiple regression techniques.

(3) Excellent financial management course

Enrollment targets: people who have studied advanced Excel application classes or have mastered Excel through tests, as well as middle and senior managers in enterprises.

Learning content:

1Excel to collect financial data: collect financial data through network, financial software, ERP, etc.

2 financial hypothesis analysis: realize financial results under different financial indicators through Excel scheme tools, thus providing data support for optimizing financial decision-making; Univariate solution can explore the volatility of some financial indicators;

3. Sensitivity analysis of financial data: use simulated operation table for analysis, such as cash flow and capital budget;

4. Financial evaluation: 7 kinds of financial indicators are selected by Wall scoring method, and the total score of the indicators is finally obtained to evaluate the financial situation of the enterprise; Comprehensive evaluation of profitability, solvency and growth ability of enterprises by comprehensive scoring method; Dupont's analysis takes "return on net assets" as the starting point, strings together several important financial indicators, explains the reasons and trends of financial indicators, and thus points out the direction for enterprise management;

5 investment decision analysis: capital budget-analysis of future cash flow statement, evaluation, selection and decision-making of investment schemes; Evaluation indicators of investment projects-average rate of return, payback period, net present value, internal rate of return, average annual cost, etc. Sensitivity analysis-through the change analysis of cash flow and discount rate, predict the risk of the project;

Advanced skills in making financial statements: intelligent data merging, making advanced charts and writing financial statement documents.

(D) Excel marketing and sales management courses

Enrollment target salesmen (business representatives, salesmen, salesmen, sales consultants and sales engineers), marketing assistants, tally clerks, marketing managers, sales managers (business managers), brand managers, marketing supervisors, pre-sales engineers and marketing directors.

Learning content:

1 data processing capability foundation;

2. Sales data summary: make comprehensive reorganization statistics on the data list through the pivot table, quickly summarize a large number of sales data and establish an interactive table of cross lists; Combine classified summary with function to realize different summary results of sales data, and support decision-making with more detailed data.

3. Sales analysis: By making charts, the sales gap can be analyzed more intuitively, and enterprises need to further analyze the reasons for the decline in sales; Through the analysis of all the sales data of the enterprise, compare and evaluate the gap between the actual sales and the plan, analyze the reasons, and make the future sales plan of the enterprise on this basis;

4. Market share analysis: use function to count the market share of each product; Use charts to intuitively reflect the percentage of product share; Analyze the market share in detail, propose solutions and adjust the sales plan;

5 sales forecast: using historical data trend forecast and regression analysis technology to realize sales forecast; Combine the influence of economic environment on the market and various situations within the enterprise to make sales forecast;

6 sales cost analysis and forecast: establish interactive cost analysis report by Excel; Use the formula to forecast and analyze the cost, prepare the production cost plan and adjust the production and operation strategy;

7 sensitive profit analysis and forecast: use charts to dynamically realize the influence of changes in sales price, unit variable cost, sales volume and fixed cost on profit increase and decrease; Use sensitivity analysis to help decision-making to achieve the established goals of the enterprise;

8 sales profit and loss analysis: use Excel formula operation and simulation operation table to realize intelligent calculation of cost, quantity and profit; Analyze the profit impact of different products, different quantities and different prices; Use charts to dynamically reflect the change of profit and loss more intuitively;

9 accounts receivable recovery: analyze accounts receivable aging analysis with Excel; Through summary and analysis, formulate scientific credit management processes and systems; Establish an incentive system for customers to pay quickly.

(E) Excel production and management elite course

Enrollment target: planner, material engineer, statistician, production dispatcher, PMC assistant, warehouse keeper, team leader, site manager (5S Commissioner), merchandiser, workshop director (production section chief or production manager), buyer, deputy manager, reserve cadre, department head (manager), etc.

Learning content:

1 data processing capability foundation;

2. Monthly statistics of team output: using the data summary function, the products of different customers and different models can be summarized monthly under multiple conditions; Calculation of piece-rate wages for teams and groups;

3 workshop statistics: fast and accurate entry of parts in and out of the warehouse; Use PivotTable to summarize monthly reports; Calculation of warehouse material value (weighted average);

4 production task arrangement: use functional function to quickly find out the corresponding product inventory in the inventory; Determine the workshop production task according to the order quantity to prevent inventory;

5. Production scheduling analysis: intelligent scheduling; Statistical summary of intelligent overtime information;

6MC material requirement plan: through advanced screening, it is merged into a product configuration summary table; According to the production task, product configuration summary, BOM and inventory information, make material demand plan quickly and accurately;

Seven key indicators of warehouse management: calculation of profit and loss rate of goods; Calculation of loss rate of goods; Labor productivity calculation; Calculation of variance ratio of inventory assets;

The application of regression analysis in production cost control: establish a database of historical output and corresponding unit product cost; Using regression analysis, when the output changes, predict the cost and control the cost well;

9 order cost gross profit analysis: order cost, gross profit and profit rate analysis; When key factors (such as sales price, etc. ) affect the change of order profit, make profit and loss forecast, and provide basis for quotation and purchase.

(6) Excellent foreign trade management elite course

The enrollment targets are foreign trade-related personnel.

Learning content:

1Excel function basis;

2. Intelligent management of supplier information;

3. Make purchasing quotation intelligently;

4. Foreign trade contract management;

5. Management of foreign trade documents;

6 foreign trade inventory management;

7. Foreign trade profit analysis and forecast.

(vii) Advanced Application Course in the Office of the Executive Secretary

Target audience: administrative clerks, secretaries and assistants of enterprises or departments.

Learning content:

1 enterprise internal journal arrangement and production: through enterprise internal journal arrangement and production cases, advanced text document processing skills are interspersed among them in a task-driven way, and they are explained in detail one by one, and finally common text document processing skills are mastered, such as rapid assembly of multiple documents; Text acquisition and processing of PDF files or picture files; Text segmentation setting and clever use; The catalogue is compiled automatically and efficiently;

2. Production of meeting materials and approval letters: Based on the application of Word in meeting management, starting with the batch production of invitations/invitations/work certificates of participants, it involves the modification, comparison and review of different versions of meeting materials and documents, as well as the skills of extracting pictures from long documents, the production of various administrative forms, the reference and splicing of data forms, etc.

3 Design and application of presentation master: Presentation is a very important file type in conference activities, and it is the key carrier for the speaker to effectively express and convey and the audience to understand the speaker's intention. An excellent presentation has many conditions, such as production principle, word processing, color matching, layout application, master and template design application.

4 Presentation chart animation design and application: Reference and splicing of data charts, animation design and projection skills in presentation are advanced application skills. If you can skillfully use these skills, it will be the icing on the cake of the presentation and add a lot of color to the conference activities.

5. Customer information management: the system establishes a customer information base, manages customer information by classification, and queries customer information simply and efficiently.

(eight) information technology to create a winning team course

This course solves the problem that many enterprise managers "only know the management concept, but don't know the management technology and can't implement the management strategy", so that the majority of managers can truly realize the dream of management innovation, high efficiency and intelligent management. Through the close combination of Microsoft series management platform and practical work, the course trains students to handle their own business intelligently, so that their business processing is efficient and accurate, and it can also provide timely and accurate data support for enterprise decision makers, and at the same time, it can carry out intelligent management at team level or enterprise level.

The enrollment targets are corporate executives, department managers, middle and senior managers or IT managers.

Learning content:

1Sharepoint Server system installation and configuration;

2 team document and knowledge management;

3 team work planning and work tracking;

4 team collaborative office management;

5. Team project management;

6 team workflow design;

7 Business data integration and intelligent report design

(9) Customize courses for enterprises.

According to the actual business needs of enterprises, develop courses suitable for the actual skills needs of enterprises. The process is as follows:

The first stage: in-depth understanding

This includes in-depth interviews, work observations and questionnaires. Let us have a complete and comprehensive understanding of your company, including the company's business needs, the nature of the enterprise, and the office application level of employees. This stage generally takes 1-2 days.

The second stage: scheme design

The academic team of Hua Mao Education will design a complete corporate office training course according to your company's needs. Generally speaking, this involves customizing specialized office teaching materials (textbooks, computerized materials). Generally speaking, it takes 1 week. In this process, we will continue to test and modify the materials to achieve your most satisfactory results.

The third stage: enterprise office advanced application training.

Professional trainers from Hua Mao Education provide advanced office application training for your employees at the site or in our school, with your needs as the center and a highly clear goal, which can effectively improve the students' office application level in real time and improve the management efficiency of the whole company.

Address: Room 620-62 1 Block A, Tianyi Haojing, Hualou Lane 19, Haishu District, Ningbo (diagonally opposite to Tianyi Square and Xinhua Bookstore)

Tel: (0574)87022946

Chuanzhen: (0574)87022948