October 13, 2015
Hi Excel Addicts,
This week, in addition to my 'Excel in Seconds' tip, I have an extra bonus for you.
Starting today, you will have access to two free Excel Dashboards Webinars. Mynda Treacy is hosting these webinars and will be running them multiple times over the next 7 days, so you can find a date and time that fits your schedule.
If you have already watched Mynda's dashboard Webinar in the past, you can skip down to today's tip.
Webinar 1 is for anyone who creates reports in Excel. It will show you how to use Excel to build an interactive dashboard (as shown in the image link below. Click on it to see a larger image), with no additional software or add-ins required...just plain old Excel and some data. This is available for Excel 2007/2010/2013/2016 users.
Webinar 2 is for more advanced Excel users. It will showcase how you can use Power Query to get data from multiple sources, mash it up with Power Pivot and analyze it in PivotTables to create an interactive Excel Dashboard (as shown in the image link below. Click on it to see a larger image). This webinar is for Excel 2010/2013/2016 users.
If you are not familiar with Excel Dashboard Reporting, what you will learn here can literally change the way you and your company use Excel to prepare reports.
If you missed Mynda's webinar back in July, you won't want to miss out on this one. Once you discover how quickly and easily dashboard reports can be updated and refreshed, Excel reporting as you know it will never be the same. Can you imagine updating your Excel reports in less than a minute?
And Dashboard Reporting is not just about updating your reports faster. Mynda's dashboard webinar will teach you how to design better, more effective dashboard reports that are much easier for end users to interpret.
Even if your job doesn't require you to create dashboard reports in Excel, just watching one or both of these webinars will teach you dozens of new tips and tricks that you can use in your everyday Excel work.
Comment from past webinar participant: "Most webinars are thinly veiled info-mercials lacking worthwhile content. This webinar contained tips and helpful information that I can actually use right now. Thank you!" -Granville
You can even download the Excel workbooks that Mynda uses in the webinar containing the completed dashboards so you can see how they work.
Why am I promoting Mynda's Excel Dashboards course?
Although I have been using Excel for more than 20 years, honestly, I don't know everything. I can't possibly cover every aspect of Excel in my newsletter, so to help you expand your Excel skills even further, I will occasionally be recommending some outside sources that I consider to be 'first class'. Mynda's dashboard course is one of them.
I have known Mynda and her husband Phil for more than two years and have found them to be honest, dedicated and meticulous Excel trainers whose main goal is to give you the best possible training to enhance your skills. They guarantee your satisfaction and so do I.
To date, almost 1000 Excel Addict members have taken Mynda's course and I have heard nothing but high praise for both them and the dashboard course.
To see for yourself why Excel Dashboard Reporting skills are in such high demand, go here to sign up for the Dashboards Webinar.
If you decide to enroll in Mynda's full Dashboards Course, you can save 20% off until October 22. Also, use EXCELADDICT for your coupon code at the Checkout and you will qualify for my exclusive BONUS, which I will be telling you more about later this week.
Enjoy the rest of your week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
You can access even more tips on my website by going to my members' page.
Here's What To Do When Row 1 Is Missing
As you know, hiding and unhiding rows in Excel is simple as selecting them, right-clicking and choosing Hide or Unhide. The trick to selecting hidden rows, is to select a row above or below and then drag to included the hidden rows.
What's not so apparent, however, is how to unhide hidden rows if they are above the first visible row in your worksheet.
For example, if you accidentally hide row 1 of your worksheet or inherit someone else's worksheet with one or more of the top rows hidden, you may be wondering how to unhide them since apparently you cannot select them.
Fortunately, there is a really easy solution.
1) Point to the row 2 header, press the left mouse button and drag upward to the top of the worksheet. Although you cannot see it, row 2 and row 1 are now selected;
2) Right click anywhere on row 2;
3) Choose Unhide from the right-click menu.
NOTE This also works for multiple hidden rows.
What if that doesn't work?
You may come across a situation where the top several rows of a worksheet appear to be hidden but the solution above doesn't unhide them. In that case, the problem isn't that the rows are hidden. It is more likely that one of the Freeze Panes options has been enabled.
Solution: From the View tab click Freeze Panes. If the Unfreeze Panes option is available, click it to make your rows visible again.
To see this for yourself, try this...
1) Open a new workbook;
2) Scroll down so that the first few rows are no longer visible at the top of the worksheet;
3) From the View tab click, Freeze Panes, Freeze Top Row;
4) Now scroll back up and you'll see that the top rows appear to be hidden;
5) To make them visible again, from the View tab click Freeze Panes, Unfreeze Panes .
| 'Spreadsheets Tips
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