Posted on March 16th, 2009 by Joseph Harris
The question we are asked most often by ExcelYogi readers is how can I use vlookup with multiple criteria or conditions. There are several solutions but some can be pain staking and unrealistic. Knowing that the Excel world is missing this feature, Excel Yogi has created a VLookup addin that will extend the built in [...]
Posted on March 13th, 2009 by Joseph Harris
There are many times when you may have a lot of data that does not look right when graphed all together. 300 data points is probably too many for a small chart. So what is the solution…scrolling charts! I will show you in this article how to create a scrolling chart without using dynamic ranges. [...]
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 on [...]
Posted on February 26th, 2009 by Joseph Harris
Microsoft has issued a security advisory regarding possible vulnerabilities in Microsoft Excel 2007. According to Microsoft, a vulnerability in Excel 2007 could allow remote code execution which could in turn allow a remote user to gain the user rights of the system owner.
The attack appears to primarily be happening when an attacker host a website that [...]
Posted on February 16th, 2009 by Joseph Harris
One of the most time consuming parts of producing a scheduled report is updating all of the charts in the report. Many times, an analyst only wants to show the last 7 days or the last 6 months of data and not the entire data set. To achieve this, the analyst changes the the Y [...]
Posted on January 6th, 2009 by Joseph Harris
Finding and displaying the percentile of specific results can be valuable to your audience. Sometimes stand alone numbers do not tell the story, but, if I know that 80% of the other results are lower than me, that tells a more complete story…
