Expand or collapse ribbon

In this video we’ll look at how to calculate and highlight expiration dates. Let’s say your company has started a membership program of some kind and your boss just sent you a set of data. She’s given you a list of 1,000 people that have renewed a membership in the last year or so, and she’s looking …

In this video, we’ll look at some ways you can apply font formatting to a chart. In this worksheet we have a chart with basic formatting. If you want to apply a certain font, font color, or font size globally to a chart, the fastest way is to use either the home tab on the ribbon, or the Font …

In this video, we’ll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read. Here we have a table with 3 rows of data …

In this video, we’ll look at shortcuts that let you work with the Ribbon. First, because the Ribbon takes up quite a lot of space, you may want to collapse it when you don’t need it. On Windows, use Control + F1. On a Mac, use Command Alt R. Each time you use the shortcut, you’ll toggle the ribbon. …