EasyFinance

中文

HOME > Public Semina > Course Online

ESSENTIAL EXCEL TECHNIQUES FOR ELITES

Why do my Excel?sheets always have mistakes?
Why are my Excel?formulas complicated?
Why do my Excel?charts look boring?
We are doing similar, or even the same tasks, every month, is there any simpler method?
These are problems confusing many people. Excel?is not as easy as it appears; you need to master some skills if you want to use it intelligently. This course will help you master the usually neglected skills under the basic functions, this will radically improve you work efficiency, make your Excel?spreadsheets effective, safe and pretty, and make you an expert in Excel?in other people抯 eyes.

Training Objectives

Master the skills that make your Excel?spreadsheets more efficient and professional
How to solve complicated problems with formulas
How to make boss-satisfying charts
Make the boring, repetitious and time-consuming tasks automatic with macros
Learn to analyze data with pivot tables
Design Excel?forms using data validation

Training Attendees

Financial and non-financial personnel who need to ameliorate work with Excel?special_en=


	Training Outline

	The methods of making your Excel® different
	Efficient: The useful methods to improve work efficiency
	Safe: Full introduction on data safety and protection in Excel®
	Convenient: Reference, link and hyperlink
	Professional: Prepare a professional and normative Excel® report
	Commonly used functions introduction with practical examples
	How to define and use names in formulas
	Commonly used functions and examples in real financial work
	Salary and individual income tax calculation models
	How to simplify your formulas with arrays
	Database functions can solve complicated problems
	Boss-satisfying charts
	How to prepare charts by clicking one key
	Eight elements to make your charts more professional
	How to use the secondary axis in charts

	How to insert other objectives in charts
	How to make dynamic charts
	Six principles in making charts
	Macros: automate your work
	You can start to use macro(how to record a macro)
	Macros are not difficult (How to write your own macro)
	Not many skills needed (some common and practical VB language)
	Only one button (assign a macro to a button, picture and even your own photo)
	What kind of jobs can be applied with macros
	Financial application examples of macros
	Other useful tools and skills
	Pivot tables
	Conditional formatting
	Formula audits
	3-D formulas
	Data consolidation
	Advanced filters
	Data validation


City	Day	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Price
Beijing	2						13-14					14-15		4500
Shanghai	2			21-22			17-18			9-10			12-13	4500
Shenzhen	2										24-25			4500