Happy Spreadsheet Day 2016! Spreadsheet Day started in 2010, and we celebrate on October 17th every year, because that’s the date on which VisiCalc was first released, way back in 1979.
After having all kinds of problems on the blog last week, I’ve installed a new theme. Everything looks different, including the header image. It’s a photo that I took on a vacation, and the blues and greens match the Contextures logo.
It was a busy and stressful week, with all kinds of computer fun – plugin updates that killed my blog, a touchpad that refused to turn off, Outlook contacts all disappearing into the iCloud, lots of laptop restarts, and much, much more. Good times!
So, instead of something serious and educational, let’s have an Excel sing-along!
Did you get hit by the disappearing Excel add-in affliction recently? After a long couple of weeks, that frustrating Excel problem is finally solved. After spending countless hours on that issue (details below), I was happy to get back to more productive work, updating my website and sample files. I hope the rest of the summer goes smoothly!
Have you ever copied football scores, such as 3-2, and pasted them into Excel, where they magically change to dates? It’s certainly annoying when a nice list of numbers change to dates in Excel, but fortunately there’s an easy way to prevent that from happening.
In a big Excel file, it’s handy to have hyperlinks that take you from one sheet to another. Maybe you need a table of contents, or a single link on a summary sheet that takes you to a data entry sheet. You can use the Insert Hyperlink command on the Ribbon, but it’s even quicker to create an Excel hyperlink with drag and drop. Here are a couple of ways to do that.
And there are a couple of Excel announcements too.
In this week’s roundup, Data Analysis, Power BI, combining functions, and more Excel tips.
If you’re setting up a workbook for other people to use, they’ll appreciate it if you make it easy to move around in the file. You can create a table of contents on the first sheet, and that will get them off to a good start. But then what?
Once they’re on one of the other sheets, how can they get back to the table of contents, or go directly to a different sheet? We’ll add a drop down list of sheets, to make it easy to go to the one that you need.
Happy Pi Day! In this week’s roundup, troubleshoot large Excel files, free webinars, reporting tips, and much more.
In this week’s roundup, Power Map, Excel formula errors, cell references, and more.