Fresh Tutorials
Posted May 11, 2016 by

How to Use Google Sheets Unique Function

Google Sheets

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.

Continue Reading

Category Google Sheets

Posted May 3, 2016 by

How to Mirror from iPhone to Windows Computer Using Airplay

Cast iPhone Screen to Windows Computer

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.

Continue Reading

Posted May 1, 2016 by

How to Use iPhone Camera Time Delay

iPhone Camera Delay Timer

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.

Continue Reading

Category Apple iPhone

Posted April 30, 2016 by

How to Use iPhone Photo Burst

How to Use iPhone Photo Burst

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.

Continue Reading

Category Apple iPhone

Posted April 29, 2016 by

How to Send and Receive a Fax Online

Fax by Email

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.

Continue Reading

Category Internet

Posted April 27, 2016 by

How Do I Download Over a Cellular Connection on Spotify?

Spotify - Download Over Cellular Data

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.

Continue Reading

Posted April 26, 2016 by

7 Apps Every Small Business Owner Should use

ABLV bank application

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.

Continue Reading

Category Apps

Posted April 23, 2016 by

How to Live Stream on YouTube

youtube-logo-1920

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.

Continue Reading

Category Internet

Posted April 19, 2016 by

How to Add YouTube Videos to a Playlist Automatically

youtube-logo-1920

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.

Continue Reading

Category Google, Internet

Posted April 17, 2016 by

How to Filter Facebook Page Inbox

official-facebook-logo-slide

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.

Continue Reading

Category Facebook, Internet