If you download data into Excel, one column might have a combined date and time value. If you’re going to create reports from that data, it’s usually easier if you have the date and times in separate columns. See how you can do that with a simple formula, or a quick bit of typing.
Author: Debra Dalgleish
Excel Roundup 20160215
In this week’s roundup, Excel skills, make hyperlinks, dashboards, and more.
Excel Valentine Cards 2016
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?
Excel Roundup 20160208
In this week’s roundup, find Excel help, new functions, Excel conferences, and much more.
Change Excel VBA Code to Improve Speed
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.
Excel Roundup 20160201
In this week’s roundup, try the formula challenge, get tips to make better charts, see video steps for fixing numbers, and much more.
How to Fix Excel Numbers That Don’t Add Up
If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data might look like numbers, but Excel might see 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”
Excel Roundup 20160125
In this week’s roundup, Data Insights Summit, status bar messages, choose a chart, and much more.
Show Message In Excel Status Bar
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.
Excel Roundup 20160118
In this week’s roundup, generate random numbers, work with big data, build floating forms, get fancy with chart labels, and more.