Author: Debra Dalgleish

Excel VLOOKUP Problem Numbers 0

Excel VLOOKUP Problem Numbers

Recently, someone asked me for help with VLOOKUP problem numbers: He had a list of 8-digit numbers. In the next column, there was a formula to get the first 3 numbers: =LEFT(A2,3) Based on...

Form Control Button Quirks 0

Excel Form Control Button Quirks

If you’re building an Excel workbook for other people to use, you can add form control buttons, so it’s easy for them to run macros. One of my sample files has Navigation Buttons on...

Excel Dashboard Course giveaway

Excel Dashboard Course Giveaway

Are you an Excel Dashboard pro? If not, here’s a great opportunity to improve your skills. I’m having a giveaway, and a terrific new Excel dashboard course is the top prize. There are runner...

prevent grouped dates in Excel 2

How to Prevent Grouped Dates in Excel

As a teenager, group dates can be fun. If you have strict parents, that might be the only kind of dates they allow! But, in your Excel worksheets, it can be annoying when dates...

Remove Excel Pivot Fields With Macros 9

Remove Excel Pivot Fields With Macros

If you’re rearranging a complex pivot table, it can take a while to manually remove each field. To make the job easier, you can remove Excel pivot fields with macros. There’s a sample macro...

How to Organize Your Excel Files http://blog.contextures.com/ 2

How to Organize Your Excel Files

Are your Excel files carefully organized, so you can find what you need in a few seconds? Or, are things messy, and it takes a miracle to find anything later? If that’s the case,...