Traditional Culture Encyclopedia - Traditional stories - Ningbo EXCEL training which training organization is the best
Ningbo EXCEL training which training organization is the best
I. Course Value
In the era of informationization, the informationization of enterprises is not only to build professional informationization software systems, but also to improve the informationization skills of managers. MS Office is currently recognized as the most excellent enterprise management tool, but not many people are really proficient in MS Office. The IBMP course is to respond to the call of the informationization era and train the management talents who are proficient in the application of MS Office, so that the efficiency of the enterprise management can be improved by more than 10 times and the data of the enterprise management can be standardized and accurate!
II. Learning Cycle
2 to 3 days (according to the different requirements of the enterprise, the case set changes)
Three. Lecturers
All the lecturers in our school are Office business application specialists who have passed Microsoft's strict examination and certification, and have many years of teaching experience.
IV. Course Features
1 Microsoft certified experts hand in hand teaching;
2 cases from the actual work of the application;
3 focus on cultivating students to understand the essence of Office, to achieve the effect of one to three;
4 goal-driven, case-driven, task-driven teaching, easy to understand the students to master advanced skills;
5 Cultivate practical and expert intelligent management talents.
V. Curriculum
(a) Excel Human Resource Management Elite Course
Enrollment object : enterprise human resource management personnel, clerks, secretaries, office personnel, etc..
Learning content:
1 basic data processing skills;
2 employee information management: data validity, function functions to achieve data extraction and comprehensive information generation;
3 enterprise talent structure analysis: pivot table function to achieve the enterprise employee status of the multi-dimensional summary and analysis of the composition of the pivot table function to achieve the enterprise talent structure visualization display and analysis.
4Labor Relationship and Contract Management: The function function realizes the labor relationship processing and the expiration (trial and contract expiration) warning reminder in the process of labor contract management;
5Individual Income Tax Intelligent Calculation: Combining with the National Individual Income Tax Law, it realizes the intelligent calculation of the individual income tax by using the function of fuzzy segment querying of the data.
6Efficient Summary of Employee Appraisal Data: Utilize the table lookup reference function to realize the reference and summary between the performance summary table and the individual performance management table; utilize the sorting (menu, function) function to realize the automatic ranking of the quantitative performance results.
7 Training Cost Budgeting: Realize the preparation and intelligent calculation of training cost budget table in the process of training management; use simulation and prediction means to realize the change of budget expenses caused by the change of the number of people and the period.
8 Recruitment Effect Evaluation and Analysis: Statistical management of the recruitment process of applicants, interviews, probationary and regularization of personnel, the use of multi-criteria summary function to achieve the evaluation of the recruitment channels, costs, efficiency;
9 Labor Cost Budget: Based on the analysis of the historical labor cost data and the recruitment plan to carry out the new year's budget for the cost of manpower.
(B) Excel Advanced Applications for Financial Management course
Enrollment object: accounting, financial management or related personnel
Learning content:
1 Excel function basics;
2 logical function and its nested in the application of financial management;
3 data to find the financial application of the function and reference: VLOOKUP function, HLOOKUP function for reconciliation, financial data summary, cost of goods sold accounting, payroll and other cases.
4 advanced screening and macro financial applications: intelligent analysis of current account cases.
5 advanced data summary cases: the use of Sumproduct function to achieve personalized multi-conditional statistical analysis of financial data, such as sales statistics, cost statistics.
6 pivot table: pivot table in financial management through the classification of statistics, time statistics, percentage statistics, as well as report consolidation, budget tracking and so on.
7 Advanced Chart Analysis: Analyze various types of costs through charts and graphs, account for break-even points, make business forecasts, trend analysis, and so on.
8 simulation operation table: the use of simulation operation table to carry out the analysis of financial budgets, profit forecasts, cost forecasts, corporate profitability factors, etc.;
9 regression analysis: through the unit and multiple regression techniques to carry out a variety of business data forecasting.
(C) Excel Financial Management Elite Course
Enrollment Objects: Learning Excel advanced application class or by the test has been proficient in Excel, as well as senior management
Learning Content :
1Excel collection of financial data: through the network, financial software, ERP, etc. to collect financial data;
2Financial data: through the network, financial software, ERP, etc. to collect financial data. /p>
2 financial hypothetical analysis: Excel program tools to achieve different financial indicators under the financial results, so as to optimize financial decision-making to provide data support; univariate solution can explore some of the volatility of financial indicators;
3 financial data sensitivity analysis: the use of simulation spreadsheets to carry out such as cash flow, capital budgeting and other analysis;
4 Financial Evaluation: Using the Wall Score method to select seven financial indicators, and finally find the total score of the indicators, so as to assess the strengths and weaknesses of the enterprise's financial position; using the comprehensive score method to comprehensively assess the enterprise's profitability, solvency, and growth ability; DuPont analysis using the "return on net assets" as a starting point to link a number of important financial indicators, which is used to explain the reasons for the changes in financial indicators. It is used to explain the reasons for changes in financial indicators and the trend of changes, so as to point out the direction for the enterprise's operation;
5 Investment Decision Analysis: Capital Budgeting - analyzing the future cash flow statement to evaluate the investment program, selection and decision-making; Evaluation of Investment Project Indicators - average rate of return, payback period, NPV, internal rate of return, average annual cost, etc.; Sensitivity Analysis - through the cash flow, discount rate change, and the impact of the discount rate. Cash flow, discount rate change analysis to predict the risk of the project;
6 production of financial statements advanced skills: intelligent consolidation of data, creating advanced charts and graphs, financial reporting document preparation skills.
(D) Excel Marketing and Sales Management Course
Enrollment Objects Salesman (commercial representative, marketer, salesman, sales consultant, sales engineer), marketing assistant, stocker, market manager, sales manager (business manager), brand manager, market supervisor, pre-sales engineers, marketing director and so on.
Learning content:
1 Foundation of data processing capabilities;
2 sales data summary: through the pivot table, a full range of data list to reorganize and statistics, a large number of sales data to quickly summarize and establish cross-listed interactive tables; combined with the classification of the summary, the function of the sales data to achieve different summary results to achieve a more detailed data to use to support decision-making.
3 sales analysis: the use of charts and graphs, a more intuitive analysis of the sales gap, the enterprise needs to further analyze the reasons for the decline in sales; through the analysis of all the sales data of the enterprise, comparison and assessment of the actual sales and the gap between the plan to analyze the reasons, and as a basis for the development of the enterprise's future sales plans;
4 market share analysis: the use of functions to calculate the market share of various products; the use of functions to achieve different summary results of sales data to support decision-making with more detailed data. The market share of the product; the use of charts and graphs, a visual representation of the percentage of the product share; the market share of the detailed analysis, put forward solutions to adjust the sales plan;
5 sales forecasts: the use of historical data trend forecasting and regression analysis techniques to achieve sales forecasts; combined with the economic environment on the market and the impact of the various conditions within the enterprise to make sales forecasts;
6 cost of sales analysis and forecasting: the use of Excel to establish an interactive cost analysis report; the use of formulas for cost forecasting and analysis, the preparation of production cost plan, adjust the production, business strategy;
7 sensitive profit analysis and forecasting: the use of charts and graphs to dynamically realize the selling price, unit change costs, sales, fixed costs of the changes in the impact on the profit increases or decreases; the use of sensitivity analysis To help decision-making to achieve the established goals of the enterprise;
8 sales profit and loss analysis: the use of Excel's formula operations, simulation of the arithmetic table, the realization of the principal, the amount of intelligent calculation of profit; analysis of different products, different quantities, the impact of different prices of profits; the use of charts and graphs dynamically produced, a more intuitive response to the changes in profit and loss;
9 Accounts receivable recovery: using Excel analysis Accounts receivable aging analysis; through summary analysis to develop a scientific credit limit management process and system; establish a fast payback incentive system for customers.
(E) Excel production operations management elite course
Enrollment object: enterprise production department planner, material controller, statistician, production scheduling, PMC assistant, warehouseman, team leader, site management (5S commissioner), order followers, shop floor director (production section chief or production bear), purchaser, assistant manager, reserve cadres, the director of the department (manager) and so on.
Learning content :
1 Basic data processing ability;
2 Shift production monthly statistics: the use of data summarization function, the different customers, models of products for the multi-conditional monthly summary; shift piecework wage calculation;
3 Workshop statistics: fast and accurate entry and exit of parts and components; the use of pivot tables for the summary of the monthly report; the value of the warehouse materials ( weighted average) calculation;
4 production task scheduling: the use of function functions, in the inventory to quickly find out the corresponding product inventory; according to the number of orders to determine the workshop production tasks, to prevent the production of inventory;
5 production scheduling analysis: scheduling plan intelligent preparation; intelligent overtime information statistics summary;
6 MC material requirements plan development: through advanced filtering, convergence of Product Configuration Summary Table; fast and accurate preparation of Material Requirement Plan based on production tasks, Product Configuration Summary Table, BOM and inventory information;
7Key Indicators of Warehouse Management: Calculation of Item Profit and Loss Rate; Calculation of Goods Loss Rate; Calculation of Labor Productivity; Calculation of Discrepancy Rate of Inventory Assets;
8Application of Regression Analysis in Production Cost Control: Establishment of Database of Historical Output and Corresponding Unit The establishment of product cost database; the use of regression analysis, production changes, predict the cost of good cost control;
9 order cost gross profit analysis: order cost, gross profit and profit margin analysis; when the key factors affecting the profit of the order (such as sales price, etc.) changes, profit and loss prediction for the offer, purchase to provide a basis.
(F) Excel elite foreign trade management courses
Enrollment object and foreign trade-related personnel
Learning content:
1 Excel function basis;
2 supplier information intelligent management;
3 intelligent production of procurement quotations;
4 foreign trade contract management;
5 foreign trade document management;
The management of foreign trade contract management. p>5 Foreign trade document management;
6 Foreign trade inventory management;
7 Foreign trade profit analysis and forecast.
(VII) Administrative Clerical Office Advanced Application Course
Student target: corporate or departmental administrative clerks, secretaries, assistants, etc..
Learning content:
1 enterprise internal publication arrangement and production: through the enterprise internal publication arrangement and production cases, task-driven approach, advanced text document processing skills interspersed with, one by one detailed explanation, and ultimately master commonly used text document processing skills: such as rapid compilation of multi-document; PDF documents or image files on the text acquisition and processing; text subsection set up and the use of wonderful; Directory efficiently and automatically compiled;
2 meeting information and batch letter production: the application of Word in the management of the meeting as a clue, from the participants of the invitation / invitations / work documents batch production to start with, involving the meeting information with different versions of different versions of the document revision of the status of the comparative review, as well as a long document in the picture extraction techniques, a variety of administrative form production and data form references and inlay processing and other content!
3 Presentation Master Design Application: Presentation is a very important type of documents in the conference activities, is the speaker to effectively express the transmission and the audience to receive and understand the speaker's intention to key carriers. An excellent presentation with a number of conditions, such as production principles, text processing, color schemes, layout applications, master and template design applications;
4 presentation charts and animation design applications: presentation of data charts and graphs references and inlays and animation design, screening skills is the advanced application of presentation skills, if you can skillfully use these skills will be the icing on the cake, but also to make the effect of the conference activities a lot more colorful. can make the conference activities add a lot of color.
5 Customer Information Management: The system establishes a customer information database, manages customer information by category, and makes it easy and efficient to query customer information.
(H) Information technology to build a winning team course
The course solves the problem of many enterprise managers "only know the management concept, do not know the management technology, will not implement management strategies" and other problems, so that the majority of managers can really realize the management of innovation, management efficiency, management of intelligent dream. The course through the Microsoft series of management platform and the close integration of the actual work, to train students to intelligently deal with their own business, so that their business processing efficient and accurate, but also for the decision-making level of the enterprise to provide timely and accurate data support, at the same time, can be very good for the team level or the enterprise level of intelligent management.
Enrollment Objectives Corporate supervisors, department managers, middle and senior managers, or IT managers.
Learning content :
1Sharepoint Server system installation and configuration;
2Team document and knowledge management;
3Team work plan and work tracking;
4Team collaborative office management;
5Team project management;
6Team workflow design
7 Business Data Integration and Intelligent Report Design
(IX) Enterprise Customized Courses
We can develop courses that are suitable for the actual skill needs of enterprises according to their actual business needs. The process is as follows:
Stage 1: In-depth understanding
This includes in-depth interviews, job observation, and questionnaires. Let us have a complete and comprehensive understanding of your company, including the company's business needs, the nature of the business and the level of Office applications of employees. This stage usually takes 1-2 days.
Stage 2: Program Design
Huamao Education's academic team will design a complete corporate Office training program according to your company's needs. Typically this involves customizing special Office teaching materials (textbook materials, computerized materials). Typically this takes place over 1 week. During this process, we will continue to pilot and make changes to the materials to achieve the results you are most satisfied with.
Stage 3: Enterprise Office Advanced Application Training.
Huamao Education's professional trainers come to the field or in our school for your enterprise staff to carry out enterprise Office advanced application training, focusing on your needs, the program goal is highly clear, real-time and effective way to improve the level of students' Office applications, and improve the management efficiency of the whole company.
Address:
Ningbo City, Haishu District, No. 19 Hualou Lane, Tianyihaojing A Block, Room 620-621 (Tianyi Plaza, Xinhua Bookstore diagonally across)
Contact Tel: (0574)87022946
Fax: (0574)87022948
- Related articles
- Classical Chinese Translation of Lu's Birthday
- Why has national style become a trend in recent years?
- Can cooked food be packed in vacuum compression bags?
- Is the KTV industry in decline? Will it die out?
- Sources of the following Italian sign language
- China traditional villa decoration fee
- Handwritten report content of local students' exams
- Painting technology of solid wood furniture Matters needing attention in painting solid wood furniture
- Is the advertising media industry good now?
- Ancient celebrities in China tell moral stories.