Move to first cell in worksheet

In this video, I want to show you how to build a quick summary table using the COUNTIF and SUMIF functions. Here we have a sample set of data that shows t-shirt sales. You can see we have columns for date, item, color, and amount. So let’s break this data down by color. Now, before we start, I want …

In this video, we’re going to cover shortcuts for worksheet navigation. These are shortcuts you can use move quickly around any single worksheet. In this worksheet, we have several thousand rows of data. Let me show you some shortcuts that will help you move around this data quickly. Every Excel …

Once you open one or more Excel workbooks, you’ll need to know how to get around. In this lesson, we’ll look at how to figure out where you are now, and how to get to where you need to go next. Let’s take a look. As you work in Excel, one of the first questions you need to answer is “where am I …

In this video, we’ll look at how to update data in a pivot chart. When you use a pivot chart, it’s important to understand that the chart won’t update by itself when source data is added or modified. To demonstrate this, let me create a new pivot chart using this order data from a small online surf …