With Windows 8, the way we interacted with Computer has changed enormously. By default, Windows 8 looks better and more beautiful than its predecessors. It boasts many new fancy features and customization capabilities like a Smartphone/Tablet. Here are some cool ways you should know to customize Windows 8 like a Pro.
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. If you’ve purchased Windows 8 Pro, then for a limited period, you can get the new Windows 8 Media Center completely free! Simply visit the Add Features page on the Windows site before 31 January 2013 and you can get a serial code completely free emailed…
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. 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…
Last week, I introduced you to VLOOKUP, INDEX and MATCH. In this post, we’ll use VLOOKUP to find a value from the 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…
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. Today, you don’t think about how much space you can use in your email. While all three of the major players, Hotmail, Yahoo! and Google have updated their mail designs and have added a few features, we haven’t seen any revolutionary changes. Now, Microsoft hopes to change that with Outlook.com what they are tagging…
Excel has several lookup and reference functions. The main purposes of most of the plugins is to lookup some cell or cells from a set of data (usually presented in a table). Of these, the most popular ones are VLOOKUP, INDEX and MATCH. Usually INDEX and MATCH are used in combination as a replacement to VLOOKUP. This post will walk you through the basics syntax of the functions. In a future post, we’ll use them to lookup some values. VLOOKUP You can use the VLOOKUP function to look up the value of a cell from a range of cells, usually…
If you’re already running Windows XP, Windows Vista or Windows 7, then this one is for you! Microsoft is offering all existing users to upgrade to Windows 8 Pro for just $39.99. The offer is until January 2013, so if you’re still debating, you have some time to make up your mind. The Windows 8 Upgrade Assistant will check to make sure your PC is ready for Windows 8. It will provide a detailed compatibility report that lets you know of anything you may have to address before or after the upgrade and outlines actions to take. You will need…
Microsoft unveiled it’s new tablet titled “Surface“. Aptly titled because the Windows RT version weighs in at 676g and is only 9.3″ thick! Surface has a 10.6″, 16:9 widescreen HD Display. Microsoft’s ClearType HD Display technology delivers a great picture for movies. The tablet has a USB port and a MicroSD slot which means you can connect printers, mice or keyboards which support Windows RT. Alternatively get hold of the Windows 8 Pro version which is a bit thicker, but a lot more powerful. The Windows RT version will be available with 32GB and 64GB space while the 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. This is already a problem in Windows 7, which has been designed to boot rather quickly. And, its unlikely…
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. Forget about holiday planning, booking etc. Just focus on packing your & your mom’s best clothes because Microsoft gives you a never before opportunity to win an all expenses paid trip to Thailand for your mom and you! All…