Course objective is to understand the basic functions knowledge, to use them and to better understand the purpose of using Excel functions,The excel functions are as much hated than needed. Either you like Excel Functions or not, knowing them could help you solve a lot of difficult problems and build immediate updated data reports. Our course will be based on 3 kinds of functions:logical, calculating and lookup. We will lead you to understand the basic functions knowledge, to use them and to better understand the purpose of using Excel functions.
1/ Function getting start • The 4 essential factor of function • Introduce the functions' parameters • Write function practices • Extended study-statistical functions
2/ Function's common usage • How to use IF function • How to use SUMIF function • How to use VLOOKUP function • Extended study-next functions
3/ Function's advantage usage • Embedding in IF function • Kinds of special usage of SUMIF • The special usage of VLOOKUP and trouble shooting • Extended study-value functions
4/ Function's master usage • Master the IF function • Mixed reference in SUMIF and the way to improve productivity • Auto summary by VLOOKUP • Extended study-date & time functions
5/ Using functions better in your work • The ideas of solving problem by functions • Other functions introduction • Functions using tips • Extended study-function trouble shooting
Terms & Conditions:
- Each registration and membership status needs to be confirmed by the European Chamber
- A written confirmation with the bank details will be sent to the participant
- All payments need to be done in advance. A scanned version of the bank slip needs to be sent to the European Chamber.
Cancellation Policy
- Cancellation requests must be confirmed by mail. Please see the conditions below:
- Cancellations made 7 working days prior to the course will be charged with 20% course fee.
- Cancellations made 5 working days prior to the course will be charged with 50% course fee.
- Cancellations made 3 working days prior to the course or absence from the course will be charged with 100% course fee.
To cancel you can: 1) email yangzhao@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website