Top Excel Formulas You Should Know In 2024

Excel basic formulas are being given in this post for 2024. 

These are the top Excel formulas you should know in the 2024 session.

Although there is no change in the formula, the post written on it will be updated.

You can use this Excel formula list for your office and personal work. 

Many students have to start their careers as accountancy and office assistants. 

There Excel calculation formula is required. 

Memorize these formulas and prepare a notebook. 

The best formula to remember them is to take an Excel test book and use this Excel formula list 2023-24 again and again to solve the questions given in it. 

All Excel formulas with examples in Excel sheets can also be downloaded from the internet. 

The best way to use these formulas is to open a new Excel sheet on your computer and try using them there. 

Through this process, your concept will be clear and your knowledge will improve. 

Some questions are answered here, hope you like them too.

We are covering these three points.

  • Advanced Excel formulas for financial analysis
  • What is the most powerful formula in Excel
  • The most important Excel formulas for finance


Top Ms. Excel Total Formula List 2023-24 - एमएस एक्सेल शॉर्टकट की 

  • SUM: Adds up a range of cells. Example: =SUM(A1:A10)
  • AVERAGE: Calculates the average of a range of cells. Example: =AVERAGE(B1:B5)
  • MAX: Returns the highest value in a range of cells. Example: =MAX(C1:C10)
  • MIN: Returns the lowest value in a range of cells. Example: =MIN(D1:D8)
  • COUNT: Counts the number of cells in a range that contains numbers. Example: =COUNT(E1:E20)
  • COUNTA: Counts the number of cells in a range that is not empty. Example: =COUNTA(F1:F15)
  • COUNTIF: Counts the number of cells in a range that meets a specific criterion. Example: =COUNTIF(G1:G10, ">10")
  • SUMIF: Adds up the cells in a range that meets a specific criterion. Example: =SUMIF(H1:H10, ">50")
  • SUMIFS: Adds up the cells in a range that meet multiple criteria. Example: =SUMIFS(I1:I10, J1:J10, ">50", K1:K10, "<100")
  • AVERAGEIF: Calculates the average of the cells in a range that meet a specific criterion. Example: =AVERAGEIF(L1:L10, ">5")
  • AVERAGEIFS: Calculates the average of the cells in a range that meet multiple criteria. Example: =AVERAGEIFS(M1:M10, N1:N10, ">5", O1:O10, "<10")
  • SUBTOTAL: Calculates a subtotal of a range of cells using a specified function. Example: =SUBTOTAL(9, P1:P20)
  • PRODUCT: Multiplies the values in a range of cells. Example: =PRODUCT(Q1:Q5)
  • MEDIAN: Returns the median value in a range of cells. Example: =MEDIAN(R1:R10)
  • MODE: Returns the most frequently occurring value in a range of cells. Example: =MODE(S1:S15)


Advanced Excel Shortcut Keys And Formulas Pdf - एक्सेल फार्मूला लिस्ट पीडीऍफ़

  • Ctrl + A - Selects all cells in the current worksheet.
  • Ctrl + C - Copies the selected cells or text to the clipboard.
  • Ctrl + V - Pastes the contents of the clipboard into the selected cells.
  • Ctrl + X - Cuts the selected cells or text to the clipboard.
  • Ctrl + Z - Undo the last action.
  • Ctrl + Y - Redo the last action.
  • Ctrl + F - Opens the Find and Replace dialog box.
  • Ctrl + H - Opens the Find and Replace dialog box with the Replace tab selected.
  • Ctrl + S - Saves the current workbook.
  • Ctrl + P - Opens the Print dialog box.
  • Ctrl + B - Applies or removes bold formatting.
  • Ctrl + I - Applies or removes italic formatting.
  • Ctrl + U - Applies or removes underline formatting.
  • Ctrl + K - Inserts a hyperlink.
  • F2 - Edit the active cell.
  • F4 - Repeats the last action.
  • F11 - Creates a chart of the selected cells.
  • Alt + Enter - Inserts a new line in the active cell.
  • Shift + F3 - Opens the Insert Function dialog box.
  • Shift + F11 - Inserts a new worksheet.
  • Ctrl + N - Opens a new workbook.
  • Ctrl + O - Opens an existing workbook.
  • Ctrl + W - Closes the current workbook.
  • Ctrl + F4 - Closes the current workbook window.
  • Ctrl + Tab - Switches to the next workbook window.
  • Ctrl + Shift + Tab - Switches to the previous workbook window.
  • Ctrl + Page Up - Switches to the previous worksheet.
  • Ctrl + Page Down - Switches to the next worksheet.
  • Ctrl + Home - Moves to the beginning of the worksheet.
  • Ctrl + End - Moves to the last cell with data in the worksheet.
  • Alt + = - Inserts a formula summing the selected cells.
  • Alt +; - Inserts the current date in the active cell.
  • Ctrl +; - Inserts the current time in the active cell.
  • F7 - Opens the Spelling dialog box.
  • F9 - Calculates all worksheets in all open workbooks.
  • F12 - Opens the Save As dialog box.
  • Shift + F5 - Displays the Go To dialog box.
  • Shift + F6 - Switches between the worksheet, ribbon, task pane, and Zoom controls.
  • Ctrl + Shift + L - Toggles the filter on and off.
  • Ctrl + Shift + * - Selects the current region around the active cell.
  • Ctrl + Shift + F - Opens the Format Cells dialog box.
  • Ctrl + Shift + ~ - Applies the General number format.
  • Ctrl + Shift + $ - Applies the Currency format.
  • Ctrl + Shift + % - Applies the Percentage format.
  • Ctrl + Shift + ^ - Applies the Exponential number format.
  • Ctrl + Shift + # - Applies the Date format.
  • Ctrl + Shift + @ - Applies the Time format.
  • Ctrl + Shift + & - Applies the Border outline.
  • Ctrl + Shift + _ - Removes the border from the selected cells.
  • Ctrl + Shift + + - Inserts cells, rows, or columns.
  • Ctrl + - - Deletes cells, rows, or columns.
  • Ctrl + Shift + U - Toggles the Formula Bar on and off.
  • Alt + F1 - Inserts a new chart of the current range as a chart object in the current worksheet.
  • Alt + F8 - Opens the Macros dialog box to run or create a macro.
  • Alt + F11 - Opens the Visual Basic Editor.
  • Shift + Arrow Keys - Extends the selection of cells in the direction of the arrow key.
  • Ctrl + Shift + Arrow Keys - Selects the entire region of contiguous cells that contain data.
  • Ctrl + Shift + Enter - Enters an array formula in the selected cells.
  • Ctrl + G - Displays the Go To dialog box.
  • Ctrl + Shift + F3 - Opens the Create Names dialog box.


V Lookup H Lookup In Excel Formula In English

VLOOKUP (Vertical Lookup) - The main function is to "search for a value in the leftmost column of a table & returns a corresponding value from a specified column in the same row".

VLOOKUP(lookup_value, table_range, col_index, [range_lookup])

HLOOKUP (Horizontal Lookup) - The main function is to "search for a value in the top row of a table and returns a corresponding value from a specified row".

HLOOKUP(lookup_value, table_range, row_index, [range_lookup])


How To Use Sum In Excel Formula 

The SUM function - Add up a range of cells or numbers.

SUM(number1, [number2], [number3], ...)

Summing A Range Of Cells-

=SUM(A1:A5)

Summing Individual Values-

=SUM(10, 20, 30, 40)

Mixing Cell References & Values- 

=SUM(A1, B2, C3, 50)


Excel Formula For Percentage Calculation

Percentage of a Total - You can calculate the percentage of a number compared to a total by this formula - 

Formula  = (Number / Total) * 100

(For example - find the percentage of 75 out of a total of 150 then you should be set the value like this - = (75 / 150) * 100 )

Percentage Change - You can calculate the percentage change between two numbers. 

Formula = ((New Value - Old Value) / Old Value) * 100 

(For example - if the old value is 50 and the new value is 70 then use it like this - = ((70 - 50) / 50) * 100 )

Percentage of a Part - You can calculate the percentage that one number represents another number.

The formula is = (Part / Whole) * 100 

(For example - find the percentage of 30 out of a total of 200 then use like this - = (30 / 200) * 100 )

Excel Formula To Count Days From Date To Today In Months

You can use the below-given formula to count the number of months between a specific date and today's date in an Excel sheet.

Formula =DATEDIF([specific date], TODAY(), "M") 

(Like this - =DATEDIF(DATE(2023, 1, 1), TODAY(), "M"))

If you like this post please share it.

Comments

Popular Posts