Get Registered before 5th June, 2025

Register Now

Introduction to the Course

This training is designed to empower participants with practical skills in quantitative data analysis using Microsoft Excel. Participants will learn essential data handling, statistical functions, analysis techniques, and visualization tools. The course is hands-on, ensuring attendees can effectively use Excel for data-driven decision-making.

Methodology

The training adopts a hands-on, participatory approach:

– Interactive lectures
– Step-by-step demonstrations
– Practical exercises and real-life case studies

Course Contents

Day 1: Foundations of Data Analysis in Excel

Introduction to Quantitative Data Analysis
– Overview and importance of data analysis
– Excel interface and data entry best practices

Data Preparation
– Data cleaning and validation
– Freeze panes, print titles, and formatting

Basic Formulas & Functions
– Sum, average, min, max, count, etc.
– Cell referencing (absolute and relative)
– Inserting comments for data documentation

Statistical Analysis
– Using functions: SUMIF, COUNTIF, AVERAGEIF, etc.
– Introduction to PivotTables for quick summaries

Data Visualization
– Creating charts and sparklines
– Conditional formatting for data insights

Session Wrap-up & Q&A

Day 2: Advanced Analysis and Reporting

Advanced Excel Functions
– IF, IFERROR, VLOOKUP, MATCH, INDEX
– Date and text functions
– Working with large datasets (data linking, filtering)

Data Analysis Techniques
– PivotCharts and Subtotal feature
– Grouping and consolidation
– Scenario analysis and goal seek

Output and Reporting
– Exporting data to Word and PowerPoint
– Mail merge and preparing reports
– Dashboard creation basics

Best Practices & Hands-on Project
– Practice on real-life data
– Dashboard techniques and feedback forms

Training Evaluation & Certificate Distribution

Who Should Attend?

This course is ideal for:
– Professionals who work with data in any capacity (finance, HR, sales, marketing, administration, etc.)
– Students and researchers seeking to enhance their analytical skills
– Managers and decision-makers requiring data-driven insights
– Anyone interested in advancing their proficiency in data analysis using Excel

Learning Outcomes

By the end of the training, participants will be able to:
– Import, clean, and organize data efficiently in Excel
– Apply a variety of Excel functions for quantitative analysis
– Summarize, analyze, and visualize data using PivotTables and charts
– Generate insights and reports for decision-making
– Build simple dashboards and export results to other applications
– Confidently use advanced Excel features for real-world problem-solving

Registration Details

Registration Deadline: June 05, 2025

Training Days

Days:  18 June 2025 to 19 June 2025

Training Language

English with Khmer translation

Course Fee

USD   300

Group Discount

20% if 2 or more participants from same organization

For More Information

Email: registration@crsmconsulting.net

Tel/WhatsApp: +92 (321) 55 65 072 | +92 (316) 58 87 783

Website: www.crsmconsulting.net