All Courses Data Analytics with MS Excel
PKR 4000 PER PARTICIPANT
20 DAYS
Data Analytics with MS Excel
Unlock data insights with MS Excel. Master data analytics for confident decision-making.
Instructors:
Ghulam Mustafa (Khalid Associates Global)
Start Learning
You have opted to be notified for this course. You will receive an email when the course becomes available.
0 Enrolled
4 Lessons

Welcome to Data Analytics with MS Excel! In this course, you will learn how to harness the power of Microsoft Excel to analyze and interpret data. Discover essential techniques, including data cleaning, visualization, and basic statistical analysis. Gain valuable skills to make data-driven decisions and excel in your analytics journey.


What is included?

  1. Interactive content
  2. Exercises for assessment
  3. Live Q&A
  4. Certificate of completion
Course Content
- Course Overview
Lecture 01- Overview
- Types of Variables
- Analytics
- Datasets
- Basic Formulas
- Number Formatting
- Relative and Absolute Reference
- Average & What IF Functions
- Work of IF Condition data
- Advance Functions of IF
- How IF condition works
Basic Formulas
- Essentials of Formatting Part 1
- Essentials of Formatting Part 2
- Data Sheet and Time Formatting
- Table & Arrays
- Graphs & Chart
Essentials of formatting Part 1
- Look-Up Functions
- Pivot Table
Look Up Functions
Reviews
Review the course
Help us improve our course material.
Write a review