Lesson 1: Workbook Structure

A workbook is an Excel file that contains one or more worksheets.

A worksheet is a page in your workbook, organized into rows (horizontal) and columns (vertical).

Cells are intersections of rows and columns where data is entered. Example: A1 is column A, row 1.

• Navigate cells using arrow keys.
• Use Ctrl + Arrow to jump to the edge of data ranges.

Lesson 2: Data Entry

Click a cell and type to enter data. Press Enter to move down or Tab to move right.

Edit data by double-clicking a cell or pressing F2. Remove content using Backspace or Delete.

• Copy with Ctrl+C, paste with Ctrl+V.
• Fill multiple cells by dragging the fill handle (small square at the cell corner).

Lesson 3: Basic Formulas

Formulas perform calculations in Excel. Start every formula with =.

Example operations:

• Addition: =A1+B1
• Subtraction: =A1-B1
• Multiplication: =A1*B1
• Division: =A1/B1

Lesson 4: Essential Functions

Functions are pre-built formulas that simplify calculations.

• SUM: Adds values. =SUM(A1:A5)
• AVERAGE: Calculates average. =AVERAGE(A1:A5)
• COUNT: Counts numbers. =COUNT(A1:A5)
• MAX / MIN: Finds highest/lowest. =MAX(A1:A5)

📈 Key Skills You’ll Learn

• Cell navigation
• Formula creation
• Data formatting
• Basic charts
• Sorting & filtering
• Print options