AmCham Center for Training and Development
This 2 day intermediate MS Excel training course is designed for employees to get deeper understanding of excel, learn advance functions and make their work flow more efficient.
By the end of the program, attendees will be able to maximize MS Excel to generate business reports, data consolidation, use V Lookup, and manipulate pivot table and more.
The program is delivered by hands-on professional facilitators who have decades of experience in using and teaching the program.
WHO SHOULD ATTEND?
Sales, Marketing, Operations, HR, Admin and anyone who has a desire to maximize the built-in functionalities of MS Excel and who wish to create productive but workbooks capable of presenting their required output.
TOPICS COVERED
- Logical function
- Conditional functions
- Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
- Text functions
- Date and me function
- Error functions (ISNA, ISERROR)
- Using lookup functions
- Creating and using names
- Managing names
- Validating cell entries
- Conditional formatting
- Outlining and consolidating data