All Excel Shortcut Keys & How to Use Excel Formulas
by Ricebowl Team
Jan 25, 2023
at 3:42 PM
For working adults, Excel is something that you cannot run away from if you want to work more effectively and perform any data analysis and presentation. It can also become a nightmare for anybody since the operation of Excel is just so complicated, and many excel shortcut keys and formulas can be involved. Today we will share some excel tips and shortcut keys that can help you smoothen your excel journey.
What is Excel?
Excel is a spreadsheet software program developed by Microsoft for Windows and Mac. It organizes, analyses, and manipulates data in a tabular format. With Excel, you can create spreadsheets, perform calculations, create charts and graphs, and much more. It is widely used in business, finance, and various other industries for budgeting, data analysis, and record keeping. Excel offers a wide range of features, including the ability to create and edit spreadsheets, perform calculations using formulas, and create charts and graphs to visualize data. It also offers advanced features such as macros, pivot tables, and data validation.
Excel shortcuts keys list:
Ctrl + A: Select all cells in the worksheet
Ctrl + B: Bold selected text
Ctrl + C: Copy selected text or cells
Ctrl + D: Fill down
Ctrl + F: Find and replace
Ctrl + G: Go to a specific cell or range
Ctrl + I: Italicize selected text
Ctrl + K: Insert hyperlink
Ctrl + N: Create a new workbook
Ctrl + O: Open a new workbook
Ctrl + P: Print the current worksheet
Ctrl + R: Fill right
Ctrl + S: Save the current workbook
Ctrl + U: Underline selected text
Ctrl + V: Paste copied text or cells
Ctrl + W: Close the current workbook
Ctrl + X: Cut selected text or cells
Ctrl + Y: Redo
Ctrl + Z: Undo
Ctrl + Shift + : Enter the current time
Ctrl + ; Enter the current date
Ctrl + Shift + L: Apply or remove filters
Ctrl + Shift + T: Create or delete a table
Ctrl + Shift + &: Apply borders to selected cells
Ctrl + Shift + _: Remove borders from selected cells
How to use Excel formulas?
Excel formulas are used to perform calculations and manipulate data in a spreadsheet. Here is a general overview of how to use formulas in Excel:
Select the cell where you want to enter the formula.
Type an equal sign (=) to begin the formula.
Enter the formula using the appropriate functions, operators, and cell references.
Press Enter to complete the formula and calculate the result.
For example, to find the sum of values in cells A1 through A5, you would select cell A6, type =SUM(A1:A5), and press Enter. The result of the calculation, the sum of values in cells A1 through A5, would appear in cell A6.
You can also use cell references in formulas, which allow you to refer to a specific cell or range of cells in the formula. For example, if you wanted to multiply the value in cell A1 by the value in cell B1, you would enter the formula =A1*B1 in a cell.
It's also possible to use multiple formulas in one cell by nesting the formulas. You can nest formulas by placing one formula inside another.
For example, to calculate the total cost of an item, you would use the formula =(A1B1)+C1. In this formula, A1B1 calculates the cost of the item, and C1 is the shipping cost. The final formula adds the cost of the item and the shipping cost to give you the total cost.
It's important to note that Excel formulas are case-insensitive, and that the results of formulas can be affected by the format of the cells being referenced.
Excel has a lot of built-in functions, and more can be added with add-ins. You can learn more about them by searching online for excel formula guide and tutorials.
Excel Formulas List:
SUM: Sums the values in a range of cells
COUNT: Counts the number of cells in a range that contain numbers
AVERAGE: Calculates the average of the values in a range of cells
MAX: Returns the largest value in a range of cells
MIN: Returns the smallest value in a range of cells
IF: Tests a condition and returns one value if the condition is true and another value if the condition is false
VLOOKUP: Looks up a value in a table and returns a corresponding value from a specified column
INDEX-MATCH: A combination of INDEX and MATCH functions that allows you to look up a value in a table and return a corresponding value from a specified column.
Above are just a few of the most commonly used Excel shortcut keys and formulas. There are many more that you can learn to help you work more efficiently in Excel. The more you use these shortcut keys, the more comfortable you will become with them, and the more quickly you will be able to complete your tasks.
In conclusion, Excel is a powerful tool, and learning its shortcut keys can make you more efficient and effective at using it. We hope this article has helped you understand some of the most important Excel shortcut keys, and that you will start incorporating them into your workflow. Happy Excel-ing!
