IHE Spark Series -5

👨‍🏫 Speaker

Dr Santhosh N

Professor & Head, Dept. of Mechanical Engineering

Dayananda Sagar Academy of Technology & Management , Bengaluru, India

Prof. Santhosh is a distinguished academician with extensive experience in data analytics and statistics. He has contributed to several research initiatives and actively guides students and professionals in gaining practical and statistical insights into data analysis using Microsoft Excel. His expertise bridges theoretical concepts with real-world analytical applications.

🧠 Webinar Overview

Data Analytics using Excel is a practical and hands-on session designed to help participants understand how Excel can be effectively used as a powerful data analytics tool. The webinar focuses on transforming raw data into meaningful insights through cleaning, analysis, visualization, and statistical techniques.

Participants will explore how Excel supports data-driven decision-making using built-in tools, formulas, and analytical add-ins commonly applied in academics, research, and industry.

📌 Topics Covered

Participants will gain understanding of:

• Data Cleaning & Preparation

  Sorting, filtering, Data Validation, and Power Query to structure raw data, handle missing values, and transform datasets into usable formats (e.g., Ctrl + T to convert data into Tables)

• Formulas & Functions

  Practical use of functions such as SUM, AVERAGE, IF, and VLOOKUP for calculations and data lookup

• PivotTables

  Summarizing, grouping, and aggregating large datasets to identify trends (e.g., total sales by region, product-wise analysis)

• Data Visualization

  Creating charts such as bar, line, pie, and box & whisker plots to visually represent patterns, distributions, and outliers

• Statistical Analysis

  Using the Analysis ToolPak for regression, descriptive statistics, histograms, and more

• Data Types in Excel

  Converting text into linked data types (Stocks, Geography) to fetch live and structured data directly into worksheets

👥 Who Should Attend?

This webinar is ideal for:

• Students from any discipline interested in data analytics

• Researchers and academicians

• Industry professionals and working executives

• Beginners exploring Excel for analytics

• Anyone interested in data-driven decision-making

🎯 Key Takeaways

Participants will learn:

• How to clean and prepare real-world datasets

• Apply Excel formulas and functions effectively

• Use PivotTables for meaningful data summarization

• Create impactful visualizations

• Perform basic statistical analysis using Excel

• Understand Excel’s role in modern data analytics

📅 Event Details

• Mode: Online
• Date: 12th January 2026
• Time: 07:30 PM – 08:30 PM (IST)
• Platform: Zoom / Google Meet
• (Meeting link will be shared with registered participants)

🎁 Benefits for Participants

• E-Certificate of Participation

• Access to session materials (slides and notes)

• Live interaction and Q&A with the expert

• Practical exposure to data analytics using Excel

📝 Registration

Apply Here 

Limited seats available — Early registration is recommended.

📩 Contact Us

For queries or support:

📧 Email: info@ihedu.org

🌐 Website: www.ihedu.org