Sometimes, About excel seems too good to be true.
All I have to do is enter a formula, and pretty much anything I'd ever need to
do manually can be done automatically. Need to merge two sheets with similar
data? Excel can do it. Need to do simple math? Excel can do it. Need to combine the information in multiple cells? Excel can do it. Here we will learn much more about excel.
All we need to do is go through from the basics to advanced ones to be an expert in excel.
 |
| Best tips and tricks about Excel |
If you experience a circumstance where you have to physically refresh your information, you're most likely passing up an excel that can do it for you. Before putting in a really long time checking cells or reordering information, search for a convenient solution on Excel - you'll likely discover one.
In the soul of
working all the more proficiently and staying away from dull, manual work, here
are a couple Excel traps to kick you off with how to utilize Excel.
How to use excel - (Step by Step)
If you
are just a beginner learning about excel
then there are a few basic tips mentioned here below:-
- How to create a spreadsheet from scratch
- How to do basic computations such as adding, subtracting, multiplying, and diving into spreadsheets.
- How to delete single columns, rows etc.
- How to add things like new columns and rows.
Create a Spreadsheet:- About Excel
1. First
we have to open a spreadsheet.
2. Now
look at the top in the left corner there are rows and columns A1 and B1.
3. If
you notice then every column has a capital letter to show what column it is.
4. Each
row has a number to show what row it is.
5. Now
we can type something in cell A1 or B1 such as anything.
For Example:-
 |
| Ms Excel |
Now you see here Column A cell has item
and B1 has cost like this we can create any data here by using these cells.
Basic
Computation like adding and subtracting etc. – About Excel
1. Add
– it is like adding numbers all together like it may be sum or count in excel.
 |
| Microsoft Excel |
1. Subtracting
– It is like a number has to be deducted from another number in excel.
 |
| Microsoft Excel |
That’s how we got this value after subtracting here.
Delete columns – About Excel
1. To delete any column, we have to select the column and press the right click
from the mouse and click the delete button which is shown in the small dialogue box.
2. Either
we can delete the column by using the keyboard as well, Press CTRL+(-):- Select the column and press these keys altogether and
will be deleted.
 |
| Microsoft Excel |
3. In
the same way rows also can be deleted anyway.
Adding new columns and rows –
About Excel
1. For
Adding new columns and rows, put the cursor where we want to add a new column or
row and press right-click from the mouse and it will give us the INSERT button to add a new column or row.
That s how we can easily do it.
2
Another way also there to add new columns
and rows, through the keyboard, it can be done too. Press CTRL+(+) altogether for adding a new column or row in excel.
When we talk about basics or advanced of Ms excel then there are a few functions which could be added here from base to top means from basics to advanced like Vlook-up, Pivot-Table, Conditional Formatting, Data Validation, Left & Right function, Sum, Sumif, Sumifs functions, Count, Count, Countif.
Vlookup is basically used for finding a value in any data or huge data vertically. This is the most important function or feature of ms excel that we of course need to learn.
In the same way, we use Hlookup also to find values in any data in excel Horizontally.
The functions we are talking about here are the best features of ms excel which make users like magicians work in excel, Users can easily play with any huge data if he or they know better about at least these functions to use as mentioned above.
Dashboard in excel is an interesting feature which could be used to summarize any huge data in excel.
All we need to do is go through from the basics to advanced ones to be an expert in excel.
