A shortcut is a combination of keys that you press to perform a task in a program. Shortcuts can save you a lot of time, especially when you are working with large documents.
In Microsoft Excel, there are many shortcuts that you can use to perform common tasks. For example, you can use the shortcut Ctrl+C to copy text, and then use the shortcut Ctrl+V to paste it in another location. You can also use shortcuts to navigate through your document, such as Ctrl+Home to go to the beginning of your document, and Ctrl+End to go to the end of your document.
Here are some of the most commonly used shortcut keys in Microsoft Excel:
Workbook shortcuts:
Ctrl + N: Create a new workbook
Ctrl + O: Open an existing workbook
Ctrl + S: Save a workbook
Ctrl + W: Close the current workbook
Ctrl + F4: Close Excel
Navigation shortcuts:
Home: Move to the beginning of the line
End: Move to the end of the line
Ctrl + Home: Move to cell A1
Ctrl + End: Move to the last cell with data
Page Up: Move up one screen
Page Down: Move down one screen
Alt + Tab: Switch between open applications
Selection shortcuts:
Ctrl + A: Select all
Shift + Spacebar: Select a row
Ctrl + Spacebar: Select a column
Ctrl + Shift + Arrows: Select a range of cells
Editing shortcuts:
Enter: Move to the next cell below
Shift + Enter: Move to the next cell above
Ctrl + Enter: Enter a formula in all selected cells
F2: Edit the active cell
Ctrl + Z: Undo the last action
Ctrl + Y: Redo the last action
Formatting shortcuts:
Ctrl + B: Bold
Ctrl + I: Italic
Ctrl + U: Underline
Ctrl + 1: Format cells
Alt + H + 0: Increase decimal places
Alt + H + 9: Decrease decimal places
Formula shortcuts:
Alt + =: Insert the SUM function
Ctrl + Shift + Enter: Enter a formula in multiple cells
F4: Repeat the last action
Other shortcuts:
Esc: Cancel the current action
Shift + F10: Open the context menu
Alt + F1: Open the Help window
These are just a few of the many shortcut keys available in Excel. For a complete list, you can refer to the Microsoft Excel Keyboard Shortcuts: https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f documentation.
All Formulas of MS Excel
Microsoft Excel is a powerful spreadsheet software that offers a wide range of formulas to perform various calculations and data manipulations. Here are some commonly used formulas in Excel:
1. SUM: Adds up the values in a range of cells.
Syntax: =SUM(cell_range)
2. AVERAGE: Calculates the average of a range of cells.
Syntax: =AVERAGE(cell_range)
3. COUNT: Counts the number of cells that contain numeric values in a range.
Syntax: =COUNT(cell_range)
4. MAX: Returns the highest value in a range of cells.
Syntax: =MAX(cell_range)
5. MIN: Returns the lowest value in a range of cells.
Syntax: =MIN(cell_range)
6. IF: Performs a logical test and returns one value if the test is true and another value if the test is false.
Syntax: =IF(logical_test, value_if_true, value_if_false)
7. VLOOKUP: Searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.
Syntax: =VLOOKUP(lookup_value, table_range, column_index, range_lookup)
8. HLOOKUP: Searches for a value in the top row of a table and returns a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_range, row_index, range_lookup)
9. CONCATENATE: Joins two or more text strings into one string.
Syntax: =CONCATENATE(text1, text2, …)
10. LEFT: Returns the leftmost characters from a text string.
Syntax: =LEFT(text, num_characters)
11. RIGHT: Returns the rightmost characters from a text string.
Syntax: =RIGHT(text, num_characters)
12. MID: Returns a specific number of characters from a text string, starting at a specified position.
Syntax: =MID(text, start_position, num_characters)
13. COUNTIF: Counts the number of cells that meet a specific condition.
Syntax: =COUNTIF(range, criteria)
14. SUMIF: Adds the cells that meet a specific condition.
Syntax: =SUMIF(range, criteria, [sum_range])
15. AVERAGEIF: Calculates the average of the cells that meet a specific condition.
Syntax: =AVERAGEIF(range, criteria, [average_range])
These are just a few examples of the formulas available in Excel. Excel has many more functions that can be used for a wide range of calculations and data analysis tasks.
Excel Formula for Percentage
To calculate percentages in Excel, you can use the following formulas:
1. Percentage of Total:
To calculate the percentage of a value in relation to a total, you can use the formula:
Syntax: = (Value / Total) * 100
For example, if you have a total sales value in cell A1 and you want to calculate the percentage of sales represented by a specific value in cell B1, you can use the formula:
= (B1 / A1) * 100
2. Percentage Change:
To calculate the percentage change between two values, you can use the formula:
Syntax: = ((New Value – Old Value) / Old Value) * 100
For example, if you have the old value in cell A1 and the new value in cell B1, you can use the formula:
= ((B1 – A1) / A1) * 100
3. Percentage of a Number:
To calculate a percentage of a specific number, you can use the formula:
Syntax: = (Percentage / 100) * Number
For example, if you want to calculate 20% of a value in cell A1, you can use the formula:
= (20 / 100) * A1
4. Percentage Difference:
To calculate the percentage difference between two values, you can use the formula:
Syntax: = ((New Value – Old Value) / ((Old Value + New Value) / 2)) * 100
For example, if you have the old value in cell A1 and the new value in cell B1, you can use the formula:
= ((B1 – A1) / ((A1 + B1) / 2)) * 100
These formulas can be modified based on your specific requirements and the layout of your data. Remember to adjust the cell references accordingly in the formulas to match your data setup.
Excel Formula for subtraction
In Excel, you can subtract numbers using the subtraction operator (-) or the SUBTRACT function. Here’s how you can perform subtraction in Excel:
1. Subtraction Operator:
To subtract numbers directly in Excel, you can use the subtraction operator (-) between the numbers or cell references.
Syntax: =Number1 – Number2
For example, to subtract the value in cell A1 from the value in cell B1, you can use the formula:
=B1 – A1
2. SUBTRACT Function:
The SUBTRACT function is an alternative way to subtract numbers in Excel. It can be useful when you want to subtract numbers based on certain conditions.
Syntax: =SUBTRACT(Number1, Number2)
For example, if you have values in cells A1 and B1, and you want to subtract them using the SUBTRACT function, you can use the formula:
=SUBTRACT(A1, B1)
Both the subtraction operator and the SUBTRACT function perform the same subtraction operation. You can choose the method that suits your needs and the context in which you’re working in Excel.
Excel Formula for age calculation
To calculate the age based on a given date of birth in Excel, you can use the following formula:
Syntax: =DATEDIF(start_date, end_date, “y”)
In this formula, the “start_date” is the date of birth, and the “end_date” is the current date or any other date you want to calculate the age until. The “y” argument specifies that you want the result in years.
Here’s an example to calculate the age based on a date of birth in cell A1 and the current date:
=DATEDIF(A1, TODAY(), “y”)
This formula calculates the number of full years between the date of birth and the current date.
Note that the DATEDIF function is a hidden function in Excel, so it won’t appear in the list of functions when you use the formula auto-complete feature. However, you can still manually type it or copy it into your Excel worksheet.
Also, make sure that the date of birth in cell A1 is formatted as a date value in Excel. You can apply a date format to the cell by selecting it and choosing a date format from the formatting options.