Intermediate Microsoft Excel

Today's managers and employees think structurly about their company's business trend and future conditions. Awareness of the analysis of product, the needs of the audience and the goals to be achieved are fundamental to knowing when to deliver a strategic message to attract the attention.

During the intensive mentoring, participants will learn about the various basic until advance features of each application, includes user interface, basic functions, Formula, Visualization, formatting, management data, and many more.

After completion of this program, participants will be better able to:

• Absolute Row : lock reference by Row
• Absolute Column : lock reference by Column
• IF simple from one of 2 Result & Nested IF
• IF Function with more than 2 condition logic criteria
• Lookup Reference Standar : Vlookup, Hlookup
• Lookup Reference Advance : Xlookup
• Mathematical with Criteria : Countif(s) & Sumif(s)
• Summary & Recapitulation with PivotTable