Microsoft Excel is the most powerful tool for managing and analyzing various types of data. So Postsline in this article will give you tips for beginner may help you learn the basics of Excel.
This Tips beginners covers in-depth lessons to learn Excel and how to use various Excel formulas, tables, and charts to manage small to large business operations as follow:
- Data formatting in Microsoft Excel
- How do you perform calculations in an excel sheet?
Data formatting in Microsoft Excel
You have to learn how to format the data you enter in excel sheet because it makes our spreadsheets more attractive.
Here are the most important tips and basic steps that you must use in coordination:
- Enclose Data in Borders
- Align Data to the Left, center and right
- Make Column Names Bold, italic and underline
- Increase or decrease your font size
1.Enclose data in borders
As shown in the picture to make your data within a frame, follow the following steps
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the border command as described above.
Step 3: Select All Borders command from the menu.
After you finish you must find that your data enclosed in borders.
2. Align Data to the Left, center and right
As shown in the picture to align your data to the left, center and right, follow the following steps:
A. If you want align your data to the (Left)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Align Left command as described above.
B. If you want align your data to the (Right)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Align Right command as described above.
C. If you want align your data to the (Center)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Center command as described above.
D. If you want align your data to the (Top)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Top Align command as described above.
E. If you want align your data to the (Bottom)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Bottom Align command as described above.
F. If you want align your data to the (Middle)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the Select Middle Align command as described above.
3. Make Column Names Bold, italic and underline
As shown in the picture to make the column names bold, italic and underline, follow the following steps:
A. If you want make the column names (Bold)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the B command as described above.
B. If you want make the column names (Italic)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the I command as described above.
C. If you want make the column names (Underline)
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the U command as described above.
Note:
- if you want to make 2 lines under your data select D From the same command.
4. Increase or decrease your font size
As shown in increase or decrease your font size, follow the following steps:
A. If you want (Increase) your font size
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the A big one command as described above.
B. If you want (Decrease) your font size
Step 1: Mark all columns and rows with the data in which the data is located.
Step 2: In the line bar bar, click on the A Small one command as described above.
Note :
- You can increase or decrease the font size as you wish by clicking on the command each time the font increases or decreases more.
How do you perform calculations in an excel sheet?
When performing calculations in Excel, you should always start with the equal (=) sign.
We are going to perform basic arithmetic operations i.e. addition, subtraction, division and multiplication as following:
1. Addition
If you want to calculate numbers within two or more digits inside the excel sheet easily, as in the following example.
Let's say you want to calculate the sum of the following numbers
Example : (1+2+3) Here are the steps:
In the beginning, select the field in which you want to show the result, then perform the following steps
Step 1: Type ( = )
Step 2: (Click on the 1st digit)
Step 3: (Type ( + ) and Click on the 2nd digit)
Step 4: (Type ( + ) and Click on the 3rd digit)
Step 5: : Press enter key to find the result.
Note:
- You can use the same method for any number of fields within the excel sheet.
- If you change any number from within the specified cells, the final result will change accordingly.
2. Subtraction
If you want to subtract numbers within two or more digits within the excel sheet easily, as in the following example.
Let's say you want to subtract the following numbers
Example : (9-4 ) Here are the steps:
In the beginning, select the field in which you want to show the result, then perform the following steps
Step 1: Type ( = )
Step 2: (Click on the 1st digit)
Step 3: (Type ( - ) and Click on the 2nd digit)
Step 4: Press enter key to find the result.
Note:
- You can use the same method for any number of fields within the excel sheet.
- If you change any number from within the specified cells, the final result will change accordingly.
3. Multiplication
Let's say you want to multiply the following numbers
Example : (9*4 ) Here are the steps:
In the beginning, select the field in which you want to show the result, then perform the following steps
Step 1: Type ( = )
Step 2: (Click on the 1st digit)
Step 3: (Type ( * ) and Click on the 2nd digit)
Step 4: Press enter key to find the result.
Note:
- You can use the same method for any number of fields within the excel sheet.
- If you change any number from within the specified cells, the final result will change accordingly.
4. Division
If you want to divide numbers within two or more digits within the excel sheet easily, as in the following example
Let's say you want to divide the following numbers
Example : (9/3 ) Here are the steps:
In the beginning, select the field in which you want to show the result, then perform the following steps
Step 1: Type ( = )
Step 2: (Click on the 1st digit)
Step 3: (Type ( / ) and Click on the 2nd digit)
Step 4: Press enter key to find the result.
Note:
- You can use the same method for any number of fields within the excel sheet.
- If you change any number from within the specified cells, the final result will change accordingly.