Excel tips and tutorials
In a previous article, Roger Govier showed us a couple of different ways to get a Unique count with a Pivot Table.
Now Roger has added another technique that you can use, in Excel 2013 and later. First, I’ll show the steps in a video, and then I’ll hand things over to Roger, so he can describe the steps.
In this week’s roundup, Slicer trick, pivot charts, slow workbooks, dashboards, and more.
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.
In this week’s roundup, Excel skills, make hyperlinks, dashboards, and more.
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?
In this week’s roundup, find Excel help, new functions, Excel conferences, and much more.
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.
In this week’s roundup, try the formula challenge, get tips to make better charts, see video steps for fixing numbers, and much more.
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”
In this week’s roundup, Data Insights Summit, status bar messages, choose a chart, and much more.