With Excel comments, you can put a quick note in a cell, to explain a cell's value. A new type of comment is coming to Excel soon, and here is a warning, before you make the switch.
Welcome to the new home of my Contextures Excel Blog! It used to be part of my main Excel site, but the blog needed more room. I had a long "to do" list for the blog move, and Excel made it easy to cross off tasks when I finished them.
Spring has finally arrived, so here is a "Goodbye Winter" Excel Roundup, with articles that I've read recently, and upcoming Excel events and free online courses that I've heard about. To get Excel links and articles every week, sign up for my weekly Excel newsletter.
Happy Spreadsheet Day 2017! You've been waiting all year for this special day to arrive, I'm sure, so what will you do to celebrate today?
While clearing some of the boxes in the basement, I found a stack of old MacUser and MacWorld magazines. A couple of issues had articles on early versions of Excel (it started on the Mac) , so that was a good excuse to stop working, and flip through the magazines. I wasn't resting, I was researching! Here are some pro tips from Excel 1.0, and a review of the exciting new features in Excel 2.2.
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.