Archive for March, 2009

Excel Tutorials – Microsoft Excel Video Professor

Posted on March 13th, 2009 by Joseph Harris

While compiling videos for the Excel tutorials section of ExcelYogi, I came across Excel Video Professor. After reading about it, I decided to see if it was any good, so I ordered it for free here: Free Video Professor. The shipping was very fast, I ordered the Excel training on a Thursday and received it [...]

Removing Characters from a String in Excel

Posted on March 3rd, 2009 by Joseph Harris

It is often necessary to replace characters within a string in Excel with other characters. Or you may want to remove some characters entirely. There are several ways to do this but by far the easiest method is to use the built-in replace tool. For example, you have the following in a cell: 610-555-2904 You want to [...]

#VALUE! Error in Microsoft Excel

Posted on March 3rd, 2009 by Joseph Harris

The #VALUE error is an error that is seen almost as often as #N/A. In short, the VALUE error occurs when a formula refers to a cell that contains a different than expected format. In this article, I will discuss the main causes of #VALUE! and some possible solutions. The top 3 causes of #VALUE! [...]

Counting Visible Rows After Autofilter in Excel

Posted on March 2nd, 2009 by Joseph Harris

Typically when you use autofilter, the task bar at the bottom of your Excel workbook will say: “5 of 10 records found”. The five is your visible rows. In some situations the records found indicator will not be displayed on the indicator. This can happen when there are many complex formulas in your filtered results. [...]