The Unique function in Google Sheets makes it simple to create a list of only unique values from another list. One of the most useful aspects of the Unique function is that you type the formula into one cell, and it will fill in the cells beneath it with all the unique values in the range you specified. Interestingly, the formula only exists in the top cell. There is no need to copy down the formula or anything else. Just make sure that you have adequate blank cells adjacent to where you type the formula for all the items in the list. This tutorial contains the steps you need to use the Unique function in Google Sheets.
Category Google Sheets
Airplay allows you to stream multimedia files such as photos, music, and videos from your iPhone to Apple TV, AirPort Express, or other Airplay-enabled devices. It comes in handy when you want to stream the contents of your phone’s screen to a larger screen. By default, only Apple devices support Airplay. You can get an Apple TV that functions as an Airplay server so that you can mirror your iPhone’s screen to your TV. Without an Airplay-enabled device or an Apple TV, you cannot use Airplay – unless you use the steps in this tutorial which explain how to mirror from iPhone to Windows computer using Airplay.
iPhones come with a built-in camera time delay function. This allows you to set your phone on a tripod, table, rock formation, hut, or whatever else is nearby and set the camera timer for three or 10 seconds. You can then run into the frame to take a picture of yourself. This is a great solution for taking group pictures without making someone sit out to take the picture of the rest of you.
Category Apple iPhone
Apple introduced Photo Burst mode with the iPhone 5S. When you take a Photo Burst, you capture 10 frames per second over a few seconds (as long as you hold your finger on the shutter button). These photos are wrapped up into a bundle so that they do not take up a ton of space on your camera roll. You can keep all the pictures or just your best shot. This feature is helpful if you are trying to capture a shot of a wiggly kid or fast-moving sporting event or if you want to stitch the photos together to make an animated gif.
Category Apple iPhone
When was the last time you saw a fax machine? Fax machines are rather antiquated technology, but all the doctors offices and businesses that are stuck in the 1980’s and still use them make life difficult for the rest of us. I used to make trips to the public library to fax required documents for job interviews, medical forms, and more. Fortunately, there are now tools available that let you send and receive a fax online. Fax.to is one of these tools.
Spotify is a music application that allows you to search for songs, create playlists and discover new music, including tunes that are starting to move up the charts. Spotify is free for everyone, but you can upgrade to a premium account and enjoy additional perks. One of the advantages of getting a premium account is that you can download music and play it online. By default, the download is only allowed when you are on Wi-Fi, but you can download over a cellular connection on Spotify by following the instructions provided in this tutorial.
If you are trying to get your small business off the ground, you need all the help that you can get. Thanks to technology, your smartphone or tablet can be one of your best assets. Embrace what technology has to offer by downloading apps that can help you manage your business with ease. Here are some small business apps that are worth checking out.
Similar to Facebook, YouTube supports live streaming. However, this feature is disabled by default. If you want to use it to engage more with your subscribers, follow the steps in this tutorial to enable it for your YouTube account.
If you always save your uploaded videos into different playlists, you can follow custom rules to configure YouTube to add videos to playlists automatically. This feature can save you a lot of time, and your videos are always organized.
If you receive a large number of messages on your Facebook page every day, the inbox will become unmanageable pretty fast. To avoid scrolling through a long list of conversations to find what you want, you may add labels so that you can filter them out later. Continue reading to find out how to filter a Facebook Page Inbox.