How to Change a WordPress Blog Address
After you have created a blog, you may find that you do not like the name you chose for it and want to change it. Luckily, it is very easy to change a WordPress blog address without creating a new one. Here is how to do it.
How to Disable the Camera on iPhone
The camera on iPhone is one of the world’s best smartphone cameras. With its 12-megapixel iSight camera, your iPhone can help you capture the best shot of that special moment or that stunning view. Undeniably, iPhone’s camera is one of the device’s strong points. However, there may be instances when you want to disable the camera on iPhone. If you want to keep your child from wasting your storage by taking too many pictures or videos or if your place of employment does not allow any cameras on the premises, temporarily disabling the camera of your iPhone can be quite useful. This tutorial will guide you through the steps you need to disable the camera on iPhone.
How to Restore Older Version of Google Slides Presentation
By default, whenever you make changes to a Google Slides presentation stored on your Drive, the service will save revisions of that file so that you can restore it back to an earlier version in case something goes wrong. Continue reading to find out how to use it.
How to Format Non-Blank Cells in Google Sheets
I recently worked on a spreadsheet with a table that was populated using the filter function. This meant that I did not know how many rows would be included in my table: It would dynamically update as the source data changed. I wanted to apply some formatting to the table so that it would look better than straight text. I achieved this by applying conditional formatting to all the cells that could be included in the table. The conditional formatting was set to shade the cells that were not blank to make my table look more cohesive. This tutorial explains how to format cells that are not blank when using Google Sheets.
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
