It’s helpful when working with a huge list of data and want to separate the information into two columns. We”ll show you how to separate data into columns using the split text to columns function in Google Sheets. Apparently, with the help of it, you can avoid wasting time copying and pasting data into different columns. Uses of Split Function Let’s take a look at a few scenarios where splitting your data into two columns can be quite useful....

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

In an attempt to block them, most of us often ignore calls that might be important to us. Now, Truecaller wants to change this with a new feature called Truecaller Assistant. Purely looking at the numbers, Truecaller is one of the leaders in safer communication. They have over 320 Million active users worldwide and regularly block billions of harmful calls and texts every year. Can you imagine some of the losses people would have to face if those billions of calls/texts made it through?...

Forget third-party extensions or messing around with the experimental flags — Chrome’s support for picture-in-picture mode is ready to go out of the box. But the ability to play videos in picture-in-picture mode is still kind of ‘hidden,’ so let’s see where it is, and what you should expect when using this awesome new feature. Update Google Chrome Picture-in-picture mode functionality is only available by default on Chrome v.70 and above, so make sure that your browser is up to date....

Spaces is a useful feature. You can have different desktops for different types of apps, or just have apps take up the full screen (which is one of my favorite things in OS X. I love making Write for Mac fullscreen and going to town on that keyboard). If you’re a Mac power user, you probably have more than a dozen apps open at once, and I’m low balling here....

With time, Instagram started adding many cool features to stories, and highlights are one of them. If you are also confused about stories and highlights like many other people out there, then you are in the right place. Here, we shall compare the two and see how they differ. What Do They Do On Instagram, the story is the main feature and highlight is a part of it. When you post a story, it lasts for only twenty-four hours....

A lot has changed between then and now. Rumors that once looked absolutely ridiculous are now coming to fruition, and rumors that seemed to make sense last year don’t make sense anymore. While Apple hasn’t confirmed anything yet, and likely won’t until September, it’s worth breaking down what seems plausible and what’s a stretch for the upcoming iPhone(s) in 2017. Three New iPhones – Likely It sounded pretty odd at first, didn’t it?...

The UE Boom 3 made a debut in early 2019 and still reigning on the charts of top recommendations. The 360-degree booming sound is still a plus and the IP67 waterproof and dust-proof rating is the cherry on top. So how does it stack up against the new JBL Flip 5? We are going to find this post today as we compare the new JBL Flip 5 with the older (and popular) UE Boom 3 to help you make an informed decision....

This speaker is known for its range of cool colors. The fact that you can simply hook it to your backpack or carry it in your hands makes it worth pursuing. And well, it doesn’t cost much. But, which speaker cuts when it comes to overall performance? Should you buy the Bose SoundlLink Micro even though it’s over three years old? Well, that’s what we are going to answer in this post as we pit the JBL Go 3 against the Bose SoundlLink Micro in this comparison today....

MS Office suite in some form or the other, be it Word, Excel, PowerPoint or Outlook. You’d agree that while we work through our MS Office tasks, it is also important to maintain a certain degree of efficiency. As per my experience, the “efficiency” grows with increase in usage of keyboard shortcuts and reduction in dependency over mouse clicks. While most of us use some basic and well known shortcut keys, we are still unaware of their real potential....

Yes, Android itself comes with a selection of toggles but they’re limited and not easily customizable. Plus, you need a special gesture to access them. If you upgraded to Lollipop you might have found that the situation hasn’t really improved. Rather, the toggles available have been reduced to a bare minimum. Another thing you might have noticed is just how out of place toggles from an app like Notification Toggle or Power Toggles look....

Yesterday I was strolling in the Play Store Photography section, and that’s when I found a cool app called Million Moments that could be a perfect Gallery replacement app for Android. Two things that make photo viewing experience great on Million Moments are its magazine-style layout and ability to use tags to organize photos. So let’s see how Million Moments works. Installing it would be the first step. Getting Started with Million Moments After you install Million Moments, the app will ask you to select the photos you would like to import to Million Moments as a part of a small walk-through....

Rumour mills have been churning information related to the upcoming OnePlus device — dubbed the OnePlus 5. The company has confirmed that their next flagship, which will succeed the OnePlus 3 and 3T, will hit the stands this summer. According to a report by The Verge, OnePlus isn’t naming the next device OnePlus 5 due to the Chinese superstition of 4 being an unlucky number, rather because of Robert Horry’s number 5 jersey in the NBA....

Opera is one of the better Chromium-based browsers out there. With a host of unique features ranging from integrated social media capabilities, built-in content blocking, to free VPN support, it really stands out from the rest of the pack. And then there’s Opera GX, a so-called ‘gaming’ browser released by the same developers. But what does Opera GX do? Does it improve your PC’s gaming performance? Is it substantially different from the regular Opera as to warrant a switchover?...

The problem is that if you use desktop email clients or applications to receive emails from your Outlook.com account, they may not function anymore. The password of your account will not suffice for the clients to download emails from your account. An example of the connectivity error or requirement of password is shown below. I faced this issue with MS Outlook desktop client after I activated two-step verification. Now, the question is how do we get through?...

While Google is focusing on simplicity and taking a minimalistic approach, Microsoft is all about bridging the gap between Android and Windows 10 to improve end-user productivity. Both the launchers offer various customization options, feed menu, search engine, and theme support. Based on your usage and preference, you might find one useful over the other. In this post, we are going to compare Pixel launcher to Microsoft launcher and conclude if you need to make a switch from the default Pixel launcher....

row and column fashion. It’s real power lies in data manipulation . Let me share an example. I stay in a rented apartment with 4 other friends. We maintain certain monthly expenses on an Excel sheet so that we can divide an equal share at the end of each month. When some expense is incurred by a single head, it is easy to edit a single cell value. But, when a constant value needs to be operated on all the cells, it takes some effort....

While all it would have taken is a simple Bluetooth file transfer, Apple loves to set restrictions for what goes in and out of their devices. But we here at Guiding Tech work really hard to find some amazing workarounds to make file sharing simple for you guys. I am going to show you how you can transfer photos from iPhone to Android and vice versa using Wi-Fi, even when you don’t have a Wi-Fi hotspot around....

What’s best about the Always On Display (AOD) feature is that you can customize the face widgets to your hearts contents. With the new update, this cool feature on the Samsung Galaxy S9/S9+ is set to become more trendy, all thanks to the newly introduced GIF feature. Yep, you read that right. You can now set cool new GIFs on the Always On Display screen. Though Samsung has a set of preloaded AMOLED-friendly GIFs, you can also add one from your own arsenal of GIFs....

Also, recently I had to show a friend how to go invisible on Facebook chat. I shared the screen with him in a second instead of typing out instructions. When the word you are searching for is ‘quick’, try out Screenleap – one of the fastest, simplest, and easiest screen sharing apps I have come across. Screenleap requires no installation. It runs off a Java applet from within any browser (usually every computer already has it installed)....