Add non-adjacent cells to selection

In this video, we’ll look at the options available in Table slicers. Table slicers have a variety of settings. To access these settings, select a slicer and click “Options” under the Slicer Tools menu in the ribbon. Options appear grouped in 5 main categories Name and settings Slicer styles Commands …

In this video, we’ll look at how to add and remove data series in a chart. Once you have a chart, you may want to add or remove data series. If all data series are in contiguous cells, it’s easy to just select the chart, and drag the data range selectors to include or exclude cells as needed. …

In this lesson we’ll look at how to apply the basic styles of bold, italic, and underlining. All of these styles can be applied individually or together. Let’s take a look. Let’s pick up where we left off and work with the drink size headings in our sample coffee menu. Holding down the Control key, …

Excel provides both single and double underlining. It also provides a special variant of each for numbers using the Accounting format. Let’s take a look. For most basic underlining, you can just use the Underline button on the ribbon. The Underline button toggles underlining on and off. It also …

In this video, we’ll look at how to filter larger sets of data in a table with filters applied. When plotting unsummarized data, the chart filter may not be convenient. For example, here we have historical stock data for Microsoft covering more than 15 years in more than 100 rows of data. If I …

Excel has a great feature that allows you to find all cells that meet your find criteria in one step. Let’s take a look. When using the Find and Replace dialog box in Excel, there are actually two options for finding matches: Find Next, which we’ve already covered, and Find All. The Find All button …

In this video, we’ll look at how to add a slicer to a pivot chart. Slicers provide a powerful way to filter data interactively, and they are a key building block of many dashboards. To filter a chart with a slicer, you can add a slicer to either the chart or pivot table. Once you do that, the slicer …

In this video, we’ll look at how to chart average daylight hours for each month of the year, using sunrise and sunset data. This is the final chart. This project has a couple of interesting challenges. First let’s look at the available data. You can see we have data for both sunrise and sunset. Both …

In this lesson, we’ll look at how to select entire rows and columns. Selecting columns and rows is handy when you want to move information around, delete information, or when you want to copy a row or column. Let’s take a look. To select a column in Excel, just click the letter in the column …

In this video we’ll take a quick look at the information provided by the status bar. The status bar at the bottom of the Excel window provides real-time data about currently selected cells and can give you a lot of good information without the need to write any formulas. Here we have test score data …