Home Function (shortcut Keys)

shortcut keys are the most importnat in excel by using the shortcut keys we can make speed in excel and To work in excel will be very easy to use so these are some shortcut keys.

1. Auto Sum                         Alt + (Apply this formula in that cell where you want to sum)



2. one to another page         Ctrl  page up ( Press these two key ctrl and page up for the next page and
                                                Ctrl page down for previous page) for excel sheet


3. one sheet to another         Atl  tab (Press these two key it will help to go in another sheet)


4. select the whole Row       Shift and space (Press the Shift and Space key Together)


6.  Find                                  Ctrl F


7. close the whole sheet         Alt F4


8. Minimize the Excel sheet      Window M(Press the Window key and then M)

9. Go at the top                            Ctrl and upper arrow

10. Go at the bottom                   Ctrl and down arrow

11. Apply Bordre                       Alt H B A(press these key one after one)

12. Remove Border                   Alt H B N

13. Merge cell                            Alt H M M

14. Unmerge cell                        Alt H M U

15. Increse font Size                  Alt H F S( Then set the Size of Font)

16. Wrap Text                           Alt H W( It is use when We want a name in one cell) eg - Aditya                                                          Singh negi we want this name in one cell then We will use this key

17. Insert Cell                        Alt H I I(Then Enter)

18. Preview file                        Ctrl F2

19. Minimize Excelsheet          Ctrl F9

20.Fill Color in Cell                 Alt HH (Then Select the color)

21. Duplicate                            ctrl D

22. Freez Row                         Alt then W then F then R (for the Row)

23. Freez Column                   Alt then W then F then C (For the column)

24. Freez Row and column     Alt then W Then F then F (to Freez the row and column)

Frequency

               Frequency formula

We use this formula when we have to sapparate the data in Interval. Using this formula we can saprate the data into the part.
for Example we hav a data of the student weight and we have to find that how many student have weight is 0-15 and how many have 15-50 and how many have 50-100

=frequency(select data , then select interval )  Data_ array   = Select the range of weight(Kg)  bins_ array    = Weight interval column First of all select the whole that is highted with red color in that cell we will apply the formula of frequency. (=frequency(select data , then select interval ) then press the three key together (ctrl shift enter) here is the link https://drive.google.com/drive/my-drive

use of Sumif

 USE OF SUMIF

This is the Fantastic formula of excel and this formula is use for when we have the data in bulk and we have to find out the sum of the same product

For example-  We have a data and we have to find that how much Quantity sold of one product.

So Here is the Example.

Range required. The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. For Example The Column of Product as Shown in Example.

Criteria required. Criteria is that select the product that you want to sum.

 As shown in the Example select the Mango

    sum range: The actual cells to add, if you want to add cells other than those specified in the range argument. For Example the column of Quantity.

If you want to find that all prroct how much Quantity has been Sold so just Copy the 
Formula in another Cell you will get the how much Quantity of another produch Sold.