HOME > Public Semina > Course Online

 
EXCEL APPLICATION IN FINANCIAL MANAGEMENT-ADVANCED

Maybe you are an Excel?expert and may be familiar with each tool and function, but often feel difficulties in fulfilling the complex demands of actual work by integrated application of these tools and functions?
Corporations have different kinds of data, and for financial personnel Excel?may be one of the most familiar tools. How to handle and analyze data from ERP, Access and even text format using Excel?
You may need to report or explain your work to your boss and colleagues with PowerPoint?and insert Excel?tables or charts into the PPT slide, so how to keep Excel畳s original characteristics and spend less time?
You will find answers for the above problems in this course!


Training Objectives

Learn the customize functions of Excel? discover the potential of Excel? achieve operation targets and personalized management
Learn to solve complicated financial management problems with Excel?formulas and functions
Learn to transact and analyze data from different sources and of different types with Excel?
Masterly combine Excel畳s data processing functions with PowerPoint畳s presentation functions, improve customer satisfaction

 

Training Attendees

CFO, financial manager, financial analyst, financial statements drafter and people who use Excel?to transact, analyze and represent financial data
 
 
       
Training Outline
 


Intelligently managing custom functions in Excel
 
  • How to quickly or automatically input commonly used data
  •  
  • Professional display of financial figures
  •  
  • Customization in conditional formatting
  •  
  • Customization in advanced filters
  •  
  • Formulas used in criteria when using database functions


  • Integrated application of formulas and functions
     
  • Print salary slips using Excel functions
  •  
  • AR ageing analysis
  •  
  • Automatic forecast of due AP
  •  
  • Calculation on inventory age, ABC classification and inventory provision
  •  
  • Automatic forming of cash flow statements
  •  
  • Analysis of sales forecasting accuracy
  •  
  • Calculation on additional cost and depreciation of fixed assets
  •  
  • Integrated application of text functions


  • Processing external data
     
  • How to open non-Excel external data files
  •  
  • How to use the "Query Wizard" to selectively load non-Excel® external data
  •  
  • How to use "Microsoft Query"to filter, connect and calculate external data


  • What-if analysis
     
  • Manual test
  •  
  • Single variable what-if analysis
  •  
  • Double variable what-if analysis
  •  
  • Using "Scenario Manager" to compare a project's advantages and disadvantages under different assumptions, such as evaluation of investment project, sales project and cost project
  •  
  • Sensitivity analysis of price and quantity for an investment project or budget


  • Data sharing between Excel and PowerPoint
     
  • Insert an Excel table or chart in PowerPoint
  •  
  • Copy an Excel table or chart as an image to PowerPoint
  •  
  • How to achieve automatic data updating in PowerPoint by linking from Excel®
  •  
                         
    City
    Day
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Dec
    Price
     
    Call For Registration:
    +86 21 58362000 810


     
     
    RECENT TRAINING


     
     
      EASYFINANCE MANAGEMENT CONSULTING CO.,LTD
    Tel:+86 21-58362000 / 15801919100  Fax +86 21-58361896  
    E-MAIL :BD@EasyFinance.com.cn
    CopyRight ® EASYFINANCE
     
    瀹㈡埛鏈嶅姟
    live chat