Author: Debra Dalgleish

Excel Combo Box Number Problem 2

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

Excel Roundup http://blog.contextures.com/ 4

Excel Roundup 20170504

There’s always something new and interesting to learn in Excel. In this month’s Excel roundup, you’ll find links to some of the best articles that I’ve read recently, and links to new and updated...

7 Ways to Round in Excel http://blog.contextures.com/ 6

7 Ways to Round in Excel

It’s not usually as obvious as the error in the screen shot below, but have you ever seen Excel adding things up incorrectly? No wonder some people take out a calculator, to check the...