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....

It is a fantastic way to personalize your phone and surprise everyone around. This feature is usually present under Themes but isn’t quite apparent. But don’t worry, here we will tell you how to do it on the popular keyboard apps on Android such as Gboard, SwiftKey, Fleksy, and Samsung Keyboard. Let’s dive in. Gboard Gboard comes with many cool features and adding a background image is one of them....

Now, when I started looking, I stumbled upon a free and open source software called the Open Broadcaster that is basically a tool for live streaming. But can also be used to record screencast and videos, webcam and external source without any issues. The tool is indeed promising, so let me show you how you can use it to create screencasts on your Windows PC. Recording Screencast using Open Broadcaster To get started, download and install the Open Broadcaster on your computer and launch it....

The sudden addition of a picture on the Chrome icon will surprise anyone, especially when it looks like a ghost. One might think it’s because of Chrome extensions. But disabling them wouldn’t have helped you. So what is it? Let’s get to know the right method to hide profile icons from Chrome on the taskbar in Windows. But before that, it’s necessary to understand the reason behind the profile icons....

Not only a virus outbreak, things like network failure and unsecure USB removal while the file operation is in process, and even an unexpected power failure can damage your files, leaving them completely unusable . These errors aren’t that uncommon in everyday life and unfortunately Windows does not provide a tool to recover of these files, not even the bits and pieces. Thanks to a third-party software called File Repair (thanks Robert for the tip!...

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....

Sandboxie is a light and compact free software that blocks error prone programs and web based malware from affecting your PC. The security software creates a virtual sandbox and allows you to install new software, your browser and other browser based apps in a secure environment, shielded from the deeper layers of the OS. Sandboxie helps you test out new unproven applications and decide to keep ‘em or trash ‘em....

Opera Max is a new app from the Opera team that wants to help you out. The app acts as a VPN, compressing the data you receive on the way. This is especially useful when you’re watching a YouTube video or streaming a TV show. The app claims it can cut your data consumption by half. Let’s test that claim. How to Use Opera Max Once it’s set up, there’s not much for you to do....

Today, we’re looking at three Google Chrome extensions to help save web or online content in Google Drive with ease. These extensions are usable right from any website and makes saving images or text very easy. You can right-click any image and save it to Google Drive immediately. In addition, there are two extensions that allow saving online articles as PDFs or image files. Let’s check them out one by one....

Outlook.com was introduced. And it certainly did struck a chord with a lot of users considering the positive reviews it received. While some of you must have switched from other services to Outlook Mail or migrated from Hotmail to Outlook ID , many must be reluctant to making the switch just because they want to stick to their old and trusted email ID. If you love the Outlook interface and wish to preserve an existing email ID, you can configure Outlook to use an ID from some other service (we have already covered how to use Gmail from Outlook interface)....

That’s what we will look at today. The importance of taking every precaution to safeguard your data cannot be stressed enough. That’s why OneDrive also comes with ransomware protection. Let’s begin. 1. Set up OneDrive The first thing you will do is download and install OneDrive or install the latest version from the Windows Store. Open the Windows Store and search for OneDrive to install. If you already have it, click on the menu to select Downloads and updates....

It gives you chance to try most of its important features like Networks, Libraries, Aero desktop, Taskbar, Power management etc. You can also test other features like Windows XP Mode, Remote Desktop, Location aware Printing, Presentation settings etc. It requires JavaScript, Internet Explorer and ActiveX control. When you open the website, it automatically detects all the settings and prompts you to install all the required updates. Open the Windows 7 Professional Test Drive website....

Fortunately, there is another way, and it is not that hard either. You will be able to transfer both call logs and messages to your Android phone by the end of this guide. All you need is a computer (Windows or macOS) and your phones. Let’s begin. Take a Backup on Your Computer I will be using my Windows 10 computer for this guide, but you can also use macOS....

That makes a lot of sense but what about Play Store Music? It will soon be discontinued which means this is probably a good time to transfer your playlists from Google Play Music to YouTube Music. Exporting playlists from Google Play Music is a little tricky when compared to other music streaming apps, and only two of the several music data movers I tested works. Let’s begin. 1. Soundiiz Soundiiz is a web app that works with many music streaming services including Google Play Music and YouTube Music....

The proper dark or black theme is limited to Office 365 subscribers only. On Windows, you get a lighter version of the black theme known as Dark Grey. It is available for all subscribers. The methods mentioned here let you disable the Grey theme too. Let’s dive into the steps of disabling black theme on Microsoft Office apps. Disable Dark Mode in Microsoft Office Apps on Windows There are two methods to do so....

You won’t be able to get their AirDrops, Text Messages, Phone Calls, FaceTime Calls, and if you block their e-mail, you won’t receive any e-mail from them. On a lighter note, you may want to rekindle with an old acquaintance and now need to unblock their number. Fortunately, there are many different avenues we can take to unblock a contact. How to Unblock a Number on iPhone Unblock Through Settings This option shows all your blocked contacts listed in their raw form....

Good that there are tools to backup your Facebook data. But most of them are not free. However, if you are a Firefox user, then you can easily backup and archive your past Facebook updates with the help of an addon known as ArchiveFacebook. It allows you to save photos, messages, activity stream, friends lists, notes, events and groups from your Facebook account locally on your computer. You can access this data anytime in your browser....

Before sharing a Word file with team members or your editor, use Grammarly to fix all embarrassing typos and straighten out unusual sentences. Whether you use Microsoft Word on Windows or Mac, Grammarly is available as an extension on both platforms. Install Grammarly on Microsoft Word for Mac First, we will show you how to install Grammarly on Microsoft Word on Mac and then write a rough draft to check the service in action....

Google is an advertising company, and data is their bread and butter. Though the claim to undertake due diligence, not everyone is comfortable sharing the data about personal or professional lives with the search giant. And how do you actively avoid that? In comes Sesame Shortcuts. A universal shortcut app for the Android platform that works offline, and none of the data leaves your device. Download Sesame Shortcuts Let’s see how Sesame Shortcuts creates this universal search and how deep it integrates with the Android ecosystem....

The New Outlook.com Rules Tool Outlook.com is turning into one of the most feature-filled free email providers out there and its rules tool, which allows the user to sort messages in a more organized way, is a pretty good example of that. Note: If you use the Outlook email client for desktop, check out how to create email subject rules and folder based rules. The tool was announced a while ago and its worldwide roll-out wasn’t as quick as Microsoft claimed it would be; still, that doesn’t diminish the merits of the new Outlook....