Excel Workbook Tips
April 7, 2020
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Here's a quick tip that might help when you're working with multiple versions of an Excel workbook. For example:
To prevent accidental changes to the older versions:
For more details, see my blog post, How to Spot the Old Excel File
Related Post: Tips for Organizing Your Excel Files
If you're an Excel power user, with lots of calculation-intensive workbooks, the tools in Charles Williams' FastExcel add-in can help you speed things up. These tools help you manage your Excel files, and find and fix calculation problems, to make your workbooks smaller and faster.
There are more details, and a short FastExcel demo video on my Contextures site, so take a look, if your workbooks are pushing the limits of Excel.
Discount: Purchase FastExcel V4 Bundle by April 15, 2020, and use coupon code FXLV4INTRO to get a 40% discount.
If you're sheltered at home, and only allowed out to get essential items, like we are, it's helpful to keep track of what supplies you have on hand. I've updated my Excel weekly meal planner, by adding new columns to enter inventory information.
Then, when I choose the meals for next week, I can base my choices on what's in the cupboard. And, when we do go shopping for essentials, the shopping list shows what we need in the recipes, and what we already have at home.
Here are a few Excel-related articles that you might find useful or interesting.
Collaborate: If you're working from home, Ed Bott explains how to get the free version of Microsoft Teams, so you can have real-time collaboration on your Excel files, while working from home. (Level-All)
Dashboards: Robert Mundigl shows how to use table Slicers on an Excel dashboard, with a simple example file to download. You can download the fancy dashboard workbook too, to see how it works. (Level-Int/Adv)
Excel Humour: See what people said about Excel recently. Do you have any Excel confessions that you'd like to share?
The local schools are closed until at least May 4th, so our grandkids are being home schooled for now. My granddaughter and I are doing a couple of FaceTime art sessions each week, and that's going well. Here's the toilet paper roll owl that she made in our first class, which was lots of fun, errr educational!
This week, I'll start helping my grandson with FaceTime math classes, and that will be fun too. Maybe we can work Excel into some of the lessons!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200407ctx.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: April 7, 2020 11:47 AM