Archive for the ‘Business Analyst’ Category

How to Import XML Data into Excel

Posted on January 2nd, 2012 by Joseph Harris

This article is a quick primer on using XML data in your workbooks. XML is a simple way to automate some types of data loads in Excel. What is XML? XML stands for “extensible markup language”. XML is a structured way of formatting information so that it may be read by different systems. To see an example [...]

Excel to PowerPoint Converter

Posted on June 5th, 2010 by Joseph Harris

Subsidium Business Analytics has released its Excel to PowerPoint converter. We though we would take it for a spin to see how it works and if it is worth the money. Purchase and Install The Excel to PowerPoint converter cost $4.99 so my expectation was low. I purchased the add-in and an automatic download began. [...]

Multiple Condition Vlookup Function Add-in – Excel

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 [...]

Scrolling Excel Charts – Scroll Bar Graphs

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. [...]

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 [...]

Excel 2007 Security Issue

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 [...]