Current location - Education and Training Encyclopedia - Education and training - Excel VBA financial practice case
Excel VBA financial practice case
Hello, Nanjing pilots can provide Excel internal training services, as follows:

Professor Han, an expert tutor of Excel, has a deep understanding of Excel and its application in enterprise management, and is proficient in Excel and advanced application training in management, especially Excel and its application in enterprise finance, accounting, sales, human resources and financial management. More than 20 books on Excel applications have been published.

Teacher Han has worked in the former Office of the State Economic and Trade Commission, sinosteel, Baosteel Group and University of Science and Technology Beijing, and has rich management experience. He presided over the completion of the localization information management system of large-scale equipment of the Economic and Trade Commission, the ERP system of a large enterprise, the human resource management system of a company and the financial management system of an enterprise.

Teacher Han has trained hundreds of companies in Excel management and open classes. Including: China Bank Headquarters, Google (China) Headquarters, Baidu Headquarters, Baosteel, Sony Ericsson, Sinosteel, China Storage, Shougang, Beijing Guohua Energy Investment, Zhejiang Zhongyan (Dahongying), Angang, Suzhou Huaxing Certified Public Accountants, Taizhong, Baotou Steel, Shigang, Saint-Gobain, Jiangsu Borun, Medicine, Zhonglian Tally, Kang. Emgrand Industries, Denso, Haosen Pharmaceutical, Halliburton, Thorne Lighting, Sefar of Sweden, Citizen, Jinniu Energy, Nippon Mining, Nippon Mining, China Rescue Information Center, Beinong Biochemical, Zhou Su Capsule, Yi Sheng Science and Technology, Nuodu Medical, Shanghai Hester Forklift, Gief, etc.

The main courses taught by Mr. Han are: advanced application of Excel finance and management, the art of using Excel formulas and functions, advanced application practice of Excel management: pivot table and interactive dynamic chart, efficient financial management based on Excel: methods, skills and practical models, quick entry and practical exercises of Excel, integrated application of Excel and database, advanced financial modeling of Excel and Excel, and Excel and Excel.

Among them, Advanced Application of Excel Finance and Management, Art of Using Excel Formulas and Functions, Advanced Application Practice of Excel Management: Pivot Tables and Interactive Dynamic Charts, Efficient Financial Management Based on Excel: Methods, Skills and Practical Models, Quick Start and Practical Exercise of Excel VBA, Advanced Financial Modeling of Excel and Excel VBA, Best Practice of Excel 2007 Management Application, Advanced Data Processing of Excel 2007.

Han's main works

1.Excel Accounting Application Example, Electronic Industry Press.

2.Excel VBA+Access financial system development from foundation to practice, Electronic Industry Press.

3. The application of 3.Excel in investment and financial management, Electronic Industry Press.

4.Excel VBA salary management application case details, China Railway Publishing House.

5. The application of 5.Excel in financial management and analysis, China Water Resources and Hydropower Press.

6. Create an efficient financial management model VBA with Excel, China Railway Publishing House.

7.Excel VBA administrative human resource management application case details, China Railway Publishing House.

8. Detailed explanation of 8.Excel VBA financial management application case, China Railway Publishing House.

9. Making Effective Investment Decisions with Excel VBA, China Railway Publishing House.

10.Excel VBA from entry to mastery, China Railway Publishing House.

1 1.Excel VBA Practical Skills, China Railway Publishing House.

12. Application Example of EXExcel VBA and Database Integration, Science Press.

13. introduction and practice of a new generation of Excel VBA sales management system development, science press.

14.Excel VBA integrated database application from foundation to practice, Electronic Industry Press.

15. the application of excel in sales and financial management, electronic industry press.

16.Excel VBA application development (skill essence edition), Electronic Industry Press.

17.Excel enterprise management application case, Electronic Industry Press.

18.Excel VBA+SQL Server Database Management Technology, Machinery Industry Press.

19. the application of excel in tax management and tax planning, science press.

20. "Speaking with a Chart: Excel's Practical and Exquisite Chart Making", Electronic Industry Press.

2 1.Excel PivotTable from entry to mastery, China Railway Publishing House.

22.《Excel Efficient Office: Methods, Skills and Practical Models, China Railway Publishing House.

23 23 23.《Excel 2003/2007 The Art of Using Functions and Formulas, China Railway Publishing House.

24. "Excel VBA Efficient Office Practical Collection", China Railway Press.

Training income:

◆ Pay attention to the practical application of Excel in financial management, and the training content is closely combined with actual cases.

◆ Give consideration to the introduction of Excel skills and the inspiration of application ideas, and pay attention to the combination of point and surface.

Pay attention to hands-on practice, so that every student has sufficient hands-on opportunities to solve problems in learning in time.

Careful lectures, active and patient counseling experiments, so that every student can master the content.

◆ Perfect after-school service can contact teachers at any time and help enterprise students solve practical problems and difficulties in time.

Tel: 025-84687239 Teacher Zhang

In addition, there are group-buying products on the stationmaster group, which are cheap and guaranteed.