Excel Tutorial: SUMIF with Multiple Conditions
| | |

Excel Tutorial: SUMIF with Multiple Conditions

The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition. Excel 2007 introduced the SUMIFS function which allowed for multiple conditions. However, if you are using any version prior to Excel 2007 or if the persons who will be using your Excel workbook will be using a version prior to Excel 2007, then the SUMIF function will throw up an error.

| | | |

Get Camtasia Studio 3 for FREE

I never had the need for a screen recording software to date, however, this is one of the best ways to put up some video tutorials. Wink is a good free software, however Camtasia Studio is feature rich paid software, that has been out of my budget until now. As part of a promotion drive for Camtasia Studio 5, TechSmith is offering Camtasia Studio 3 for free.

Multimedia Monday: MediaCoder
| |

Multimedia Monday: MediaCoder

MediaCoder is a FREE universal audio/video batch transcoder distributed under GPL license, which puts together lots of excellent audio/video codecs and tools from the open source community into an all-in-one solution, capable of transcoding among different audio/video formats. The best feature of MediaCoder is the ability to transcode files in batch format. If you’re looking to load your music player and you have all your files in different formats, then you can use MediaCoder to convert them all into the format supported by your player.

|

Tool Tuesday: Lorem Ipsum Generator

If you’re familiar with free templates, or have been working in the printing industry you would have come across this text often: Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

| | |

Tool Tuesday: IE NetRenderer

If you’re on a Mac or you have already upgraded to Internet Explorer 7, then you’ll be pretty lost about how your site looks like on lower versions of Internet Explorer. For me this is a big problem because half my visitors to my several sites are still using IE6 and you have to admit that IE6 is a pathetic browser. IE7 is a lot more compliant and displays sites a lot correctly than its predecessors.