ُEXB0001 Starting excel tutorial from scratch

How to start working with Microsoft Excel? 

If you are new to Microsoft Excel, then it is the right place to start...

lets go

Excel file is called a workbook , each book is consisting of sheets , each sheet contains a matrix of boxes called Cells.

each cell is an intersection of  column and a row, and the cell's name is decided based on that intersection

for example, if the located in Column "A" and row "5",

then the cell name is A5

--------------------------------------------

Each cell in excel has what I can call a dual nature, each cell contains an inside "formula" and outside output "result". the default for the cell to present its result , you can still able to see the excel formula inside the cell either by double clicking the cell (or F2) ,or go to the formula bar (usually located on the top of the screen with [𝑓x] sign).

For example:

Cell  A1 could have the value 5 , but if you look to the formula bar , it shows =3+2 in it.

that would give us a hint of our next step which is:

How to make a formula in Excel?

Just go to the desired cell and start your formula by the equal sign (=) and continue your equation.

It goes like the formula we just did it, you can also modify it to any mathematical operation as long as you know the signs in Excel ( usually is the same like outside excel  , and if you are familiar with the computer world or have a programming background, you would definitely know them), for example:

• Addition         +
• Subtraction      -
• Multiplication   *
• Division         /
• Power            ^

Now you can make any arithmetic equation .

Quiz 1:

Go to any cell in excel and compute the following : 10 plus 2 to the power of 8 multiplied by 9 minus 5 and what is the result.

*******************************

*******************************

Quiz 1 answer:

the formula:

=10+2^8*9-5

the result:

2309

Note carefully :

Computer are computing the multiplication and division operations first , then compute addition and subtraction

for example : 

in the above quiz if we want the computer (or excel) to compute adding 10 and 2^8 first we should put them between brackets to make sure that they are computed separately, the formula will be like this:

=(10+2^8)*9-5

that would give another result:

2389

to be continued...