MrExcel Excel Videos

Another popular way for people to lie with charts is to use a cone or pyramid chart. Episode 448 shows why your radar should go up anytime you see someone presenting data using these chart types. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the books!

Here is a bizarre problem sent in by a viewer. Many of you will think that you know the answer, but this problem is not as simple as it appears. In a worksheet, any dates are instantly converted to their 5 digit serial number. The actual date is shown in the formula bar, but the worksheet cells show the underlying serial number. Yes my first thought was that someone had formatted the worksheet using a Number format, but this is not the problem. Hint: this is a simple spreadsheet set up to log information, and there is not a single formula anywhere in the worksheet. Episode 447 solves the mystery. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one...

Watch out when someone tips a pie chart backwards to show a 3-D perspective. They are either unintentionally or intentionally trying to misrepresent the data. Episode 446 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every workday to learn one of the 277 tips from the book!

A question from Mike in Oklahoma City. Excel is supposed to copy only the visible rows in a dataset where AutoFilter is turned on. However, sometimes this does not work. Episode 445 shows the simple shortcut to make sure that you have only the visible rows. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

In a recent charting challenge, Jerome Sullivan sent in an interesting chart where the budget and actual numbers were actually plotted on top of each other. Episode 444 shows the non-intuitive steps required to create this type of chart. This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every workday to learn one of the 277 tips from the book!

If you have inherited a computer where someone has customized your toolbars, you might want to go back to the default, out-of-the-box set of toolbars. Episode 443 will show you how to reset your standard toolbar, the formatting toolbar, and your worksheet menu bar to undo any rogue customizations. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

How to create a combination chart that includes both stacked columns and a line chart. Episode 442 shows you how. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Eric from Shanghai writes in with a question about adding a Paste Formulas icon to the standard toolbar in Excel. While Excel only offers custom buttons for Paste Values and Paste Formats, Episode 441 will help you discover how to get a Paste Formulas icon on your toolbar. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Excel 2007 does offer a number of improvements in the AutoFilter arena. Episode 440 shows the new virtual date filters, such as selecting records from this week, next month, or last quarter. This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!