Microsoft Excel has many powerful tricks which when used correctly can help speed and improve business calculations. This short how to guide will help you get off your feet and running with Microsoft Excel.
Often times, people place data in a cell and the want to “copy” and “paste” it to another cell. Hotkeys or shortcut keys (full list of shortcut keys) can help you get that done quicker.
For example, clicking on the contents of the cell “January” and clicking ctrl (PC) / command (Mac) and the “C” key will copy the contents of the cell, “January” (Figure 1).
Clicking in the contents of another empty cell and clicking ctrl and the “V” key will paste the contents from the copied cell in to the currently selected empty cell (Figure 2).
Instead of copying the contents of a cell to another location, there may be situations where you would like to move the contents of one cell to another location without leaving it in the original location.
Using figure 2, click on the cell containing “March”. Click ctrl (PC) / command (Mac) and the “X” key to cut. Then select the cell to the right of the “January” cell that we pasted in the last example. To paste, like before, click ctrl (PC) / command (Mac) and the “V” key (Figure 3).
When creating lists in Excel, if the list follows are particular pattern, you can take advantage of Excel’s auto-expand feature to finish creating the list for you.
For example, if you want to create a list of all of the months in a year, instead of typing each month individually:
Excel can finish number patterns as well. Populate your cells with the values 1, 2, and 3 (figure 5 below), then the same technique that was used to expand the months above, can can be used on the cells containing 1, 2, and 3 in figure 5 to achieve what is shown in figure 6.
Using a basic Excel function, we can find the sum of a group of data. In excel, using the “Home” tab under “Editing“, there is a function called AutoSum. Click on an empty cell where you would like the sum to appear, click the AutoSum function, highlight the cells that would like to sum together and click the Enter / Return key. The sum of the group of cells you highlighted will appear (figure 7).