Software

Opera releases 12.10 beta; adds Windows 8 support

Opera has always been one of my favourite browers. It’s fast and they have steady update to valuations. It still needs to go a long way to get close to Chrome or Firefox in terms of add-on support, but it’s a good alternate browser, if you need one.

What’s Your Computer Disaster Plan?

Sad, but true: If you spend a lot of time on your computer, there’s no doubt that you’ll experience data storage problems at some point, whether it’s a mechanical failure or a failure on your part. In this increasingly digital world, data is becoming the most important thing you can create. When that data – personal, financial or otherwise – is lost, by golly you need to get it back.

Dexpot releases new version with Windows 8 support

One feature that has remained lacking in Windows is multiple virtual desktops which are easy to use and customisable. Dexpot brings this much needed feature to all Windows machine with the latest version including support for Windows 8. Dexpot brings to you several features that truly enhance your Windows experience.

AVG releases AVG Free 2013

The good folks at AVG have released their latest suite of antivirus and security products. Title AVG 2013, the suite includes AVG AntiVirus FREE 2013, AVG AntiVirus 2013, AVG Internet Security 2013 and AVG Premium Security. For users of the popular free program (2nd most popular antivirus download on Download.

Excel Tutorial: INDEX MATCH primer

Two weeks, we looked at the syntax of VLOOKUP, INDEX and MATCH. Last weeks tutorial should have walked you through the basics of VLOOKUP. In this post, we’ll use a similar file from the VLOOKUP tutorial to find a value from the table using INDEX and MATCH.

Source table

If you haven’t had a chance yet, please go through the VLOOKUP tutorial. Alternatively, if you’re ready to jump right into INDEX/MATCH, then let’s get started.

Firstly, create the above table in Excel. I’ll be using Excel 2010 in my example. You can also download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet with the answers.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

Read More »Excel Tutorial: INDEX MATCH primer

Excel Tutorial: VLOOKUP primer

Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the table.

Source table

Firstly, let’s create the above table in Excel. So whip up the installation of Excel you have. You can use either of Excel 2003, Excel 2007 or Excel 2010. I’ll be using Excel 2010 in my example. Download the examples file before you proceed. The file contains a Questions sheet which you can practice in and a Solutions sheet as well.

If you haven’t had a chance to review the basic syntax of the functions, please do read this post before you continue.

VLOOKUP is the easier function of the two to use and understand. It takes just 4 parameters and we’ll be using all 4. And, we’ll look at 4 options of using VLOOKUP.

Read More »Excel Tutorial: VLOOKUP primer