Excel Toolbar Tip
August 13, 2019
You'll get my next newsletter in 2 weeks -- we're on the summer schedule now.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Did you know that you can add commands on the Quick Access Toolbar (QAT), and only see them when a specific workbook is open?
For example, if you add lots of comments in your Budget file, put the Insert Comment command on the QAT, for that workbook only. Here are the steps:
The Insert Comment command will only appear on the QAT when the Budget workbook is active.
There's a video on my Contextures site that shows the steps, and more tips for the QAT.
If you have my Excel UserForms for Data Entry (UFDE) kit, there's a new bonus for you --the Search Form Builder add-in. Watch the 2-minute video, to see how it works.
Select a cell in an Excel Table, and the SFB add-in will help you build a quick UserForm, based on that table. Enter criteria in the 2 search boxes, then find and update existing records, or add new records.
To get the latest version of UFDE, use the download link from your original purchase, or email me, if you need a new link.
And if you want to learn how to build an Excel UserForm from scratch, there are free tutorials on my Contextures site.
Here are a couple of Excel articles that you might find useful or interesting.
Dashboards: Mynda Treacy shows how to make impressive interactive dashboards, using built-in Excel features, in her one-hour free webinar. Mynda offers full dashboard courses too - get 20% off if you register by this Thursday, Aug 15th. Click here for Excel Dashboard Course or Power BI Course info.
Excel Uses - If you get tired of doing financial things in Excel, Kat Boogaard shows 21 different uses for Excel. Number 6 is my old seating plan workbook, and there's a newer version now. (Level - All)
Data Viz: The Science Goddess built an amazing display of student data, with "stars" in "constellations". This could inspire you to find new ways to present your data in Excel. (Level - All)
If you ever went to summer camp, you probably made something with popsicle sticks. My granddaughter and I found instructions for a popsicle stick abacus, and had lots of fun making one. It was a bit tricky to put it together, without all of the beads getting stuck in the glue, but we succeeded! Now we just have to learn how to use it.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190813ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: August 10, 2019 5:19 PM