MrExcel Excel Videos

Isabel asks how to count only the visible entries in a range. =COUNTA() is returning all of the values. Episode 1034 will show you how to count or sum the visible rows in a range. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to add a couple of user-defined functions to your personal macro workbook to simplify the conversion of date to Fiscal Quarter or Fiscal Year. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Stuart from the UK asks: say that you have columns B through H hidden and want to unhide only one of those columns? Episode 449 will take a look at the process of hiding and unhiding columns. Although I had never tried it before Stuart posed the question, it seems that there is a way to unhide just that one column. 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!

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!