Hello Everyone,

My name is Shirish  Upadhyay. I m here to teach Some Excel Skills that will help you for daily office routine.

Microsoft Excel

                       Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Android & iOS(MacBook ie Apple). It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of Microsoft Office.

Every Organisation need excel for maintaining records, calculation & to do the same work every day.

For eg. every day I have to find out what is my expenses 

Transport	50
Food	80
Extra Exp	40
Mobile Recharge	100

  ie.
https://docs.google.com/spreadsheets/d/1Rl0mfXUg_loFG0MOgyP4A3rf3AARDJ7SGanqR82QkEo/edit?usp=sharing

now, this only 4 items but in the organization, there are many more expenses if you want to calculate that you can use excel formula i.e SUM.

SUM is very Basic Formula For Excel.

I am  here to explain you about LOOKUP

LOOKUP

               when you need to look in a single row or column and find a value from the same position in a second row or column.

There are two types of lookup 

VLOOKUP  Vertical lookup

HLOOKUP Horizontal lookup

Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.

to add formula D13
            =VLOOKUP(D12,B2:E10,2,O)

1st step:   D12 because we have to find the marks for sultan
2nd step:  B2:E10 the information is within this data
3rd step:   We have to find the marks for hindi as 2 nd step we have selected from B2 to E10
        hindi was 2 column that's why we have to select 2 if you want marks for maths we have type
          3 instead of 2

Thanks for reading this if you like and want to learn more please contact me my mail id is shirishupadhyay186@gmail.com

Please share as much as you can and give feedback.