How To Use Excel Like a Pro?

excel-1

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

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *