Module 1: Getting Started with Excel
Session 1: Introduction to Excel
• Excel is a spreadsheet software used to organize, calculate, and analyze
data.
• Developed by Microsoft, it’s part of the MS Office suite.
• Used by students, professionals, and businesses worldwide.
Why learn Excel?
• Manage data (sales, marks, expenses).
• Perform calculations (from simple sums to complex financial formulas).
• Create charts and reports.
• Automate tasks with built-in tools.
Think of Excel as your digital notebook + calculator + chart maker all in one.
Session 2: Navigating the Excel Window
When you open Excel, you’ll see a blank worksheet. Let’s break down the interface.
2.1 The Ribbon
• Located at the top of the window.
• Divided into Tabs (Home, Insert, Formulas, etc.).
• Each tab has Groups (like Font, Alignment, Number).
• Inside each group are Commands (Bold, Italic, Border, etc.).
Shortcut: Press Alt on your keyboard. Letters will appear on each tab for quick
access.
2.2 Name Box
• Shows the address of the active cell (example: A1, C5).
• Can also be used to jump directly to a cell by typing its address.
2.3 Formula Bar
• Displays what’s inside the selected cell.
• If you type a number → it shows that number.
• If you type a formula (e.g., =A1+B1) → it shows the full formula.
Formula bar is your window into the cell’s contents.
2.4 Worksheet Tabs
• Found at the bottom of the window.
• Let you switch between different worksheets in the same file.
• You can:
o Add a new sheet
o Rename a sheet
o Delete a sheet
2.5 Scroll Bars
• Horizontal and vertical bars help you move around large worksheets.
• Use them when data goes beyond the visible area.
2.6 Quick Access Toolbar (QAT)
• Small toolbar (top-left).
• Contains shortcuts like Save , Undo , Redo .
• You can customize it with your favorite commands.
2.7 File Tab (Backstage View)
• Located at the top-left corner.
• Used to:
o Create new files
o Open existing files
o Save or print workbooks
o Access options & settings
Session 3: Understanding Workbooks & Worksheets
3.1 Workbook
• An Excel file is called a workbook.
• Example: Monthly [Link] is a workbook.
3.2 Worksheet
• Each workbook contains one or more worksheets.
• A worksheet looks like a grid of rows and columns.
• Rows → horizontal, numbered (1, 2, 3, …).
• Columns → vertical, labeled (A, B, C, …).
• Cell → the intersection of a row & column.
Example: Cell B3 = Column B + Row 3.
3.3 Cell Address
• Each cell has a unique address (e.g., D5, A1).
• This helps Excel identify and use data in formulas.
Tip: Always remember the cell address is Column Letter + Row Number.
3.4 Active Cell
• The cell currently selected (bordered with a thick outline).
• Data you type always goes into the active cell.
3.5 Range of Cells
• A range = group of selected cells.
• Example: A1:C3 means cells from A1 to C3.
3.6 Practical Example
Imagine you are tracking expenses:
Item Cost Quantity
Apples 100 5
Bananas 60 10
• Workbook name: [Link]
• Worksheet name: “Expenses”
• Active Cell: B2 (contains 100).
• Range: B2:C3 (costs + quantities).
Key Takeaways from Module 1
• Excel is used for data organization, calculation, and visualization.
• Workbook = file, Worksheet = page inside the file.
• Cell Address = Column + Row (e.g., A1).
• The Ribbon, Name Box, Formula Bar, and Tabs are the main parts of the
interface.
• Knowing how to navigate Excel is the foundation for everything else.