How To Use Excel Like a Pro?
Excel is an amazing software program that is created by Microsoft to handle, manage and organize numbers and data with formulas and functions.
Learning Basics of Excel:
If you are a beginner at Excel and want to do all the basic stuff, you have to follow these instructions. The instructions are as follows:
To create a new spreadsheet in Excel:
- Click on ‘File’ then ‘New.’
- Double-click on a template
- Click and start typing in the template
- For the shortcut, use ‘Ctrl+N’ to create a workbook in Excel
Check Fix Apple TV’s Black Screen with Sound Error
Using the autofill feature:
- Select the cells of the workbook
- Locate the fill handle in the lower-right corner of the cell
- Drag it to the handle to cover cells that you want to be filled
Adding rows and columns:
- Highlight the pre-existing rows or columns
- Right-click and select ‘Insert.’
Transposing rows into columns:
- Highlight the column that you want to transpose into a row.
- Right-click on it and select ‘Copy.’
- Right-click on the cell and select ‘Paste Special.’
- Tick the box and select ‘OK.
Using formulas for calculations:
If you have created a workbook in which you have to do calculations and use formulas, then you need to follow these steps to get it done:
- Use ‘+’ for the addition
- Use ‘-’ for the subtraction
- For multiplying, you can use ‘*’ for it
- To divide the sum, use the ‘/’ sign
Using these formulas will let you do calculations in a quicker way. Also, you can do all of these together by using different formulas. For instance, (C2-D3)/((A4+B7)*3).
Check How To Manage Google Docs?
Using functions in Excel:
Excel has pre-installed functions that do your tasks in a more efficient way. You won’t have to use typical formulas for the calculations. The instructions for functions are as follows:
- SUM: The SUM function adds up the range numbers of cells automatically. To do a sum, you have to put a starting cell with the final cell with a colon in between them.
For example: SUM (Cell1:Cell2) = SUM (C5:C10)
- AVERAGE: This function puts out the average of the values of a range of cells. You have to use the AVERAGE feature, like the SUM function.
For example: AVERAGE (Cell1:Cell2) = AVERAGE (C3:C25)
- IF: The IF function lets you return values based on a logical test. It is as follows: IF (logical_test_value_if_true, [value_if_false])
For example: IF (A2>B2, ‘Over Budget,’ ‘OK’)
You can use these shortcuts and functions to get your work done quickly.
Check iPhone 15