This is a past event. Registration is closed. View other AmCham China events.
This event has been cancelled. If you have previously registered for this event, an AmCham China staff member will contact you with more information.
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 attractive; and make you an expert in Excel.
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
Program Outline
1.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
2.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
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 attractive; and make you an expert in Excel.
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
Program Outline
1.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
2.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
3.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
4.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
Who should attend?
Financial and non-financial personnel who need to ameliorate work with Excel
Trainer – Adam Liu
Adam Liu has been awarded Microsoft's MVP (Most Valuable Professional) annual award every year since 2008. He has over six years' experience with computer training. He received his Bachelor degree from the University Of Science and Technology.
"Excel Application in Financial Management" is a one-day course from 9:00 AM - 4:00 PM that will be held in the AmCham China Conference Center. Coffee, lunch and light refreshments will be provided during breaks.
This course will be conducted in Chinese.
Please bring your own laptop that has at least Office 2007 English version installed.
•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
4.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
Who should attend?
Financial and non-financial personnel who need to ameliorate work with Excel
Trainer – Adam Liu
Adam Liu has been awarded Microsoft's MVP (Most Valuable Professional) annual award every year since 2008. He has over six years' experience with computer training. He received his Bachelor degree from the University Of Science and Technology.
"Excel Application in Financial Management" is a one-day course from 9:00 AM - 4:00 PM that will be held in the AmCham China Conference Center. Coffee, lunch and light refreshments will be provided during breaks.
This course will be conducted in Chinese.
Please bring your own laptop that has at least Office 2007 English version installed.
