Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.
With the editing commands, you can work on your worksheet to add formulas, fill in blanks or erase them, or sort and filter a data list or search for content in your workbook.
The first function in the Editing section is AutoSum. Apart from the Sum function, you will see a list of the most recently used functions and access to all of the other functions (as shown in the image to the right). To access even more functions, select More Functions at the bottom of the list. This action will open the Insert Function dialog box. You will be able to search for the function you need from the list of all the functions Excel can provide.
To show how some of these functions work, we are going to utilize the Semi-annual Expenses worksheet shown in the Styles and Cells tutorials. Select cells A1 through G13, and then select AutoSum.
As shown in the image below, there is now a sum of each column shown in Row 14.
Similarly, the next function shown, Average, is obtained by taking the same steps. Highlight cells A1 through G13, and then select Average from the AutoSum drop-down menu. The average of each column will be placed in Row 14. Take the opportunity to try some of the other functions within the menu.
Excel 2010 offers an Autofill option you can use to fill cells with predetermined lists or from a range of values. As shown in the image to the left, you can Fill cells down, right, up and left.
In this example, we will type the word January into cell A1, and then highlight cells A1 through A12. Select Fill from the Editing section of the Home tab. From the drop-down menu, select Down.
January is auto filled from A1 to A12, as shown in the image to the left.
This is useful when you need to input a word repetitively throughout many cells. You can also quickly input January through December by using auto fill.
Start by typing January into cell A1. Place your cursor over the bottom, black square of cell A1. Click on it and drag down to A12.
Now we have January through December in column A and only had to type the word January.
In addition to months, Microsoft Excel’s auto filling allows you to easily use your mouse to fill in days of the week, dates and counting.
Formatting is a great way to make certain information stands out in your Excel worksheet; however, there are times when improper or excessive formatting can have the opposite effect – making your Excel document difficult to read. The easiest way to fix this is to remove all current formatting and start embellishing the worksheet from scratch.
To remove all formatting in Excel 2010, first select the cell or range of cells from which you want to clear formatting. On the Home tab, in the Editing section, click the arrow next to the Clear button. This will erase all cell formatting (including conditional formatting, number formats, fonts, colors, borders and etc.) but keep the cell contents.
Here is a short explanation of the other options you have in the Clear button drop-down menu:
· Clear All – Clear everything from the selected cells including all contents, formatting and contents.
· Clear Contents – Clear only the contents in the selected cells.
· Clear Comments – Clear any comments that are attached to the selected cells.
· Clear Hyperlinks – Clear the hyperlinks from the selected cells.
The Sort & Filter feature allows you to arrange data so that it is easier to analyze. You can sort your selected data in ascending or descending order, or you can temporarily filter out specific values.
We will use the simple Excel worksheet to the right to give examples of arranging your data.
Start by selecting cells A3 through A13. On the Home tab, in the Editing section, click the Sort & Filter button. From the drop-down menu select Sort Oldest to Newest.
As shown in the image to the left, the rows are now sorted by date – earliest to most recent.
Another way to sort this table is by Region. You can group each region together by selecting the Sort & Filter button and clicking on Sort A to Z from the drop-down menu.
To sort the expenses largest to smallest, select Sort & Filter and then Sort Largest to Smallest.
If you have an especially large amount of data in a worksheet, the Find & Select button in the Editing section can be useful.
If you are looking for specific content, select Find from the Find & Select drop-down menu shown to the right. The Find and Replace dialog box will appear. Type in the contents you are searching for and select Find All.
The Go To option will navigate to a specific place within the document.
To find a formula, comment, conditional formatting, constants or data validation, choose the corresponding option from the Find & Select drop down menu.
This concludes the Page Layout tab tutorial.
Click next to continue to the Excel 2010 Formulas Tab tutorial.