Posts

If you, however, wanna be more productive while using similar functions while using Excel, let me suggest using Flash Fill. It’s Like Magic If you’ve never used Flash Fill before, it will feel like magic to you. It works on a simple principle of identifying patterns and filling up vacant rows with these patterns. Let’s look at an example. Dividing Names Let’s take a simple task of separating names, first names and initial of employees within Guiding Tech (and Albert Einstein) using MS Excel....

There are many third-party utilities that can help you turn the laptop monitor off instantly. We’ll discuss one of them here. It’s called Dark – Turn Off Monitor. It’s a freeware. Here are the steps to install and use this software. Download the software from its website. Unzip the file using a tool like ZipGenius and run the setup file. Select the options and proceed with the installation. The tool requires ....

That’s a pretty cool feature to have as a sender if you ask me. However, as a receiver, it’s not that great because you always keep wondering what the other person was trying to say? But, as always, there are ways you can know what that deleted message was. In this post, we will tell you exactly how to do that along with a number of other nifty tricks....

You might be wondering, what’s the use of metadata? Well, the metadata that gets transferred along with the file is used to label, classify, and understand the data. It also helps sort, locate, or search a file on your computer effortlessly, especially when dealing with a lot of data. Before moving on to removing information, let’s first understand what types of personal information are saved in the files you share....

As hale and hearty as this process may sound, it’s not without its share of issues. In the haste to use these apps and games, we usually choose to ignore the app permissions. More often than not, once the Google access permission has been given, most of us tend to forget about it. If it’s a trusted app, it might be okay. But in the long run, unmonitored app permissions can land you in a troublesome situation....

In the article, we will see how to install custom recovery and root the Redmi 2. The guide is divided into four sections for ease of use. Please make sure you follow the steps carefully and in order. Getting the Device Ready The very first thing you will have to do is get the phone in developer mode. To get that done, open the About Phone page and tap repeatedly on the MIUI Version....

Using separate notification sounds different from the default tone comes handy in various situations. Like when you are cooking, driving, or performing similar activities, and you cannot or don’t want to touch the phone. Let’s see how to change the default tone and keep a separate notification tone for Android apps. Method 1: From Phone Settings Android 8.0 Oreo changed the way with notifications channels that allow setting app notifications for apps individually....

Commercials are a necessary evil for bringing all that great content to us. But thankfully when it comes to YouTube, you can find the ways and means to duck the ads which pop-up even before the clip begins to buffer. Yes, one might say that it’s wrong to dodge the ads because that’s what’s paying for the ‘free’ content, but the Chrome extension we are going to talk about here does not block the ad; it merely introduces a way to skip the commercial and go directly to the beginning of the video....

shared document viz. one document to be used by multiple people. When this is the case, it is also obvious that the privileged ones will make changes to the document; and at times make changes that others can’t figure out. Hence it’s a good idea to keep a track of the edits made to a shared document. The basic way to do it is to add a comment after a change you make or notify the collaborators after you do the edit....

Want to know how to get the best out of the graphic equalizer settings on your phone’s music player? Sit back and read on! First Things First Before jumping into the details, let’s know what do the keys and bars on the graphic equalizer actually mean. The music player interface and the location of the graphic equalizer vary from one phone to another. However, the range of sliders – bars that are moved up and down to adjust the sound – is similar to one another....

Dictionary.com is probably the best of the lot. But when it comes to the ones on smartphones, Dictionary.com’s app never really impressed me. It needed an internet connection to look for the definition of a word. To me, the idea of being connected to the internet to just look up the meaning of a word sounded ridiculous. What if one’s offline or out of the coverage area? Also, if I am connected to the network on my Android, I would just use Google Now instead of using an app....

Low Power Mode is an essential feature for Mac users. You can also use third-party apps to improve your MacBook battery’s health. We will start with the default options and move to other tricks to use your MacBook battery efficiently. What Is Low Power Mode on Mac As the name suggests, Low Power Mode helps to extend your MacBook’s battery life. The function reduces energy usage to increase battery life and operate more quietly....

While many of us wouldn’t readily admit, we often have more than one Facebook account — be it for personal use or for giving out free lives in Candy Crush — the chances are many. While the lot of us either resort to Chrome’s Incognito Mode or a different web browser to open the second account, it can prove to be a tad tedious. What if I told you that there’s a way using which you can access multiple Facebook accounts from a single Chrome window?...

Adding a star to an email is the easiest way to organize necessary emails on the desktop and mobile. Apart from adding a yellow star, you can tag an email as blue-star, green-check, purple question, and even customize the default options. Let’s check it in action. Add Star to an Email You can hit the star icon beside an email and check the same from a dedicated ‘Starred’ menu in the Gmail sidebar....

In this post, we’ll talk about using it to backup, sync and restore data. The steps are more or less the same. Check them out. How To Backup Data Using Syncback Download and install Syncback. When you first launch the tool, a dialogue window will appear asking you to create a new profile. Click on “Yes” button. Now there are three profile types available. Backup, Synchronisation and Group. Select the first one, i....

So, if you’re curious or concerned about what data Instagram has collected over time, we’ll show you how you can view, download, and delete your Instagram data on both mobile and PC. So, let’s get right into it. How to View Your Instagram Data If you want to see what data Instagram has collected during your usage, you can easily access your Instagram data on mobile and PC. View Your Instagram Data on Mobile Read on how to access your Instagram data on Android or iPhone....

Though both these smartwatches look the same at first glance and the most confusing thing is that they are priced the same. Well, almost. So, does that mean both the watches have the same features? Do they have the same feature-set? That’s what we shall attempt to answer in our comparison today when we compare the Huawei Watch GT 2 with the Samsung Galaxy Active 2. As it’s going to be a long one, let’s get started....

In fact, we have talked about the service and how useful it is in some past entries on this site (like this one or this other one for example), which kind of made it even more confusing that it wasn’t available as an iPhone app. Well, that time has come to an end, since the native iPhone app of IFTTT is available now and it does sport some really great features that will certainly make it essential for many iPhone users out there....

Now since Instagram is such a huge place, and there are so many people and pages to follow, you might end up missing out on an update by someone you love to see posts from or a near and dear one. Instagram’s feed works in a similar manner to Facebook’s feed algorithm, which means that it’s quite possible that it prioritises posts from pages you engage with to those of your friend who seldom post and you might even miss that ‘seldom’ post....

Instagram rolled out a new snazzy feature, which allows users to use face filters while sharing a live video last week and has now made the glasses filter available across their app on Android and iOS. The new sunglasses face filter, rolled out first exclusively for live videos, is now available for use with Boomerang, Rewind and other camera formats and creative tools. When this filter is applied, users can tap to change the scenery reflected on the glasses....