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: Optimize your CSS with CleanCSS

CSS (Cascading Style Sheets), a very effective thing for a site / blog these days. They give you the chance to be completely consistent with the look and feel of your pages, while giving you much more control over the layout and design than straight HTML ever did. The speed of your site also depends on your CSS, the complex the code, the slower is the site.

|

Money Making Monday: Get paid to surf

Everyone has been waiting long for the release of the Agloco’s Viewbar which enables you to get paid for surfing sponsored sites and pages. Now after surfing a lot on internet, I found out a hidden and new website which also pays to surf sponsored pages but without installing anything or waiting for any release. 😀 AdBux.

|

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.