Microsoft

How to get Windows 8 Media Center for Free

I upgraded my old (though still robust) Dell Inspiron 15 to Windows 8 over the weekend. I’ve struggled quite a bit since then to get it up and running and finally ended up resetting my computer. It has been stable since then and the operating system is definitely faster than Vista and Windows 7.

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

How to get your Outlook.com email

In the beginning we had Hotmail. I remember creating my Hotmail account way back in 1998 with 10MB and it was considered a lot of space. When Google came out with Gmail, the company revolutionised email as we knew it to be with 1GB of space.

Troubleshooting gets better in Windows 8

Windows 8 has been designed to boot so quickly that you have almost zero reaction time to get to the famous boot screens that allow you to choose a different boot device or enter into the troubleshooting utilities. If you want to enter the boot screens when booting up your PC, you need to hit the F8 key. Usually one tap doesn’t suffice and you’ll need to hit the key repeatedly several times so that Windows can detect one of them.

7 Steps to gift your mom the best on Mother’s Day

Wondering what to gift your mother this Mother’s Day? Greeting cards, flowers, jewellery and chocolates are all passé; it’s the new age mom we are talking about so the gift should also match her persona. This Mother’s Day make your mom feel special by gifting her a fabulous holiday for her to unwind and get away from the regular boring chores.

Top 7 Stories of the Day

Welcome back to the Top 7 stories of the day! So there’s some useful stuff for iPhone, iTouch users; people thinking about upgrading to Windows 7 and Mac Users! 1 – ONE!