Let’s take a look. By default, Excel charts will automatically move and resize when cells underneath them change. The same is true of rows. If we increase or decrease row heights, the chart automatically expands and contracts. you’ve got the option to control this behavior by adjusting the chart’s position property. tap the Format Selection button on the Chart Tools Layout tab. This will initiate the Format Chart Area dialog box....
It’s just going to take way too long. Well, there is. You just have to learn the keyboard shortcut. Let’s take a look. In fact, this list is over 30,000 rows. Control-up arrow, right back to the topdoesn’t take any time at all. I like to think of this as like “riding the slide.” It’s important to understand what will happen if your list has blanks in it. Press Control-down arrow again, now we go to the bottom....
The most common way to move information is to use cut and paste. Let’s take a look. When you cut content, notice that Excel doesn’t immediately remove the content. Instead, the cut data is highlighted by a moving dashed linesometimes called “marching ants.” This indicates that the cut information is on the clipboard and ready to move to a new location. Control-x to cut; control-v to paste. you might also right-mouse click to cut and paste....
We’ll also look at how to change the color of worksheet tabs. Let’s take a look. The easiest way to rename a worksheet is to double-click its name. This will highlight the text of the name, and then you might jot down a new name. Press enter to confirm the change. you’re free to also right-press a worksheet and choose Rename from the menu. As before, Excel will highlight the text and you might key in a new name....
Let’s take a look. In this case, we can see that we’re in a workbook called Forecast 2013. The current worksheet is always the tab that’s highlighted at the bottom. Control page-up moves left in the worksheet tabs, control page-down moves right. When you move to a new worksheet, you may or may not be able to see the cursor. However, Excel will always display the current location of the cursor as an address in the name box....
In this worksheet, we have the first 10 letters in the alphabet in the range B5:B14. How can we sort this data in random order? One way to do this is to add a helper column and useRAND functionto generate random values. Then we can use theSORT functionto sort data by the helper column. This works, but it clutters up the worksheet. The trick is to use the new RANDARRAY function to generate the random values we need for sorting....
Abstract Transcript Have you ever had to go for the winners in a contest? In this video we’ll show you a simple way to do it using theRAND function. Here’s a list of names that represent entries in a contest. Suppose we’d like to pick five winners. In a real drawing, we’d pick five random names out of a hat. But how do we do that in Excel? And if you eventually picked all 100 names out of the hat, each person would have a number....
Here we have data from a survey we ran recently. Let’s plot the data in a chart. The first step is to build a summary table. First, I’ll convert the data to an Excel table. This step is not required, but it will make the formulas easier to write. For the first formula, I need to count all responses. Since we have a table, I can use the ROWS function with the table name....
Abstract Transcript Excel provides a lot of great tools for working with data. One of those tools is Sort. In this lesson we’ll look at how to quickly sort a list or table using a single column. Let’s take a look. We’ll look at custom sorting in an upcoming lesson. The descending quick sort button works just the opposite. Just click anywhere in a column you’d like to sort, and click a quick sort button....
Abstract Transcript Creating apivot tableis easy. Let’s take a look. Before you create a pivot table, verify your source data is in good shape. Rows and columns need to be consecutive. If you have any blank rows or columns in the data, remove them first. Next, see to it that each column has a unique label in the first row. These labels will appear in the field list once the pivot table has been created....
Even better, Excel does all the hard work for you. Let’s take a look. Here we have a really big list that contains a lot of empty rows. Sure, we could just work our way through the list, deleting these empty rows one by one. But that will take a really long time, and it won’t be any fun at all. So let’s look at a really fast way to do it using Excel’s Go To Special command....
Let’s take a look. Here’s our big list. We want to remove all of the rows that don’t have a Last login date. We could just work our way through the list, deleting those empty rows one by one. Let’s look at a really fast way to do it using Excel’s Go To Special command. To start off, pick the entire “Last login” column. Then check that you are on the Home tab of the ribbon....
Here we have a list of 36 people. This is a great way to solve more complicated problems in Excel. I’ll start with anExcel Table, to make the formulas very fast to enter. Then, I’ll add columns for Rand, Rank, Grouping, and Team number. The purpose of each column will become clear as we go along. Next, I’ll use theRAND functionto get a random number for each person. RAND generates small numbers between 0 and 1....
