π Excel Basics & Interface β Part 2
π Entering, Editing & Managing Data in Excel
Now that you understand the Excel interface, let's learn how to work with data efficiently.
π 1. Types of Data in Excel
Excel mainly works with three types of data:
*πΉ Text*
Used for names, cities, products, etc.
*Examples:* Rahul, Mumbai, Laptop
*πΉ Numbers*
Used for calculations.
*Examples:* 100, 25000, 99.5
*πΉ Dates*
Excel stores dates as serial numbers internally.
*Examples:* 15/06/2026, 15-Jun-2026, June 15, 2026
*βοΈ 2. Editing Cell Contents*
*Method 1:* Double-click the cell
*Method 2:* Select cell and press F2
This puts Excel into edit mode.
*Example:*
Cell A1 contains: Deepak
Press F2 to modify it without retyping.
*π 3. Copy, Cut and Paste*
*Copy*
Shortcut: Ctrl C
Copies data without removing it.
*Cut*
Shortcut: Ctrl X
Moves data from one location to another.
*Paste*
Shortcut: Ctrl V
Inserts copied/cut data.
*π― 4. Paste Special*
Paste Special gives more control over what gets pasted.
*Access:* Ctrl Alt V
*Common Options:*
Option | Purpose
Values | Paste only values
Formulas | Paste only formulas
Formats | Paste formatting only
Transpose | Convert rows to columns
*Example:*
Original formula: =A1 B1
Paste Values converts the result into a fixed number.
*π 5. Undo and Redo*
*Undo:* Ctrl Z
Reverses the last action.
*Redo:* Ctrl Y
Restores an undone action.
π These are among the most frequently used shortcuts in Excel.
*π 6. Selecting Data Efficiently*
*Select a Cell:* Simply click the cell
*Select Multiple Cells:* Click and drag. Example: A1:D10
*Select Entire Row:* Shortcut: Shift Space
*Select Entire Column:* Shortcut: Ctrl Space
*Select Entire Worksheet:* Shortcut: Ctrl A
*π 7. AutoFill Feature*
AutoFill automatically extends patterns.
*Example Text:*
Enter: Jan
Drag the fill handle down.
Excel generates: Jan, Feb, Mar, Apr
*Example Numbers:*
1, 2 β Drag downward: 3, 4, 5, 6
π Huge time saver for analysts.
*π 8. AutoSum*
AutoSum quickly calculates totals.
*Shortcut:* Alt =
*Example:*
100, 200, 300 β AutoSum returns: 600
*Equivalent Formula:* =SUM(A1:A3)
*π 9. Saving Excel Files*
*Save:* Ctrl S
*Save As:* F12
*Common File Types:*
Extension | Purpose
.xlsx | Standard workbook
.xls | Older Excel format
.csv | Data exchange
.xlsb | Faster for large files
*ποΈ 10. Insert and Delete Rows & Columns*
*Insert Row:*
1. Right-click row number
2. Click Insert
*Delete Row:*
1. Right-click row number
2. Click Delete
*Insert Column:*
1. Right-click column letter
2. Click Insert
π Excel automatically adjusts formulas when rows/columns are inserted properly.
*π― Mini Practice Project*
Create a workbook called: Employee_Database.xlsx
*Columns:*
Employee ID | Name | Department | Salary
E001 | Rahul | Sales | 50000
E002 | Priya | HR | 60000
E003 | Amit | IT | 70000
*Practice:*
β
Copy and paste records
β
Insert a new employee row
β
Use AutoSum on salaries
β
Use AutoFill for employee IDs
β
Save file as .xlsx
*π End of Part 2*
After completing Part 2, you should be able to:
β
Enter and edit data
β
Copy, cut, and paste efficiently
β
Use AutoFill and AutoSum
β
Select data quickly using shortcuts
β
Save and manage Excel files
β
Insert/delete rows and columns confidently
β‘οΈ *Double Tap β€οΈ For Part-3*