Mynda's Excel Dashboard Webinar

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

May 24, 2016

Hi fellow Excel Addict,

Sorry I'm a little late with my newsletter this week. I'm just back from a weekend at the Halifax Bluenose Marathon. It was a awesome event and a fun weekend shared with a great group of friends.

I completed the 10K run and thankfully my knee didn't cause me any problems as in the past.

Here are a few photos...

Bluenose2016 Francis Hayes Photos

Now I'm looking forward to the next race.

Email Backlog
If you emailed me since last Thursday, sorry, I haven't had time to reply to any emails. I'm just now catching up on things so please bear with me and if you don't get a reply from me within the next week, please feel free to email me again.

Excel in Minutes
In last Thursday's 'Excel in Minutes' tutorial, I showed 'How to Generate Random Numbers and Lists'. If you missed it, you can find it here.

Last Minute Reminder:
Registration for Mynda's Online Excel Dashboard course closes today at 8pm PST (May 26). If you already watched Mynda's Dashboard Webinar, you've seen how easy it is to build interactive dashboard reports that can be updated in just a few seconds. If you missed it, you can watch a replay of the webinar here...but hurry because the course registration closes in just a few hours. You will be joining more than 1,000 other Excel Addict members who have taken Mynda's course. Go here to register>>

If you have a suggestion for a tip you would like me to include in a future newsletter or have a favourite tip that you'd like to share, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)

Francis Hayes ( Quote of the Day

"Whether you think you can or think you can’t, you’re right."

-- Henry Ford --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with

Open the Last-Saved Version of an Open Workbook

Picture this.

You have been working on your spreadsheet when you realize that something is wrong. You have deleted something by mistake or you have messed up some formulas.

If you're like me, you probably haven't saved your changes since you opened the workbook.

What do you do?

Do you try to figure out what you messed up and risk missing something? Or do you close the workbook without saving all those changes you've made and start all over?

Hopefully, you will do neither.

Maybe you would save your spreadsheet with a different name, then open the original workbook to compare data with the one you've been working on.

Not a bad plan. But here's an even better one!

Open Last Saved Copy Of Workbook in Microsoft Excel 2007 2010 2013 2016 365You can easily open a copy of last-saved version of the workbook you currently have open. Here's how...

1) From the File tab (or the Office Button in Excel 2007) click Open. The Open dialog box will appear;

2) Browse to the folder and select the filename of the workbook you want to open a copy of;

3) Click on the small down-arrow on the right side of the Open button;

5) From the menu that appears, click 'Open As Copy'. Excel will open a copy of the last-saved version of the workbook.

You will notice that the filename is the same except Excel adds a prefix, such as "Copy (1)" or "Copy of" to the filename.

Now that you have both files open, you can much more easily compare them see what data you have changed.

Mynda's Excel Dashboard Webinar

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630