MS – Excel is a spreadsheet program that one can use to calculate, record, and analyze numerical digits or calculations. It provides you with multiple features to perform various functions and formulas, such as adding some data or making graphs and calculating or keeping a record of data.
https://www.youtube.com/embed/DTbSep6RdPM?feature=oembed
What a Caption: Love it or Hate it, But you need it
What is MS – Excel?
Basically, MS – Excel is a spreadsheet consist of collections of columns of fixed arear where you can type alphabets or any digits. The point where the column and a row meet are called a cell. The name or address of the cell is represented by the letter representing the column and row by a number.
Uses of MS – Excel for kids
Through MS – Excel, students can learn how to convert normal data or raw data into meaningful data or information. Moreover, it makes the calculation much faster, and that would save them a lot of time. Further, they will also be able to understand the analyses of the data. They would learn how to plan and execute data at their convenience. Furthermore, they can keep track of their goal by keeping data.
Here are some important MS – Excel tools for beginners –
- Menu bar – It contains a menu that organizes tools.
- Toolbar – A collection of tools displayed in a long bar. Each icon here has a new and different command which do different things.
- Formula bar – It contains a tool for creating and editing formulas. It displays the content of the active cell. The cell location also appears in the bar. It consists of cell names and boxes.
- Cell editor – It displays the content of an active cell, and you can it by typing new information.
- Cell– The intersection of row and column
- Column heading – The letter across the top of the worksheet, through which columns are used identified
- Row heading – Numbers at the left of the worksheet which tells the number of worksheets
- Status bar – Display information about the selected bar
- Worksheet tab – Individual worksheet in the workbook where one types and anayses data.
Basis MS-Excel formulas and functions
MS excel functions allow you to carry out many things such as addition, substation, division, calculating percentage, division, and many more. By using the correct formula, you can use them to find each one of them. For example, =B1+B2+B3+B4+B5 finds the sum of the range of values from cell B1 to cell B5.
- Excel Functions: You can use certain functions to carry out specific calculations in the specific order as per your convinces. For example =SUM(B1:B10). You can use this formula to add up all the values of B1 through B10.
- Date– You can use it to write data by using this formula=DATE(year, month, day). This formula will tell the date corresponding to the data entered in the parentheses, including values referred to from other cells.
- Trim– You can use this formula to remove the spaces in the cell before or after the text is written in them by using this formula=TRIM(text).
- Len– This function in MS – Excel lets you count the number of characters written in a specific cell. Further, it also let you know the number of characters in the cell by using this formula=LEN(text). Len counts all characters, including spaces.
Basic formulas
- Sum formula is used to calculate or to add the given data. You can add as much data as you want by using some formula. To use it, just enter the values you want to add. Write together in this format=SUM(value 1, value 2, and so on)
- Subtraction formula is used to subtract the cell you want to by using this formula. SUM(A1-B1) and so on, which you want to subtract.
- Multiplication formula– is used to multiply the data by using the formula=A3*B3
- Division formula– is used to divide the data, enter the dividing cells in the format =A3/B3. This formula divides the value in cell A3 by the value in the cell B3.
- Average formula– is used to find the average is typing the formula AVERAGE=(A3.B3, C3……) and in the end, press enters, and it will calculate the average of the data that you have entered.
- IF formula– is used to let you enter a text value into a cell if something else in your spreadsheet is true or false. You can use this formula =IF(logical test, value if true, value if false).
- Percentage formula– enter the cell whose percentage you want to know in this format=A1/B1. To convert decimal into a percentage, you have to select the particular cell which you want, then click the Home tab, and then you have to select ‘PERCRNTAGE’ from the number dropdown.
- Concatenate formula– is a very common and useful function in MS excel. You can use it to combine the values from multiple cells into one cell.
https://www.youtube.com/embed/rwbho0CgEAE?feature=oembedBeginner’s Guide
Here is the list of some basic navigation keys
- One cell up or down or left or right – one cell
- Up to one screen – page up
- Down one screen – page down
- Left one screen – alt + page up
- Right one screen – alt key+ page down
- To the edge of worksheet – control key + relevant arrow key
- Edit selected cell – F2 key
- Repeat your last action – F4 key
- To a particular cell – F5 key then type the reference for the cell required and press return
- To column A in a current row – home key
- Create new workbook – control key+ N
- To cell A1 – control key+ home
- Open help box – F1 key
- Go to specific cell – F5 key
- Open new file – control key+ F12
- Insert a chart – alt key+F1
Parting Words from Podium
MS – Excel is one of the best products of Microsoft company which help you to keep the record of data and much more. It helps your kid to excel not in just one aspect but in each and every aspect. Now you are ready with the basics, it’s time for you to explore and master MS excel. Therefore, wishing you luck!
Share with your friends
