Video
How to find and replace a value
In this video we'll look at how to replace what you've found. Find and replace is a powerful tool when making global changes to worksheets...Read more
Search results
Looking for more? Try chatting with the Exceljet Chatbot.
Video
What is a pivot table?
In this video, we introduce you to the pivot table and explain why pivot tables are useful.Read more
Video
How to quickly create a pivot table
In this video, we show you how to make a pivot table fast.Read more
Video
How to refresh data in a pivot table
In this video, we show you how to update the data that flows through a pivot table using the refresh command.Read more
Video
How to drill down into a pivot table
In this video, we show you how to drill down into pivot table summaries to see the data used to create totals and subtotals.Read more
Video
Why you should use a table for your pivot table
In this video, we show you how and why to use a table as a data source for your pivot table.Read more
Video
How to add fields to a pivot table
In this video, we show you how to add fields and start building out your pivot table.Read more
Video
How to rearrange fields in a pivot table
In this video, we show you how to move fields around in your pivot table.Read more
Video
How to access field settings in a pivot table
In this video, we show you how to get to the field settings dialog box, the key to controlling fields.Read more
Video
How to format numbers in a pivot table
In this video, we show you how to format value fields with number formatting, something you'll do often...Read more
Video
How to change the math used for pivot table values
In this video, we show you how to change the math used for value fields.Read more
Video
How to control grand totals in a pivot table
In this video, we show you how to enable and disable the Grand Totals that appear in a pivot table.Read more
Video
How to control subtotals in a pivot table
In this video, we show you how to enable and disable the subtotals that appear in pivot tables.Read more
Video
How to rename fields in a pivot table
In this video, we show you how to rename fields in your pivot table, to tidy things up.Read more
Video
How to add a field to a pivot table more than once
In this video, we show you how to add the same value field to your pivot table more than one time. Surprisingly useful.Read more
Video
How to group a pivot table manually
In this video, we show you how to drag items manually into your own groups.Read more
Video
How to group a pivot table by numbers
In this video, we show you how to automatically group numbers in a pivot table.Read more
Video
How to group a pivot table by date
In this video, we show you how to automatically group dates in a pivot table.Read more
Video
How to collapse and expand pivot table groups
In this video, we show you how to expand and collapse groups in a pivot table.Read more
Video
How to sort a pivot table by value
In this video, we show you how to sort items in your pivot table by value.Read more
Video
How to sort a pivot table manually
In this video, we show you how to sort your pivot table manually by dragging items around.Read more
Video
How to sort a pivot table with a custom list
In this video, we show you how to use a custom list to sort your pivot table in a custom sequence.Read more
Video
How to use Pivot table slicer options
In this video, we explain the most important slicer settings.Read more
Video
How to use pivot table slicer styles
In this video, we show you how to create and use your own slicer styles.Read more
Video
How to add a calculated field to a pivot table
In this video, we show you how to add a calculated field to a pivot table, and explain why you might want to do that.Read more
Video
How to modify a calculated field in a pivot table
In this video, we show you how to make changes to calculated fields you've added to your pivot table...Read more
Video
How to modify a calculated item in a pivot table
In this video, we show you how to make changes to calculated items you've added to your pivot table...Read more
Video
How to apply a pivot table style
In this video, we show you how to apply pivot table styles to your pivot table.Read more
Video
How to create a new pivot table style
In this video, we show you how to make your own pivot table style and apply it to a pivot table.Read more
Video
How to move a pivot table style to another file
In this video, we show you how to move a pivot table style from one workbook to another.Read more