If you dread going into a crowded greeting card store this weekend, to shop for a Valentine's Day Card – you're in luck! You can make a card in Excel instead, and I'll show you two options.
Time spent in Excel is much more pleasant than time spent shopping, right?
Continue reading Excel Valentine Cards 2016
In this week's roundup, find Excel help, new functions, Excel conferences, and much more.
Continue reading Excel Roundup 20160208
In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you've bought a copy of my Data Validation Multi-Select Premium (DVMSP) kit, it shows a pop-up list when you click on a cell with a drop down list.
I'll show you how to quickly change that, so the pop-up appears when you double-click, and you could make a similar change in other worksheet code.
Continue reading Change Excel VBA Code to Improve Speed
In this week's roundup, formula challenge, better charts, fixing numbers, and much more.
Continue reading Excel Roundup 20160201
If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data can look like numbers, but Excel sometimes sees those numbers as text -- not real numbers.
You can fix the numbers manually, as shown in the video below, or use a macro to automate the fix.
Continue reading How to Fix Excel Numbers That Don't Add Up
In this week's roundup, Data Insights Summit, status bar messages, choose a chart, and much more.
Continue reading Excel Roundup 20160125
If a macro takes a long time to run, it can be frustrating to wait for it to finish. Usually the screen updating is turned off when a macro runs, so it's hard to tell if anything is happening. Maybe it stopped, and you'll be sitting here for the rest of the day, blissfully unaware of the problem.
To help you stay informed, you can show messages in the status bar, to let you know what progress is being made. It sounds like a technical challenge, but it's easy to do.
Continue reading Show Message In Excel Status Bar
In this week's roundup, random numbers, big data, floating forms, chart labels and more.
Continue reading Excel Roundup 20160118
In the olden days (Excel 2003 and earlier), there were toolbars, and you could "float" those, and position them anywhere over the worksheet. You could also create custom toolbars, and add a few commands and macros to those. They could be moved around the worksheet too.
In the newer versions of Excel, those floating toolbars aren't available, but you can create something similar, based on a UserForm. Build your own, or download my example, and customize it.
Continue reading Excel Macro Buttons on Floating Form
In this week's roundup, number formatting trick, pivot chart layout, spreadsheet comedy, and much more.
Continue reading Excel Roundup 20160111