Excel tips and tutorials
Do you ever use Google Maps to estimate your travel time? I use it for road trips, and it seems fairly accurate – except at rush hour!
Jeff, from the Jeffrey Fan blog, lives in downtown New York City, and walks to work. He wasn’t satisfied with the accuracy of the walking times that Google estimated, so he built his own estimator in Excel.
You can download Jeff’s sample file, to see how it works.
If you select more than one sheet in a workbook, and start typing or formatting, that data or formatting will be entered in all the selected sheets, not just the active sheet.
Last week, I shared a couple of workarounds for pasting data into a filtered list. Today, see how to paste with shortcut in filtered Excel list.
Continue reading “Paste With Shortcut in Filtered Excel List”
If you’re a parent, have you had that all-important conversation with your children? Or, do you hope that your spouse will have that talk with them, because you’re not sure of the best way to approach it?
Don’t worry, Zach Rosenberg shows how to broach this sensitive topic, in his blog post, “An Open Letter to My Son About Microsoft Excel”.
Continue reading “Excel Roundup 20140428”
It looks like a simple task – filter a list, so you an see the items you’re interested in. Then, copy data from one column, and paste it into another. But you can have a serious problem pasting in Excel filtered list.
Last week, I was preparing reports for a client, and needed to find a quick and easy way to show or hide details in a long list. After a bit of thought, and experimenting, I found a way to do this – without macros.
You could use this technique on a table or pivot table, to make it easier to explore the data. You could also use this technique on an Excel dashboard, where real estate is in high demand!
Continue reading “Hide Table Details With No Macros”
Last week, Microsoft’s Excel team announced several welcome improvements to Excel online. The new feature that I like best is that you can now edit files that contain VBA, without the code being removed or corrupted. Of course, it would be even better to use VBA online, but we’re making progress!
Other new features include:
Do you spend your days, and maybe your nights, talking about Excel with your friends? It’s amazing how quickly the time passes, while you chat about all the awesome features and tricks that you know. You know, exciting things like adding form controls on a worksheet.
While flipping through a magazine on the weekend, I saw this pizza pie chart. The toppings are split down the middle, and that makes it look like a 50-50 vote, not 58-42. It’s a bad pie chart, but we can fix it!
Mike Alexander is having a contest on his Bacon Bits blog – create an Excel meme, and you have a chance to win a couple of Mike’s books. The deadline is April 16th, and the rules are on Mike’s blog.
If you aren’t sure what a meme is, Wikipedia describes it as an idea or picture that is shared on the internet. Mike posted a couple of examples on his blog, and here is my contribution. I’m sure you’ve met someone like this guy!
I made this in Excel, using the Insert Online Pictures command, and the text in WordArt. What can you come up with?
