This is a past event. Registration is closed. View other AmCham China events.
This course will be delivered in Chinese. Attendees should prepare a laptop with at least Office 2007, English version.
Excel is something many either love or hate! For those who love it, Excel is a time-saver and a problem solver that can builds self-updating data reports. For those that hate Excel, it is a pain to deal with and a waste of precious time. This course is focused on three kinds of functions: logical, calculating and lookup. The trainer will lead you from basic knowledge to mastery of these functions. If you need a systematic study of functions or need to improve your data reporting with Excel, this is the course for you.
Who Should Attend
For those who need to use functions in data analysis and who want to understand Excel functions deeply. (Senior-level course)
Training Objectives
1. Master the IF, SUMIF, VLOOKUP function
2. Learn other kinds of functions and learn to solve problems with them
3. Improve problem solving and productivity
Excel is something many either love or hate! For those who love it, Excel is a time-saver and a problem solver that can builds self-updating data reports. For those that hate Excel, it is a pain to deal with and a waste of precious time. This course is focused on three kinds of functions: logical, calculating and lookup. The trainer will lead you from basic knowledge to mastery of these functions. If you need a systematic study of functions or need to improve your data reporting with Excel, this is the course for you.
Who Should Attend
For those who need to use functions in data analysis and who want to understand Excel functions deeply. (Senior-level course)
Training Objectives
1. Master the IF, SUMIF, VLOOKUP function
2. Learn other kinds of functions and learn to solve problems with them
3. Improve problem solving and productivity
Outline
1 Function introduction
1.1 The 4 essential factors of functions
1.2 Introduce the functions’ parameters
1.3 Write function practices
1.4 Extended study - statistical functions
2 Function’s common usage
2.1 How to use IF function
2.2 How to use SUMIF function
2.3 How to use VLOOKUP function
2.4 Extended study - text functions
3 Function’s advanced usage
3.1 Embedding in IF function
3.2 7 kinds of special usage of SUMIF
3.3 The special usage of VLOOKUP and troubleshooting
3.4 Extended study - value functions
4 Functions' advanced usage
4.1 Master the IF function
4.2 Mixed reference in SUMIF and the way to improve productivity
4.3 Auto summary by VLOOKUP
4.4 Extended study - date and time functions
5 Using functions better in your work
5.1 The ideas of solving problems with functions
5.2 Introduction of other functions
5.3 Usage tips for functions
5.4 Extended study - function troubleshooting
Meet the Trainer
Xue Zheng, a Microsoft Certified Professional, is the Office Special Trainer for MBA of Tsinghua University. He has been given Microsoft MVP (Most Valuable Professional) annual awards since 2010.
Coffee, lunch and light refreshments will be provided during breaks.
1 Function introduction
1.1 The 4 essential factors of functions
1.2 Introduce the functions’ parameters
1.3 Write function practices
1.4 Extended study - statistical functions
2 Function’s common usage
2.1 How to use IF function
2.2 How to use SUMIF function
2.3 How to use VLOOKUP function
2.4 Extended study - text functions
3 Function’s advanced usage
3.1 Embedding in IF function
3.2 7 kinds of special usage of SUMIF
3.3 The special usage of VLOOKUP and troubleshooting
3.4 Extended study - value functions
4 Functions' advanced usage
4.1 Master the IF function
4.2 Mixed reference in SUMIF and the way to improve productivity
4.3 Auto summary by VLOOKUP
4.4 Extended study - date and time functions
5 Using functions better in your work
5.1 The ideas of solving problems with functions
5.2 Introduction of other functions
5.3 Usage tips for functions
5.4 Extended study - function troubleshooting
Meet the Trainer
Xue Zheng, a Microsoft Certified Professional, is the Office Special Trainer for MBA of Tsinghua University. He has been given Microsoft MVP (Most Valuable Professional) annual awards since 2010.
Coffee, lunch and light refreshments will be provided during breaks.
