Introduction to Microsoft Excel
Instructor: Peter Mkomange
Phone: +255 624 998 215
Why Welders Need Excel
➢Track material costs
➢Inventory Management
➢Create invoices and job estimates
➢Generate Reports
➢Manage Project Hours
TREY
research
2
What is Excel ?
➢Microsoft Excel is a spreadsheet
program used for data organization,
calculation, and analysis.
➢Ni programu inayotumika kupanga,
kukokotoa na kuchanganua data.
TREY
research
3
Common Uses Of
Microsoft Excel
➢Managing budgets,
➢Tracking expenses,
➢Creating reports,
➢Analyzing data, and
more.
Add a footer TREY
research
4
Common terms in Microsoft Excel
Workbook and Worksheet in Excel
Workbook Worksheet
➢A file in Excel that contains one or ➢An individual sheet within a
more worksheets. workbook where you enter and
➢Think of it as a binder that holds manage data.
multiple sheets for different tasks ➢Each worksheet has its own grid of
or projects. rows and columns.
Add a footer TREY
research
5
Common terms in Microsoft Excel…
Column and Row in Excel
Column Row
➢Vertical sections in the worksheet. ➢Horizontal sections in the
➢Labeled with letters (A, B, C, etc.). worksheet.
➢Example: Column A contains all ➢Labeled with numbers (1, 2, 3, etc.).
cells in the first vertical line (A1, A2, ➢Example: Row 1 contains all cells in
A3, etc.). the first horizontal line (A1, B1, C1,
etc.).
Add a footer TREY
research
6
Enjoy Microsoft Excel
TREY
research
7
How to Open Excel
On Windows:
➢ Click the Start button.
➢ Type "Excel" in the
search bar.
➢ Click on Microsoft Excel
from the results.
Add a footer TREY
research
8
Create a New
Workbook
Steps:
➢ Click on Blank
Workbook.
➢ Or, click File > New >
Blank Workbook.
Add a footer TREY
research
9
Microsoft Excel Screen
Add a footer TREY
research
10
Quick Access Toolbar
➢ Above the ribbon, this allows for quick access to frequently used
commands like Save and Undo.
Add a footer TREY
research
11
Formula Bar
➢ Displays the content or
formula in the selected
cell
Add a footer TREY
research
12
Worksheet Grid
➢ The main area for
entering data,
consisting of rows
(numbers) and columns
(letters).
Add a footer TREY
research
13
Cells
➢ Individual boxes where
data is input, located at
the intersection of rows
and columns.
Add a footer TREY
research
14
Tabs
➢ Found at the bottom, used to switch between different worksheets within
the same workbook.
Add a footer TREY
research
15
Enter Data in Excel
➢Select a Cell: Click on any cell in the worksheet where you want to enter
data.
➢Type Your Data: Start typing (e.g., numbers, text, dates) directly into the
selected cell.
➢Press Enter: After typing, press Enter to move to the cell below, or press Tab
to move to the next cell to the right.
➢Edit Data: To edit, double-click on the cell or click once and make changes in
the Formula Bar.
➢AutoFill: Drag the small square at the cell corner to copy or fill a series of
values (e.g., dates or numbers).
Add a footer TREY
research
16
Practical Exercise
TREY
research
17
Cell Formatting
➢ Font Style and Size:
Adjust the font and size of
the text.
➢ Number Formatting:
Format cells as currency,
percentage, date, etc.
➢ Cell Alignment: Align text
to the left, center, or right
within a cell.
Add a footer TREY
research
18
Cell Referencing in Excel
A cell reference identifies a cell or a range of cells in Excel.
Types of Cell References
➢Relative Reference: Changes when copied to another cell (e.g., A1).
➢Absolute Reference: Remains fixed when copied, using $ (e.g., $A$1).
➢Mixed Reference: One part is fixed while the other changes (e.g., $A1 or
A$1).
Usage
• References are used in formulas to pull values from specific cells.
• Example: =A1 + B1 adds values from cells A1 and B1.
Add a footer TREY
research
19
Save Your Work
➢ Click File > Save As,
➢ choose a location,
➢ enter a name,
➢ save your file.
Add a footer TREY
research
20
Opening an Existing
Workbook
➢ File > Open: Locate and
open a previously saved
workbook.
Add a footer TREY
research
21
Navigating Sheets
➢ Use the sheet tabs at
the bottom to move
between different
worksheets within a
workbook.
Add a footer TREY
research
22
Practical Exercise
TREY
research
23
Formulas and Functions
Basic Formulas: Common Functions:
➢Addition: =A1 + B1 ➢SUM: =SUM(A1:A5) - Adds up all
➢Subtraction: =A1 - B1 the numbers in a range.
➢Multiplication: =A1 * B1 ➢AVERAGE: =AVERAGE(A1:A5) -
Calculates the average of numbers
➢Division: =A1 / B1 in a range.
➢MIN/MAX: =MIN(A1:A5) /
=MAX(A1:A5) - Finds the
smallest/largest number in a range.
➢IF: =IF(A1 > 10, "Yes", "No") -
Returns "Yes" if A1 is greater than
10, otherwise "No".
Add a footer TREY
research
24
Creating a Time Tracker in Excel
Purpose:
➢Track hours worked on different projects efficiently using Excel.
Input Start and End Times:
➢Enter the start time in one cell (e.g., A2) and the end time in another (e.g.,
B2).
Calculate Total Hours:
➢Use the formula =B2 - A2 to calculate the time worked.
➢Format the result as time by right-clicking the cell, selecting Format Cells,
then choosing Time.
Add a footer TREY
research
25
Data Visualization
with Charts
Creating a Chart:
➢ Select the data range
you want to visualize.
➢ Insert > Charts: Choose
a chart type (e.g., Bar,
Line, Pie).
➢ Customize the chart
using the Chart Tools
that appear once the
chart is inserted.
Add a footer TREY
research
26
Practical Exercise
Add a footer TREY
research
27
ThankYou
Peter Mkomange
+255 624 998 215
mkomange20@gmail.com
TREY
research
28
