What is Microsoft Excel?
Microsoft excel is one of the most popular spreadsheet applications.
INTRODUCTION TO THE SPREADSHEET (MS EXCEL)
Spread sheet concept
Spread sheet is the generally used for manipulating numerical
information.
Spread sheet consists of series of row and columns.
The intersection of a row and column is called a cell.
Text is inserted into the cells. Every cell is referenced by the column
label and row number (Eg: - B4) B is s column name and 4 for row.
Spreadsheet is a computer application program that shows accounting
other DARUL data in rows and columns in order to manipulate it.
Microsoft Excel
Microsoft Excel is spread sheet program written and distributed by
Microsoft for computer using the Microsoft windows operating system.
Starting ms-Excel2010
1. Click start bottom
2. Point program then point Microsoft Excel 2010
3. Microsoft excel book1 appears
Running Ms-excel from program command
1. Click start button
2. Select program
3. Click Microsoft office and click Ms-excel to start
Running Ms-excel from run command
Click start button select run command in the run command type excel
and press enter.
Another way to start Microsoft excel
➤ Click start menu in the search programs and files type excel and press
enter.
Exiting Microsoft excel 2021
Click Microsoft office button
Click exit excel
So any time you start windows, Microsoft excel will automatically
startup.
Note this program Ms-excel is one the spreadsheet programs, which
contains three in one program:
Data
Graph
Workbook
What is the Workbook?
In the Microsoft excel, the file in which you work and store your data is
called Workbook.
Workbook contains three sheets, the default workbook open with 3
sheets, named sheet I through sheet 3.
Exiting MS-excel 2010
1. Click file menu, then click Exit
2. Double click control menu box
Microsoft Office Button
The Microsoft Office Button performs many of the functions that were
located in the File menu of older versions of Excel. This button allows
you to create a new workbook, Open an existing workbook, save and
save as, print, send, or close.
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing
Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options,
Arrange
Formulas: Function Library, Defined Names, Formula Auditing,
Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools,
Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
Creating A new Workbook
Click the Microsoft office button
Click new
Click blank workbook and then click create
Entering data in to a cell
1. Place the cell pointer in the cell you want to enter a data
2. Type you data and press enter
3. Cell pointer moves down ready for the next entry.
Entering Data with a different areas
To enter data in a cell --------------------------------press
Top to the button -------------------------------------Enter
Bottom to the top-------------------------------------Shift +enter
Left to the right------------------------------------------ Tab
Right to the left---------------------------------------Shift tab
Saving a Worksheet
When working in Excel it is necessary to save your files. It is also very
important that while working, your file is saved frequently. When
naming a file, you are restricted to 255 characters. Avoid most
punctuation, spaces are acceptable
To Save the File:
1) Click on the File tab
2) Click Save
3) Type a file name
4) Click Save
Difference between workbooks and worksheets
Workbook: In Microsoft Excel workbook is the file or document in
which you work and store your data, because each workbook can
contain many sheets, so you can organize different kinds of information
in single file.
Worksheets: -worksheet: the primary document that you use in Excel to
store and work with data (Spreadsheet) a worksheet consists of cells that
are organized into columns and row: a worksheet is always stored in a
work.
Columns: is a vertical division in the worksheet and are headed by
letters. Each worksheet contains (16384 columns) RAKAT
Row: is horizontal division in the worksheet and are headed by work
shed and are headed by UTE numbers. Each contain (1048576 rows)
Cell: is intersection between columns and row. A cell can contain a text,
symbol, numeric value or formula.
There are (17179869184) cell in each excel sheet.
Label the letters and numbers of columns and rows which appears in
gray button at the top and left side of the worksheet.
Cell address: a cell address is the location of a cell on a worksheet and
the arrow keys when you move to a cell and row number.
Cell address: A combination of a letter and a number that specifies the
column and row in which a cell is located on a spreadsheet.
For example, cell A1 is where column A and row 1 interest.
Screen Elements
Key interface elements of Excel include the title bar, menu bar, toolbar,
formula bar, and navigation buttons to move between
The Ribbon
Understanding the Ribbon is a great way to help understand the changes
between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the
information in previous versions of Microsoft Office in a more visual
stream line manner through a series of tabs that include an immense
variety of program features
Home Tab
This is the most used tab, if incorporates all text and cell formatting
features such as font and paragraph changes. The home tab also includes
basic spreadsheet formatting elements such as text wrap, merging cells
and cell style.
Insert Tab
This tab allows you to insert a variety of items into a document from
pictures, clip art, and headers and footers
Page Layout Tab
This tab has commands to adjust page such as margins, orientation and
themes
Formulas Tab
This tab has commands to use when creating Formulas. This tab holds
an immense function library which can assist when creating any formula
or function in your spreadsheet.
Data Tab
This tab allows you to modifying worksheets with large amounts of data
by sorting and filtering as well as analyzing and grouping data
Review Tab
This tab allows you to correct spelling and grammar issues as well as set
up security protections. It also provides the track changes and notes
feature providing the ability to make notes and change someone's
document.
View Tab
This tab allows you to change the view of your document including
freezing or splitting panes, viewing gridlines and hide cells.
Highlighting/Selecting Areas Using the Mouse
Select Cells:
Moves a cell's contents:
Activate the Auto fill feature:
To Select a Column: Click on the column letter
To Select a Row: Click on the row number
To Select the Entire Worksheet: Click above row 1 and to the left of
column A or hit CTRL A on the keyboard
Creating Formulas
Formulas perform calculations or other actions on the data in your
worksheet. A formula starts with an equal sign (=). It is possible to
create formulas in Excel using the actual values, such as "4000* 4" but it
is more beneficial to refer to the cell address s in the formula, for
example "D1* 4.
It is also important to know the operators Excel uses for formulas:
Opening an existing workbook
1. Open Microsoft office button
2. Select open or press CTRL + 0
3. In the look in drop down list box, select where you want to look your
file
4. In the file of type drop down list box, select your file type
5. In the file name box, type the file you want to open
6. Click open button.
Adding a file to a password
1. Open Microsoft office button
2. Select save as
3. Click tools/general options
4. Type the password in the password open box
5. Click ok
6. Re-enter the password in to the re-enter password proceed box
7. Click ok
8. Click save button
9. Click ok button
Removing a password protection
1. Click Microsoft office button
2. Select save as
3. Click tools/general options
4. Delete the password
5. Click ok
6. Click saves
Select Data
To select a cell or data to be copied or cut:
Click the cell
Click and drug the cursor to select many cells in a rang
Select a row or column
To select a row or column click on the row or column header.
Change data in a cell
Double click on the data you want to change, use arrows then recorrect
your data
And press enter.
Replace data in cell
1. Click the cell containing the data you want to replace with a new data
2. Type the new data and then press enter
Using formulas
Operator Function
(Key)
= Begins all Excel functions and formulas
+ Addition
_ Subtraction
* Multiplication
/ Division
To Create a Formula:
1) Click in a cell
2) Press the = key
3) Type the formula
4) Press Enter
Excel Functions
As we have previously seen, the power of Excel lies in its ability to
perform calculations. The real strength of this is shown in Functions.
Functions are more complex formulas that are executed by using the
name of a function and stating whatever parameters the function
requires.
Function Defined
=SUM(range of cells) returns the sum of the selected cells
=AVERAGE (range returns the average of the selected cells
of cells)
=MAX(range of cells) returns the highest value of the selected cells
=MIN(range of cells) returns the lowest value of the selected cells
=COUNT(range of returns the number of values of the selected
cells) cells
To Enter the SUM Function:
1) Click in a cell
2) Click on the AutoSum button in the Editing group
3) Highlight the range of cells that are to be added (The colon means
"through")
4) Press ENTER
To Enter the Average Function:
1) Click in a cell
2) Click on the drop-down arrow next to the AutoSum button
3) Click on Average
4) Highlight the range of cells be calculated
5) Press ENTER
To Insert the MAX Function into the Worksheet:
1) Click in a cell
2) Click on the drop-down arrow next to the AutoSum button
3) Click on Max
4) Highlight the range of cells be calculated
5) Press ENTER
To Insert the MIN Function into the Worksheet:
1) Click in a cell
2) Click on the drop-down arrow next to the AutoSum button
3) Click on Min
4) Highlight the range of cells be calculated
5) Press ENTER
To Insert the COUNT NUMBER Function into the Worksheet:
1) Click in a cell
2) Click on the drop-down arrow next to the AutoSum button
3) Click on Count Numbers
4) Highlight the range of cells be calculated
5) Press ENTER
1. Place the cursor under the grades
2.
Type=IF(G2>90,"A",IF(G2>85,"B+",IF(G2>80,"B",IF(G2>70,"C",IF(G
2<50," Re-exam")))))
N A B C D E F G H I
O
1 Name Ms- Ms - Ms- Ms- A+ Aver Resu Grad
wind word excel access lt es
ows
2 Ali 98 88 90 100 80 91.2 Pass A
Hassan ed
3 Hassan 70 99 90 100 86 89 Pass B+
ed
4 Mohame 90 80 88 80 89 83.8 Pass B
d ed
5 Yusuf 80 77 70 75 70 74.4 Pass C
ed
6 Salah ali 50 43 44 23 88 49.6 Faile Re-
d exam
Conditional formatting
1. Highlight the cells you want to format.
2. Click home tab, click style arrow then click conditional formatting
arrow.
3. Point color scales.
4. Select the color scales you want OR
5. Click new rule then click ok
Formula bar: - displays in the constant value or formula in the active
cell
Running total
No Date Name Salary
1 Feb 05,2024 $250
2 Feb 06,2024 $340
3 Feb 07,2024 $568
4 Feb 08,2024 $657
5 Feb 09,2024 $654
6 Feb 10,2024 $300
7 Feb 11,2024 $950
Running total
Marketing averages
A B C D E F Average
1 Name Ms- Ms - Ms- Ms- A+
windows word excel access
2 Ali 98 88 90 100 80
Hassan
3 Hassan 70 99 90 100 86
4 Mohamed 90 80 88 80 89
5 Yusuf 80 77 70 75 70
6 Salah ali 50 43 44 23 88
1. Place the cursor under the average column
2. Click Formulas, in the function library group click more functions
button.
3. Click statistical, then click average.
4. Click ok.
A B C D E F G H
1 Name Ms- Ms – Ms- Ms- A+ Average Result
windows word excel access
2 Ali Hasan 98 88 90 100 80 91.2
3 Hassan 70 99 90 100 86 89
4 Mohamed 90 80 88 80 89 83.8
5 Yusuf 80 77 70 75 70 74.4
6 Salah ali 50 43 44 23 88 49.6
Making result
1. Place the cursor under the result column
2. Click formulas tab, in the function library group click insert function
button or click logical arrow
3. Choose if under function name then click ok
4. Type in the logic_test box G2>50
5. Type passed in the value_if_true box
6. Type failed in the value if false box then click ok
Students Grade
N A B C D E F G H I
O
1 Name Ms- Ms - Ms- Ms- A+ Aver Resu Grad
wind word excel access lt es
ows
2 Ali 98 88 90 100 80 91.2
Hassan
3 Hassan 70 99 90 100 86 89
4 Mohame 90 80 88 80 89 83.8
d
5 Yusuf 80 77 70 75 70 74.4
6 Salah ali 50 43 44 23 88 49.6
3. Place the cursor under the grades
4. Type=IF(G2>90,"A",IF(G2>85,"B+",IF(G2>80,
"B",IF(G2>70,"C",IF(G2<50," Re-exam")))))
N A B C D E F G H I
O
1 Name Ms- Ms - Ms- Ms- A+ Aver Resu Grad
wind word excel access lt es
ows
2 Ali 98 88 90 100 80 91.2 Pass
Hassan ed
3 Hassan 70 99 90 100 86 89 Pass
ed
4 Mohame 90 80 88 80 89 83.8 Pass
d ed
5 Yusuf 80 77 70 75 70 74.4 Pass
ed
6 Salah ali 50 43 44 23 88 49.6 Faile
d
Conditional formatting
6. Highlight the cells you want to format.
7. Click home tab, click style arrow then click conditional
formatting arrow.
8. Point color scales.
9. Select the color scales you want OR
10.click new rule then click ok
Formula bar: - displays in the constant value or formula in the
active cell
Create Chart
Creating a chart in Microsoft Office Excel is quick and easy.
1) Click Insert tab, then click Charts arrow then choose the chart
type you want OR
2) In the Charts group click the chart type you want
Changing a chart type
1. Right click on the chart then click Change Chart Type then
choose the style you want
2. Click Ok
Moving and resizing chart
1. To move a chart click inside the chart then drag the mouse to the
position you want
2. To resize a chart pion the mouse on the boundary dots of a chart
then drag the mouse to the position you want
Deleting and a chart
1. Click the chart you want to delete
2. Press del key on the keyboard
Printing a document
1. Type your document
2. Click file menu, under printer select print name
3. Under setting select the options you want (e.g. print active sheets,
print selection OR print entire workbook)
4. Click Page setup then select portrait OR landscape Click Ok
