AmCham Center for Training and Development
This two-day intermediate Microsoft 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 training will be facilitated by hands-on professional facilitators who have decades of experience in using and teaching the program.
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
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.
