blogs with Amit

  Seven Basic Excel Formulas For Your Workbook Since you’re now able to insert your preferred formulas and function correctly, let’s check some fundamental Excel functions to get you started. 1. SUM The  SUM function  is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range. =SUM( number1 , [number2], …) Example: =SUM(B2:G2)  – A simple selection that sums the values of a row. =SUM(A2:A8)  – A simple selection that sums the values of a column. =SUM(A2:A7, A9, A12:A15)  – A sophisticated collection that sums values from range A2 to A7, skips A8, adds A9, jumps A10 and A11, then finally adds from A12 to A15. 2. AVERAGE The  AVERAGE function  should remind you of simple averages of data, such as the average number of shareholders in a given shareholding pool. =AVERAGE( number1 , [number2], …) Example: =AVERAGE(B2:B11)  – Shows a simple average, also similar to (SUM(B2:B11)...

  Important shortcut Keys in Excel Hello guys,   Are you data scientist , data analyst  ? Do you want to speed up data entry? So don't worry at all because I am going to tell you very  useful shortcut keys. With the help of which you can greatly increase the speed of your data entry. Here I am telling you about some shortcut keys that can be used in Excel , by using these shortcut keys  you can log any data entry very quickly and easily. so without delay let's start First of all, we will learn the shortcut keys starting with Ctrl +  Ctrl + A = Select All Ctrl + B = Bold Ctrl + C = Copy Ctrl + D = Fill Ctrl + F =  Find Ctrl + G = Find next instance of text Ctrl + H = Replace Ctrl + I = Italic Ctrl + K = Insert a hyperlink Ctrl + N = New workbook Ctrl + O = Open Ctrl + P = Print Ctrl + R = Nothing Right Ctrl + S = Save Ctrl + U = Underlined Ctrl  + V = Paste Ctrl + W = Close Ctrl + X = Cut Ctrl + Y = Repeat Ctrl + Z = Cancel Ctrl + :   = Insert...