Training Objective:

 

　　Beginning a new job that needs advanced Excel skills? This is an activity-based workshop to cover advanced Excel features and commands to jump start productivity for existing Excel users.

 

　　Advanced Topics Covered:

 

　　This program prepares you to take up business analysts roles.

 

　　* Advanced Cell Formatting.

 

　　* Must Know Functions:

 

　　– Date and Time Functions,

 

　　– Logical Functions,

 

　　– Lookup Functions,

 

　　– Statistical Functions & more.

 

　　* Advanced Formulas & Techniques.

 

　　* More on Excel Charts.

 

　　* Go-seek, Scenario & Solver.

 

　　* Introduction to Excel Macros.

 

　　Who Should Attend?

 

　　For experienced Excel users who need to get their Excel skills up to speed for reporting and analysis.