However, it’s possible for you to also remove data by deleting columns, rows, or cells. Let’s take a look. One way to remove data in Excel is to use the Clear button on the home ribbon. Choose “Clear Contents” to clear just the contents. Choose “Clear All” to clear both the contents and the formatting. A faster way to clear content is to use the delete key. Just choose the cells you’d like to delete, then press the delete key....
You may often want to enter a current date and time into a worksheet. A simple way to do this is to enter a time or date stamp. you’re free to do this using keyboard shortcuts. Control semicolon enters the current date. Control-Shift semicolon enters the current time. Note that the date has no time component, and the current time has no date component. However, cell D9 has both. I refer to these as date and time stamps because the values won’t change....
Here we have a list of salespeople with monthly sales figures. To do this, we’ll use theINDEXandMATCHfunctions. First, I’llname some rangesto make the formulas easier to read. Notice that I’m including the first empty cell in both names. That’s because it’s easier to use the same origin for both the data and the labels. Finally, I’ll name the months; again, I’ll include the first cell. Now we have three ranges....
This is a handy way to quickly change things like dates, prices, and times without using formulas. Let’s take a look. Here we have some examples of information we want to change. In the first example, we want to increase prices by 10%. Obviously, we could just add a new formula that multiplies the existing price times 1.1 in another column. Then use Paste Special to paste over the original prices....
Abstract Transcript Excel provides another method for creating borders around cells. Let’s take a look. To draw a border, first select a color and a line style. In draw border mode, you’re free to draw a border along any gridline. We can use this flexibility to draw an irregular border. Now let’s look at the second border drawing mode, Draw Border Grid. In this mode, Excel will create both outside and inside borders at the same time....
Pivot tables have an interesting feature that allows you to do just that. Let’s take a look. Here we have a pivot table that contains product sales organized by year and city. But what if you want to see the data behind that number? For example, suppose you want to see the data behind the Boston 2012 number of 5,395. In this case, we have 68 entries for sales in Boston for 2012....
Abstract Transcript
Editing a formula in Excel is similar to editing other content. One difference is that you’re able to update cell references usingdrag and drop. Let’s take a look. Here we have a worksheet with some incorrect formulas. Let’s check these formulas against the instructions to understand what’s wrong. An easy way to check a formula is to double-nudge the cell. To get back out of edit mode without making changes, just press Escape....
Let’s take a look. After you’ve created a chart, you normally don’t need to worry about updating the chart manually. you’re free to verify that Calculation is set to automatic on the Formulas toolbar. Just click Calculation Options and confirm that Automatic is checked. For this chart, the source values are in the range B7:C11. If we edit any values in this range, the chart is automatically updated. That’s because the chart’s reference to the source data is static and doesn’t expand automatically....
Let’s take a look. If you want to replace information, just select a cell and start typing. Then key in enter or tab to confirm. The contents of the cell will be completely replaced by the new information. Then bang out enter or tab to confirm the change. Another way to edit content already in a cell is to press the F2 key. Like double-clicking, this brings the cursor into the cell where you could make changes....
Abstract Transcript To enter a formula that contains cell references, you have two choices. Let’s take a look. For example, we can throw in the formula “=B7+D6” directly. Notice that you don’t need to worry about case. When Excel sees a valid reference, it will automatically convert the reference to upper case. Excel has a nice way of showing you what cells are being referenced in a formula. Start by typing the formula normally, and click to add references as you go....
Then, select those cells, and drag the fill handle to repeat the pattern. Let’s take a look. The fill handle works in both directions. When we drag up, it repeats the pattern backwards. you’re free to also create a repeatable pattern by combining text and numbers. Custom patterns work with dates as well.
In future lessons, we’ll look at a number of shortcuts for entering data faster. To enter data in Excel, just select a cell and begin typing. You’ll see the text appear both in the cell and in the formula bar above. To tell Excel to accept the data you’ve typed, press enter. The information will be entered immediately, and the cursor will move down one cell. you could also press the tab key instead of the enter key....
