Learn beyond the normal bars and graphs so that your reports will be easier to understand. Microsoft Excel is one of the most powerful and useful business programs. It is used by millions of businesses globally primarily because it is effective and can be used by every industry there is.

In two days, the participants will be able to appreciate the Excel environment and its tools; execute advanced functions of Excel; create business systems such as time management; sales tracking and analysis, and more. In addition, participants will be able to learn pivot tables.

Module 1 (July 13, 2022 @ 9:00 am to 12:00 nn)

• Formulas (Operators, Referencing Types, Defining Names
• Introduction to Functions
• Deep Dive on Functions
• Array Formulas

Module 2 (July 13, 2022 @ 1:00 pm to 4:00 pm)

• 3D Referencing
• Nesting Functions
• Nesting Functions Part 2

Module 3 (July 14, 2022 @ 9:00 am to 12:00 nn)

• Nesting Function Part 3
• Data Tables
• Intro to Slicers and Sparklines

Module 4 (July 14, 2022 @ 1:00 pm to 4:00 pm)

• Intro to Pivot Table
• Pivot Table & Useful properties for creating reports
• Creating Simple Dashboards (Optimizing Pivot Tables)