Data Analysis and Visualization with Excel

LEARNING OUTCOME

Upon completion of the course, participants will be able to:

• Organize and manage structured data effectively using tables, logical functions, and lookup functions to streamline data processing and ensure accuracy.
• Analyze and summarize data with advanced mathematical functions and PivotTables, enabling efficient handling of large datasets with sorting, filtering, and grouping.
• Create insightful visualizations using charts, sparklines, conditional formatting, and slicers to enhance data interpretation and support decision-making.

TRAINING METHODOLOGY

Remote Learning, Interactive lectures. hands-on exercises, case studies, group discussions

WHO SHOULD ATTEND?

Experienced Microsoft Excel users (from Manager, Executive to Junior Executive) who are looking to efficiently analyse large data sets and create dynamic dashboard reports

PRE-REQUISITE

• Basic understanding of data entry and analysis
• Laptop/desktop with Microsoft Excel installed and internet access

OUTLINES

1. TABLES FOR STRUCTURED DATA MANAGEMENT
2. LOGICAL FUNCTIONS
3. MATHEMATICAL FUNCTIONS
4. LOOKUP FUNCTIONS
5. DATA VISUALISATION
6. PIVOT TABLES, PIVOT CHARTS AND SLICERS

CERTIFICATE OF PARTICIPATION