EasyFinance

中文

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®