Free Weight Loss Tracking Workbook

Posted on January 5th, 2012 by Joseph Harris

A fun little workbook to play around with…The Weight loss guru provides you with calroies, a tracking sheet and advice for your weight loss. Weight Loss Guru If you found this article helpful, buy me a cup of coffee! Bookmark It

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

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