Microsoft office Excel

How to find minimum figure. =Min(select the range) then press enter.

  Advanced filtering To filter using search: Searching  for data is a convenient alternative to checking or unchecking data from the list. You can search for data that contains an exact phrase, number, date, or simple fragment. For example, searching for the exact phrase  Saris X-10 Laptop  will display only Saris X-10 laptops. Searching for the word  Saris,  however, will display Saris X-10 laptops and any other Saris equipment, including projectors and digital cameras. 1- From the  Data  tab, click the  Filter  command. 2- Click the  drop-down arrow  in the column you want to filter. In this example, we'll filter the Equipment Detail column to view only a specific brand. 3- Enter the data you want to view in the  Search  box. We'll enter the word  Saris  to find all Saris brand equipment. The search results will appear automatically. 4- Check  the boxes next to the data you want to display. We'll disp...

 What is Vlookup? Vlookup stands for "vertical lookup". It is function that makes excel search for a certain value in a column in order to return a value from a different column in the same row. About the vlookup function: A vlookup function exists of 4 components: 1. The value you want to look up. 2. The range in which you want to find the value and the return value. 3. The number of the column with in your defined range that contains the return value. 4. 0 or false for an exact match with the value you are looking for 1 or true for an approximate match. =Vlookup([value],[range],[column number],[false or true]) Example:- In our example we have a list of fruits, the amount in stock and the current price. We want to find the amount of all fruits quickly in this table.  First put on the cursor where you want to put the amounts: In our selected cell we start put the formula =vlookup(: Then we select the value we want to lookup, in this case it's "fruits" in cell B2...

Control Functions ctrl + -  = Delete Row / Column Menu ctrl + " = Copy above cell values ctrl + ; = Display date ctrl + E = Flash Fill ctrl + Q = Quick Analysis ctrl + ~ = Show formulas/ values ctrl + ,,(apostrophe)  = Copy above formula ctrl + 0 = Hide column ctrl + 1 =  Format Box ctrl + 5 = Strike-through ctrl + 9 = Hide Row ctrl + A = Select All ctrl + B or ctrl + 2 = Bold ctrl + C = Copy ctrl + D = Fill Down (Copy above) ctrl + F = Find ctrl + G or F5 = Go to ctrl + H = Replace ctrl + I or ctrl + 3 = Italic ctrl + k = Insert Hyperlink ctrl + L or ctrl + T = Create Table ctrl + U or ctrl + 4 = Underline ctrl + V = Paste ctrl + W = Close window ctrl + X = Cut ctrl + Y = Repeat/Redo ctrl + Z = Undo ctrl + shift + enter = Enter a formula as an array formula ctrl + Del = Delete text to the end of the line ctrl + End = Go to the last content ctrl + Enter = Fill selection entry ctrl + Alt + V = Paste special box ctrl + Arrow keys = Go to the end of data range ctrl + F1 = Mi...

How to add row and column in data with mouse? First select the row where you want to add row > then press right key in your mouse > then insert automatic add row in your data.  First select the column where you want to add column > then press right key in your mouse > then insert > then click column.  How to add row and column in data with out mouse? First select the row then press ctrl+ then automatic add row in your data. First select the column then press ctrl+ then automatic add column in your data.