Facebook has an algorithm that screens out messages from people who are not connected to you. Should the algorithm deem that a message from a stranger is not worth reading, it redirects the message to a filtered messages folder. Messages in the filtered folder do not give any notification. You can still access the hidden messages in Facebook to view these unread messages. You may be surprised at the number of messages you have in your filtered messages, and you may find some of these messages are important to you. This tutorial outlines the different ways to access the hidden messages in Facebook using your Windows computer, Android, and iPhone.
You can use Google Sheets DMAX function to find the maximum value in a range based on some criteria. For example, if you have a table of data with outstanding payments you are owed from each of your clients, you can use DMAX to find the oldest of the outstanding payments for each client.
We have all heard the horror stories: You receive a late night call from the office, the caller frantically telling you that the entire network has gone down and the backups are corrupted, or even worse, missing entirely. The IT landscape is littered with tales of backups gone wrong, both deliberately and accidentally. Businesses have suffered, jobs have been lost, and reams of data have been compromised, all because of mishandled data backups.
I was working in Google Sheets creating a dashboard that summarized data in another sheet. Specifically, I was trying to make a table that showed a list of each client that owed money. I tried to do this with a pivot table, but for some mysterious reason, pivot tables in Google Sheets do not automatically update. Because of this, it did not reflect changes in my source data until I manually updated the pivot table. That is when I discovered Google Sheets Filter function.
Category 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.
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.