Introduction to MS Excel for Data Analytics Simplified.

Example Dataset

Let’s say we have this simple sales dataset:

_NOTE: In this table, the Total Sales column is calculated by multiplying Quantity × Price.

This kind of table is the starting point for data analysis.

AVERAGE – Find the Mean

Calculates the average of numbers.

=AVERAGE(D2:D5)

Use case: Average score, average daily sales.

3. Data Cleaning in Excel

Before analysis, data often needs cleaning.

Common cleaning tasks:

• Removing duplicates
  Data -> Remove Duplicates
  


• Sorting data
  Data -> Sort A to Z
  


• Filtering data
  Data -> Filter
  

5. Charts in Excel

Charts help turn numbers into visuals that are easier to understand.

Common chart types:

• 
  Column Chart – Compare categories


• 
  Line Chart – Show trends over time


• 
  Pie Chart – Show proportions

How to insert a chart:

1. Select your data


2. Click Insert
   


3. Choose a chart type

Example: Sales by product displayed as a column chart.

Conclusion

Excel is a powerful starting tool for data analytics because it helps you:

• Organize data in tables


• Perform calculations using functions


• Clean and filter messy data


• Summarize information with Pivot Tables


• Visualize trends using charts


• Build dashboards for reporting

Mastering Excel gives you a strong foundation before moving into advanced analytics tools like Power BI, Python, or SQL.

ALL THE BEST IN YOUR ANALYTICS JOURNEY!