Today in the world of competition, it’s very difficult to beat someone without using resources like money, man power and skills. The field of blogging is also just like practical world where everyone want to be on top of the list and want to earn more than others. The methodology of competition goes on and with the passage of time you’ll see an increase in competitors and ratio of increasing competition is higher than decreasing.
By now, most of the web is abuzz with news of Google axing its Google Reader, which is a platform that most bloggers, including me, identify with. I’ve lived with Google Reader open while I worked for several years, either via FeedDemon and also directly. With the demise of Google Reader, Nick has also decided to kill FeedDemon, most of you might already be hunting for alternatives.
In the past taking a screenshot from your Android device was a painful experience requiring you to root your device. Even today, many of the screenshot apps available on Google Play require root access. However, if you’re running Android Jelly Bean then you don’t need any special apps to take screenshots, since the OS comes inbuilt with support for them!
During my regular work, I tend to face repeated issues of Excel hanging. This can be really frustrating because a stuck Excel means a painful wait for Windows to figure out what it wants to do with the process. Unfortunately, there isn’t much I can do about this because it is mainly due to addons that I have installed in Excel, which are required for me to do my job coupled with large files with tens of sheets and hundreds of rows with data.
Way back in 2008, I wrote about using SUMPRODUCT to duplicate the functionality of SUMIFS which was introduced in Microsoft Excel 2007. SUMPRODUCT is a powerful excel function and is more commonly used to multiply two arrays. Let’s first understand the syntax of SUMPRODUCT.
There have been concerns about the security of your files in Dropbox. Recently Dropbox added another layer of security similar to Google’s two step verification. When you enable two-step verification, whenever you want to login to Dropbox, you will need to use your password, and a security code that will either be texted to your mobile phone or generated by a mobile authenticator app (available for iOS, Android, Blackberry and Windows Phone 7).
A few months back, we blogged about 7 applications for your Mac to prevent it from sleeping. While these programs make the process extremely simple, OSX Mountain Lion comes inbuilt with a ready command line tool that makes this process extremely easy. Fire up Terminal and run the following command: caffeinate -i -t 36000 & The command above will tell OS X to not sleep on idle (-i) and to keep running for 36,000 seconds or 10 hours (-t 36000).
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.
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.
Yesterday, we told you how to get your Outlook.com email. Outlook.
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.
Thanks to the internet we now have the convenience to call our friends and family members for free no matter where they are. For those who own an iPhone and would like to call their loved ones from any part of the world where they have access to a wifi connection they can use Tango! Tango is a brilliant free iPhone video calling service that connects people around the world with friends and family no matter where they are.
