A. Hiding sensitive data
B. Protecting report formulas and report structures
C. Various processing of decimal places: conversion to display accuracy, rounding, rounding, etc.
D quickly set the report data to thousands, tens of thousands, millions and other display units.
E. Quickly convert RMB into amount in words.
F. block the error information in the report.
2. Accounts receivable aging analysis
3. The production of fixed assets management template
A. Use of depreciation function
B. Fixed assets investment evaluation model
C. Statistical analysis of fixed assets
4. Make the process of reading the statement enjoyable.
A. Analysis of Excel financial template of multinational companies
B. use Excel template to reflect the company style.
C. Make obscure data easy to understand
D. Make your own beautiful template.
5. Design of financial budget and forecast template
A. template analysis of international general financial forecast
B. Correlation design of balance sheet, income statement and cash flow statement
C. Design to make reports automatically cross-check permanent balance
6. Knowing what a financial model is, what can you do for us? How to make financial model in Excel? What knowledge do you need to master? What financial models can provide a broader perspective? This application provides several financial models for analysis and discussion.
7. Establish the variable cost analysis and cost control model by yourself.
8. Multivariate sensitivity analysis
9. Key points of company value evaluation and model establishment
10. Make a dynamic dashboard of financial indicators, and visually display financial indicators in a graphical way.
A. Observe the design of several professional dashboards and understand the production ideas.
B. master the production methods of tools such as controls.
C. actually making a dashboard.
1 1. Cost classification and statistics: application of new statistical functions in 2007.
12. The CEO asked me about an investment project. I wonder if it's worth it from a financial point of view.
13. I want to borrow money, and I want to know if there is any contradiction between the repayment plan and the company's cash flow.
14. I want to know the overall situation of order sales.
15. Making financial charts of the world's top business magazines
A. elegance and analysis of financial charts of the world's top business magazines
B. You can also make first-class business charts to show financial data.
C define templates, quickly create beautiful charts, and form your own chart style.
16. Multidimensional dynamic analysis of sales data
A. Year-on-year analysis
B. Ring comparison analysis
C. Calculation of compound growth rate
D. Rationality analysis of sales expense growth rate
E. Comparative analysis of budget and reality
17. Is it possible for lightning to summarize 100 reports?
18. Solve the calculation problem of various dates
A. calculating aging and various due dates and cut-off dates
B. calculate the day of the week on a specific date.
C. Calculate the number of weeks on a specific date
D. calculate the number of months before and after a specific date.
E. calculation of net working days
F. extract the year and month information to which the date belongs.
G. extracting the birthday information from the identity card.
19. Use dynamic charts for business comparison and analysis
Learn the idea and method of making dynamic charts, and copy this method to other aspects that need to be analyzed.
20. output elasticity cost ratio structure analysis table
Change the cycle at will, compare projects with different costs at will, generate charts in real time, and display the analysis results intuitively.
2 1. The boss put the finance department in charge of salary calculation. Fortunately, he has a complete set of HR salary calculation templates, including automatic calculation of overtime pay (automatic judgment of overtime work on weekends and holidays), automatic calculation of absenteeism salary, calculation of bonus according to KPI and calculation of income tax.
22. Learn several forecasting methods with Excel and evaluate them.
23. Create a query template and freely query the information you set.
24. Cost benefit analysis
A. Decomposition of mixed costs
B. Calculate the critical point of profit and loss
C. Calculation of measures to achieve profit targets
25. Adjustment of financial statements: make adjustment entries and make working papers of international accounting firms.
26. The internal structure type of Excel form and how to choose it correctly?
A. the internal structure of the table that is not easy to attract attention
B eliminate the mechanism of repetitive work from the design of data sources and improve work efficiency.
C. Make tables with systematic thinking