The Quick Access Toolbar (QAT) is at the top of the Excel window, and comes with a few default commands installed. See how to customize the QAT, use shortcuts to run the commands, and how to save the QAT changes, so you can use them again later.
What are the key Excel skills for specialists in your profession? Are there specific functions or features that you use all the time? If someone wanted to improve their Excel skills to prepare for a job in your area, what would you tell them?
In this month's Excel roundup, you'll find links to a few of the interesting articles that I've read recently, and links to new or updated Excel resources. Shortcuts, favourite functions, a sing-along, and many more tips.
There's always something new and interesting to learn in Excel. Here are some of the articles that I've read recently, and links to new and updated Excel resources.
Are your Excel files carefully organized, so you can find what you need in a few seconds? Or, are things messy, and it takes a miracle to find anything later? If that’s the case, here are a few tips on how to organize your Excel files.
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.