Contextures Blog Excel Tips and Tutorials

Quick Trick to Add or Move Pivot Table Fields 0

Quick Trick to Add or Move Pivot Table Fields

We’re still recovering from Tuesday’s Spreadsheet Day celebrations, so we’ll keep it simple today. Here’s a quick trick to add or move pivot table fields, just by typing. Watch the really short video, and...

Happy Spreadsheet Day 2017 0

Happy Spreadsheet Day 2017

Happy Spreadsheet Day 2017! You’ve been waiting all year for this special day to arrive, I’m sure, so what will you do to celebrate today?

Multiple Copies of Pivot Table 0

Multiple Copies of Pivot Table Sheet

If you need to make a quick report, Excel has a built-in command that makes multiple copies of pivot table – one for each item in a Report Filter. See how that feature works,...

Excel Hyperlinks Run Command 1

Excel Hyperlinks Run Command Files

You can use Excel hyperlinks to navigate through a workbook, go to web pages, open other Excel files, and even open PDF files. However, if you try to use an Excel hyperlink to run...

early versions of Excel 3

Looking Back at Early Versions of Excel

While clearing some of the boxes in the basement, I found a stack of old MacUser and MacWorld magazines. A couple of issues had articles on early versions of Excel (it started on the...

Pop Up Selector Tool Demo 8

Excel Pop Up Selector Tool With Slicer

Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet. To get the benefits of a Slicer, without the real estate cost, AlexJ made...

Learn More About Power BI 1

Learn More About Power BI and Excel

If you’ve been using Excel since the Stone Age (like me!), you might be avoiding Power Query, Power BI, and all those other “Power-y” tools that the kids are using now. However, those tools...

QAT and Excel Ribbon Customizations 5

Save Your Excel Ribbon Customizations

The Quick Access Toolbar (QAT) is at the top of the Excel window, and comes with a few default commands installed. See how to customize the QAT, use shortcuts to run the commands, and...