Archive for April, 2011

P90X Template Now Available

Posted on April 15th, 2011 by Joseph Harris

I have uploaded the P90X exercise program template to the Excel Yogi Templates section: Excel Templates Easily track your progress within the P90X program. Easier to use than the forms that come with the program. Bookmark It

How to Use ISERROR Function in Excel

Posted on April 3rd, 2011 by Joseph Harris

The ISERROR function is a versatile one that is very useful in testing an outcome of a formula so that you can account for any errors, more on that later…First, lets learn the syntax: =iserror(A1) A1 is the cell you want to test for an error. If A1 contains #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME!, or #NULL!, [...]

Excel Calendar Template Added to Download Area

Posted on April 3rd, 2011 by Joseph Harris

We have added the Excel Calendar Generator template to the downloads section of ExcelYogi:    Free Excel Templates The template is a very simple and quick way to generate calendars for future years, simply add the year and the day of the month the year starts on. Joseph Harris Excel Help Bookmark It

How to Create Heatmaps in Excel

Posted on April 2nd, 2011 by Joseph Harris

Starting with Excel 2007, a feature was added called “Color Scales”. Color scales can be used in many ways but by far my favorite is to use this functionality to create heatmaps. Heatmaps are 2 dimensional representations of 3 dimensional data. You can think of them as bar charts where you are looking down on [...]

Best in Class Procurement Organizations use Excel

Posted on April 1st, 2011 by Joseph Harris

Spend Matters has release its preliminary findings from an ongoing study examining the use of technology in procurement and supply chain organizations. Spend Matters and its research partners surveyed nearly a quarter of the Global 2000 companies. The primary goal of the research team was to find correlations between specific technology usage and World Class [...]