DAY 2: TUESDAY – MICROSOFT EXCEL

1. Introduction to Microsoft Excel

Meaning of Microsoft Excel

Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and present data using rows, columns, and cells.

 Uses of Microsoft Excel

Excel is used for:

• Calculations and data analysis

• Creating tables and charts

• Budgeting and record keeping

• Managing marks and financial data

•  

1.1. Uses of Microsoft Excel

Uses of Microsoft Excel

Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and present data. It is widely used in education, business, and many organizations.

1. Data Entry and Storage

Excel is used to:

• Enter and store large amounts of data

• Organize information in rows and columns

• Maintain records such as attendance, marks, and inventories

2. Calculations

Excel performs calculations quickly and accurately using formulas and functions, such as:

• Addition, subtraction, multiplication, and division

• Functions like SUM, AVERAGE, MAX, and MIN

3. Data Analysis

Excel helps users:

• Analyze data easily

• Sort and filter information

• Compare values and identify trends

4. Creating Charts and Graphs

Excel is used to:

• Create bar charts, pie charts, and line graphs

• Present data visually for easy understanding

5. Budgeting and Financial Management

Excel is commonly used for:

• Preparing budgets

• Managing expenses and income

• Payroll calculations

6. Record Keeping

Used in schools and offices to keep:

• Student marks

• Staff records

• Sales and stock records

7. Academic and Educational Use

Excel is used by students and teachers to:

• Calculate grades

• Prepare timetables

• Analyze academic performance

8. Business and Office Use

Businesses use Excel for:

• Sales analysis

• Inventory management

• Reporting and planning

2. Excel Worksheet Basics

 Rows, Columns, and Cells

• Rows run horizontally and are numbered

• Columns run vertically and are labeled with letters

• A cell is the intersection of a row and a column

 Entering and Editing Data

Data is entered by clicking a cell and typing.
Editing can be done by double-clicking a cell or using the formula bar.

Basic Calculations in Excel

 Formulas and Functions

Formulas start with an equals sign (=).
Examples:

• =A1+A2 (addition)

• =SUM(A1:A5) (total)

Functions make calculations easier and faster.

 Creating Simple Charts

Charts are used to present data visually.
Steps:

• Select data

• Click Insert → Chart

• Choose chart type (bar, pie, line)

2.1. Rows, Columns, and Cells

When working with spreadsheet software like Microsoft Excel, Google Sheets, or any tabular data, the basic structure is made up of rows, columns, and cells.

 Columns

• Columns are vertical divisions in a spreadsheet.

• Each column is labeled with letters (A, B, C, …, Z, AA, AB, …).

• They are used to organize data by type or category.

  • Example: Column A = Names, Column B = Age, Column C = Grade.

Rows

• Rows are horizontal divisions in a spreadsheet.

• Each row is numbered (1, 2, 3, …).

• A row represents a single record or entry in the table.

  • Example: Row 2 might contain all the information about a student: Name, Age, Grade.

 Cells

• A cell is the intersection of a row and a column.

• Cells are where you enter, store, and manipulate data.

• Each cell has an address or reference, which is the combination of its column letter and row number.

  • Example: The cell in Column B, Row 3 is B3.

2.2. Entering and Editing Data

Entering Data

1. Click the cell where you want to enter information.

2. Type the data:

   • Text: Names, addresses, descriptions.

   • Numbers: Quantities, prices, ages.

   • Formulas: For calculations like =A2+B2.

3. Press Enter (to move down to the next row) or Tab (to move to the next column).

Tip: Be careful with numbers that have leading zeros (like phone numbers). Excel might drop the zero unless the cell is formatted as Text.

2.2 Editing Data

• Edit directly in the cell: Double-click the cell and make changes.

• Edit in the formula bar: Select the cell and change the content in the formula bar at the top.

• Delete content: Select the cell and press Delete.

• Replace content: Simply type new data in the cell; it will overwrite the old content.

2.3 Additional Notes

• You can copy and paste data between cells.

• Undo mistakes using Ctrl + Z (Windows) or Cmd + Z (Mac).

• Data validation and formatting can help prevent errors when entering data.

In short:

• Rows = horizontal, represent records

• Columns = vertical, represent categories

• Cells = where data is stored

• Enter data by typing in cells, navigate with Enter/Tab

• Edit by double-clicking or using the formula bar