Welcome back
How to work on the excel program
In this article, we will learn how to work on Microsoft
Office Excel in a very easy and distinctive way in the Office for World website
Create a new work book
The file or document in the Excel program is called the
Workbook, so when you start a new project in Excel, you must start creating a
new work book, and this can be done by following the following steps:
1-
Click
on the File menu that appears on the Excel screen.
2-
Choose
a new option.
3- Click on the Blank Workbook option.
Opening an Existing Workbook A pre-existing Excel
workbook can be opened on the
user's computer by following the following steps:
1-
Clicking
on the File option. Click on the "Open" option.
2-
Choose
the Computer option,
3-
then
click on the Browse option,
4-
then
go to the place where the Excel workbook is saved across the device, and an
existing file can be opened via the OneDrive cloud storage service by clicking on the “One” option
Drive).
5-
Click
on the workbook you want to open, then click on the “Open” option.
Creating a worksheet A spreadsheet in Excel
is defined as the file that
contains a group of cells consisting of rows and columns in the Excel program.
Work One or more worksheets, where you can add a new worksheet to the workbook
by clicking on the plus sign (+) that appears at the bottom of the current
worksheet, specifically next to its tab.
Create a table in Excel
The following steps explain how
to create a table in Excel by Determine the cells that the table should
contain:
1-
Open
the worksheet on which you want to insert the table.
2-
Use
the mouse to select the group of cells that the table should include.
3-
Click
on the "Insert" tab. Clicking on the “Table” option to bring up the
Create Table via Excel box.
4-
Select
the checkbox next to the My table has headers option to add any meta tags that
contain information for each column in the table to be created.
5-
Click
on the OK option.
Entering data into the table
The following steps explain how
to enter data into a table created via Excel:
1-
Clicking
on the cell in the table to which you want to add data. It should be noted that
the cell name is determined according to its position in the row and column;
For example, the cell in the first row of the first column is called cell (A1).
2-
Type
text or a number within the selected cell.
3-
Press
Enter to enter data, or Tab on the keyboard to move to the next cell.
Adding borders to cells
The following steps explain how
to add borders to a group of cells via Excel:
1-
Use
the mouse to select the group of cells that the user wants to add borders to.
2-
Click
on the Home tab that appears on the Excel screen.
3-
Go
to the Fonts group on the main page, then click on the arrow icon next to the
border icon. Choose the type of borders to be added to the table through the
drop-down list that contains multiple types of borders that can be added to the
selected cells.
Using Auto Sum to collect data
The Excel user can use what is known as Auto
Sum to find the sum of the numbers in specific cells and insert the result into
another cell, by following the following:
1-
Select the cell below the cells you want to
find the result of adding the numbers in.
2-
Click
on the Home tab. Move to the Editing group.
3-
Clicking on the AutoSum icon ( Σ ) to show the
result of adding numbers in the selected cell.
Creating an Equation in Excel
An Excel user can create
mathematical equations to apply to data in certain cells,
1-
then
find the result of the equation and place it within another cell.
2-
Start
by typing an equal sign (=);
3-
Every
math equation in Excel should start with this symbol.
4-
Writing
the text of the mathematical equation that the user wants to create.
5-
For
example, if he wants to divide the number in the field (A2) by the number in
the field (A3), the following equation must be put (A2/A3=).
6-
Press
Enter to calculate the equation and show its result in the specified cell.
Using Functions in Excel Functions
(Functions) in Excel are defined
as pre-existing mathematical equations in Excel, and the following steps
explain how to use a specific function in Excel:
1-
Specify
the cell in which the function result is to be placed.
2-
Click
on the Home tab that appears on the Excel screen.
3-
Click
on the arrow icon next to the AutoSum symbol (Σ), then click on the More
Functions option.
4-
Search
within the associations categories shown on screen for the pairing to be used.
5-
Click
on the OK button.
6-
Specify the group of cells whose contents you
want to apply pairing in the Range field,
7-
within
the association box that appears on the screen.
8-
Clicking
OK to calculate the output of the association.
Save the workbook
After completing his
work via Excel, the user must save the Workbook
that was used, and this can be done by following the following steps:
1-
Click
on the File tab that appears on the Excel screen.
2-
Choose
the Save As option.
3-
Determine where the file is saved on the
user's computer.
4-
Name the new file to be saved.
5-
Click
on the Save button.
Note: After saving the file for the first time,
modifications made to it can be saved continuously by pressing Ctrl + S on the
device keyboard.
Work book printing
The following
steps explain how to print a workbook in Excel:
1-
Click
on the File tab.
2-
Click
on the Print option.
3-
Specify
the printing options that the user wants to use to print the workbook.
.Click on the Print button