Looking for more? Try chatting with the Exceljet Chatbot.

Keyboard shortcut

Hide pivot table item

This shortcut is the same as filtering a pivot table field to exclude an item in the field. Check the filter afterwards to confirm how the shortcut works.Read more

Video

How to make a self-contained pivot table

Each pivot table has a pivot cache, which is a true copy of the source data. In this video, we look at how the pivot cache works, and how it allows you to remove the source data from your workbook and still have a functional pivot table.Read more
Video

How to group a pivot table by day of week

If you've used pivot tables at all, you understand the addictive power they give you for grouping dated information. You can group by year, by month, by quarter, and even by day and hour. But if you want to group by something like day of week, you'll need to do a little prep work first...Read more
Video

How to use the format painter

Although the formatting tools in Excel are easy to use, applying formatting manually can quickly get tedious. In this video I'll show you how to use a tool called the Format Painter to speed up manual formatting...Read more
Video

How to clone a pivot table

Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to base one pivot table on another...Read more
Video

How to calculate years and months between dates

In this video we'll look at how to calculate the number of years or months between dates using a function called DATEDIF and a function called YEARFRAC. The DATEDIF function is a "compatibility" function that originated from Lotus 1-2-3. ...Read more
Video

How to create date and time series with formulas

Although you can use Excel's AutoFill feature to fill in a series of dates and times, you can also do the same thing with formulas. The advantage of using a formula is that you can easily change the starting value and generate a new series...Read more
Video

How to work with times

In this video we'll look at functions that will let you extract the hour, minute, and second values from a time, as well as a function called TIME that will let you put them together again...Read more
Video

How to trap errors in formulas

Trapping errors can make your spreadsheets more professional by making them less cluttered and more friendly to use. In this video, we'll look at some ways to trap errors in a formula...Read more
Video

Excel formula error codes

In this video, we'll walk through each of the error codes that Excel displays when there's something wrong with a formula. We'll also look at some simple ways to resolve the errors...Read more
Video

How to set formula error checking options

When you use Excel frequently, you're likely to see a number of potential errors flagged on the worksheet as you work. In this video, we'll review the error checking options for formulas in Excel. ...Read more
Video

How to trace a formula error

It can sometimes be difficult to know what is causing formula errors. In this video, we'll look at how to track down the source of a formula error in Excel...Read more

Pages