Home Blog Page 194

How to Use Google Sheets DMAX Function

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.

How to Access the Hidden Messages in Facebook Messenger

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.

How to Keep Your Data Backups Safe

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.

How to Use Google Sheets Filter Function

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.

How to Use Google Sheets Unique Function

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.

How to Mirror from iPhone to Windows Computer Using Airplay

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.

How to Send and Receive a Fax Online

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.

How to Live Stream on YouTube

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.

How to Add YouTube Videos to a Playlist Automatically

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.

How to Filter Facebook Page Inbox

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.

How to Greet Customers Automatically on a Facebook Page

When you greet customers automatically on a Facebook Page, it gives them a good impression of your service. You can also take advantage of this feature to redirect customers to your frequently asked questions page or display a public announcement about temporary changes in your services that might affect the reply time. An automatic greeting, when used correctly, can reduce the number of messages coming to your inbox everyday. Here is how to set it up and use it on your Facebook Page.

How to Play the Secret Basketball Game in Facebook Messenger

Aside from the messaging, chatting, and video calling functions, Facebook Messenger packs a lot hidden features. In a previous tutorial, I explained how to play a secret chess game on Facebook Messenger. If chess is not your game, Messenger also offers a hidden basketball game. This tutorial will teach you how to play the secret basketball game in Facebook Messenger.

error: Content is protected !!