Lecture Notes Of Class 1
Introduction to MS Excel
Objective:
Familiarize students
with the MS Excel interface and basic functions, including navigation, data
entry, and file management.
1. Overview of
Excel Interface
1.1. The Ribbon:
- Definition: The Ribbon is the toolbar at the top of
the Excel window.
- Components:
- Tabs: Organize commands into groups (e.g., Home, Insert, Page Layout).
- Groups: Collections of related commands (e.g., Font, Alignment).
- Commands: Actions you can perform, such as
formatting text or inserting charts.
1.2. Worksheets:
- Definition: A worksheet is a single spreadsheet
within a workbook.
- Components:
- Sheet Tabs: Located at the bottom of the Excel
window, allowing navigation between sheets.
- Default Name: Each new worksheet is named
"Sheet1", "Sheet2", etc.
1.3. Cells:
- Definition: The intersection of a row and column
where data is entered.
- Reference: Each cell has a unique address (e.g., A1,
B2).
- Selection: Click on a cell to select it. The
selected cell is highlighted.
1.4. Rows and
Columns:
- Rows: Horizontal lines in a worksheet, numbered sequentially (e.g., 1,
2, 3).
- Columns: Vertical lines in a worksheet, lettered sequentially (e.g., A, B,
C).
2. Basic Navigation
and Cell Selection
2.1. Navigation:
- Using Mouse: Click on any cell to navigate to it.
- Using Keyboard:
- Arrow Keys: Move between cells.
- Enter Key: Move to the cell below.
- Tab Key: Move to the cell to the right.
- Shift + Arrow Keys: Select a range of cells.
2.2. Cell
Selection:
- Single Cell: Click on the cell.
- Range of Cells: Click and drag across multiple cells.
- Entire Row or Column: Click on the row number or column letter.
- All Cells: Click the triangle at the top-left corner
of the worksheet (between row numbers and column letters).
3. Creating,
Saving, and Opening Workbooks
3.1. Creating a New
Workbook:
- Method 1: Click "File" >
"New" > "Blank Workbook".
- Method 2: Press Ctrl + N to open a new workbook.
3.2. Saving a
Workbook:
- First Save: Click "File" > "Save
As" > Choose location > Enter file name > Click
"Save".
- Subsequent Saves: Click "File" >
"Save" or press Ctrl + S.
3.3. Opening a
Workbook:
- Method 1: Click "File" >
"Open" > Browse to the file > Click "Open".
- Method 2: Press Ctrl + O to open the Open dialog
box.
4. Entering Data:
Text, Numbers, Dates
4.1. Entering Text:
- Steps:
- Select a cell.
- Type the text.
- Press Enter to confirm or Tab to move to
the next cell.
4.2. Entering
Numbers:
- Steps:
- Select a cell.
- Type the number.
- Press Enter to confirm or Tab to move to
the next cell.
- Formatting Numbers: Use the "Number" group on the
Home tab to format numbers (e.g., currency, percentage).
4.3. Entering
Dates:
- Steps:
- Select a cell.
- Type the date (e.g., 08/28/2024 or August
28, 2024).
- Press Enter to confirm or Tab to move to
the next cell.
- Date Formats: Excel recognizes multiple date formats
and automatically adjusts based on locale settings.
Summary:
In this class, you
have learned the fundamental elements of the MS Excel interface, including the
Ribbon, worksheets, cells, rows, and columns. You have also practiced basic
navigation, cell selection, and data entry, which are essential for effectively
using Excel for various tasks.
Exercises:
- Create a New Workbook: Open Excel, create a new workbook, and
save it with your name.
- Enter Data: In the new workbook, enter a list of your
favorite items (e.g., fruits, books) along with their quantities and
prices.
- Format Cells: Apply different formatting styles to your
data, such as bold text, colored cells, and number formatting.
