Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT. Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
In a startling revelation, Terry Myerson, who runs Microsoft’s operating systems unit, announced that all users of Windows 7, Windows 8 and Windows 8.1 will get a free upgrade to Windows 10. This also includes everyone who are, either knowingly or unknowingly, running a non-genuine version of Windows! This seems to be Microsoft’s plan to battle pirates…
Advertisement tracking is pretty much a given in today’s world. Major networks like Google and Microsoft are serving advertisements on thousands of websites and they attempt to serve you relevant ads based on your browsing experience. But, you can stop the tracking and serving of personalised ads.
A month back we told you how to get hold of Windows 8 Media Center for your Windows 8 PC for free. And it seems like pirates have used this method to find a workaround in the Windows activation program Using this method, you can now simply activate your copy of Windows 8! Below is screenshot of my Windows 8 Pro with Media Center edition which I purchased last month.
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.
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.
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.
Windows 8 Release preview is already available and if you’ve decided to give it a shot, you’ll notice the big changes to Windows 8 over Windows 7. In line with the Windows 8 release, Microsoft, yesterday, unveiled a range of new mice and keyboards that are ready to work with Windows 8. It doesn’t mean your existing mouse and keyboard will stop working, but, the new series is specially designed to get the most of Windows 8.
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.
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!
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.