Description:

This course covers the fundamental concepts of data analysis using Microsoft Excel. You will learn how to use functions like vlookup, pivot tables, power query, and statistical analysis in Excel to analyze and visualize data effectively. Additionally, you will learn how to create informative reports and dashboards to present your findings in a clear and visually appealing manner.

Key Highlights:

• Introduction to Data Analysis in Excel
• Mastering Vlookup and Pivot Tables
• Using Power Query for Data Manipulation
• Statistical Analysis Techniques in Excel
• Creating Reporting and Dashboards

What you will learn:

• Understand Data Analysis Fundamentals
  Learn the basics of data analysis and how Excel can be used for data manipulation and visualization.
• Master Vlookup and Pivot Tables
  Gain expertise in using vlookup and pivot tables to efficiently analyze and summarize data.
• Explore Power Query and Data Transformation
  Discover the power of Power Query for cleaning, transforming, and shaping data for analysis.
• Perform Statistical Analysis
  Apply statistical techniques in Excel to derive meaningful insights from your data.
• Create Reports and Dashboards
  Learn how to create professional reports and interactive dashboards to showcase your data analysis results.

Schedule:

Session 1 - 29th June (Sat) [7:00 PM]

Session 2 - 30th June (Sun) [7:00 PM]

Session 3 - 6th July (Sat) [7:00 PM]

Session 4 - 7th July (Sun) [7:00 PM]