Essential Skills Training: Excel Function Learning Trilogy, From Entry to Mastery
8:45 AM – 4:00 PM,
Thursday, July 09, 2015
– AmCham China Conference Center
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
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.
Venue:
No. 10 Jintongxi Road, The Office Park, Tower AB 6th Floor
金桐西路10号远洋光华国际AB座6层
Program:
8:45 – 9:00 – Registration
9:00 – 12:00 – Morning Session
12:00 – 1:00 – Lunch
1:00 – 4:00 – Afternoon Session
Registration:
Cardholding members advanced discounted online price: RMB 2,000
Non-cardholding employees of member companies: RMB 2,000
Non-members: RMB 2,500
Special Registration Information:
• You must register in advance. Walk-ins will not be accepted. • Limited spots are available and attendance is given on a first-come, first-served basis. • Attendees need to pay by July 1st
AmCham China Events:
Events have limited seating so to ensure your attendance we encourage advance online registration and payment for ALL events. We cannot guarantee entry to anyone not registered in advance. All AmCham China events are in English unless stated otherwise. Please also be aware that the Member Advanced Price is only for members who register AND pay online prior to the closing date and time for this event. Members who do not register and pay online will be charged the At-The-Door price.
This event is off-the-record.
For more information, please contact: Caroline Wang, Tel: (8610) 8519-0892, Email: [email protected].
Cancellation Policy:
If you cannot attend an event for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify AmCham China of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can 1) call 8519-0828 and leave a voicemail message including your name, and event title and date, 2) email [email protected], or 3) cancel online if you registered for the event through the website. Thank you for your cooperation and helping AmCham China maintain the quality of its events.
Receipts:
Please note: Requests for official payment receipts for 2013 (fapiao) must be submitted to AmCham China before December 25, 2013. Requests made after that time will not be accommodated. Please contact [email protected].