Select active cell only

In this video, we’ll cover shortcuts for working with the active cell. As I mentioned earlier, every worksheet has an “active cell”, which you can see displayed in the name box. When the active cell is off-screen, you can scroll it into view, without actually changing the active cell, using Control …

In this video, we’ll plot American generations in a chart with floating bars. In this worksheet we have a list of six generations. Each generation has a start year and end year, which represent birth years. How can we plot these generations in an easy-to-read bar chart? This seems like a simple …

In this video we’ll look at how you can use the CHOOSE function. Let’s look at three examples. In this first example we have some items listed with a numeric color code. We want to bring these names into column D. Now, since I already have a table here, I could just use VLOOKUP and reference the …

In this video I’ll demonstrate how you can use VLOOKUP to join data in separate tables. In this worksheet we have two tables. In the first table, we have order data. You can see that we’ve got a date, customer id, product, and total. In a second sheet we have customer data. We’ve got first and last …