Excel Basics for Data Analysis

🔹 Introduction

This section is designed for complete beginners who have never used Excel before.
Before moving to data analysis, you need to understand the basic tools in Excel.

🔹 Lesson 1: Understanding Excel

Excel is made up of:
  • Rows (horizontal)
  • Columns (vertical)
  • Cells (where data is stored)
Each cell has an address (e.g., A1, B2).

🔹 Lesson 2: Entering Data

To enter data:
  1. Click on any cell
  1. Type your value
  1. Press Enter
You can enter text, numbers, or dates.

🔹 Lesson 3: Basic Formulas (VERY IMPORTANT)

A formula is used to perform calculations.
To calculate total:
  1. Click on an empty cell
  1. Type:
    =SUM(
  1. Note this: = sign is very important in excel when calculating.
  1. Select numbers
  1. Close bracket )
  1. Press Enter

🔹 Lesson 4: Sorting Data

Sorting helps organize data.
  1. Select your dataset
  1. Go to "Data" tab
  1. Click "Sort"

🔹 Lesson 5: Filtering Data

Filtering helps you view specific data.
  1. Select your dataset
  1. Click "Filter"
  1. Choose what you want to display