Contextures Blog Excel Tips and Tutorials

Pop Up Selector Tool Demo 7

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 0

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...

Excel Combo Box Number Problem 3

Excel Combo Box Number Problem

Let’s file today’s blog’s post under “Obscure Excel Problems”.  I heard from Y.B., who was using my Data Validation Combo Box, and numbers were being entered as text. The code is supposed to fix...

Split Address With Formulas in Excel http://blog.contextures.com/ 0

Split Address With Excel Formulas

If a cell contains a full address, what formulas would you use to show the street address, city, state and zip code in separate cells? That was the challenge that I gave to my...

Excel Skills for Specialists http://blog.contextures.com/archives/2017/06/01/excel-skills-for-specialists/ 5

Excel Skills for Specialists

What are the key Excel skills for specialists in your profession? Are there specific functions or features that you use all the time? If someone wanted to improve their Excel skills to prepare for...

Compare Weekdays in Fiscal Year Summary http://blog.contextures.com/ 0

Compare Weekdays in Fiscal Year Summary

In the retail businesses, some days of the week are busier than others. So, if you’re looking at year over year sales, it’s not too helpful to compare sales for a specific calendar date,...