Author Archives: kerrystratvert

Learn how to edit the default iPhone email signature across all of your email accounts in this step-by-step iOS tutorial. An email signature is text, like your contact information or a favorite quote, that’s automatically added at the end of email messages as a footer. Steps to add signature: Navigate to Settings on the homeContinue reading “How to Add Mail Signature on iPhone”

In this short video I show you how to turn on Dark Mode or Dark Theme for Instagram on iOS.

Upgrade from Windows 7, 8, or 8.1 to Windows 10 entirely for free and using the official Microsoft web site. Web site where you can upgrade to Windows 10: https://www.microsoft.com/en-us/softw… Microsoft is no longer supporting Windows 7. If you’re still running Windows 7, you’re at risk of attacks and viruses since there are no longerContinue reading “How to Upgrade to Windows 10 for Free in 2020”

Learn how to Download and Install Office 365, 2019, 2016, 2013, & 2010 by following this video. Microsoft Office includes such popular programs as Word, Excel, PowerPoint, OneNote, and Outlook. To download and install, you need a product key or an Office 365 subscription. If you have neither, you can still use the Office webContinue reading “How to Download and Install Microsoft Office”

Learn how to find and remove duplicates​, count unique values among duplicates​, and use the new unique function. At the end, I cover how to use Excel for free on the web. Excel on the web supports conditional formatting to find unique values and duplicates, remove duplicates, and the new unique formula. The new uniqueContinue reading “How to Filter for Unique Values & Remove Duplicates in Microsoft Excel”

Learn how to Mail Merge to create customized certificates using Microsoft Word and Excel. Quickly take a spreadsheet with names and create many customized certificates with ease. No need to paste individual names, and other information into a certificate. Mail Merge allows you to send customized envelopes, letters, certificates, and emails. Mail Merge leverages MicrosoftContinue reading “How to Mail Merge Certificates – Office 365”

Learn how to use COUNTIF and COUNTIFS to count the number of cells that meet a criterion or multiple conditions; for example, to count the number of times a particular city appears in a customer list. In this video, I run through the following: Count how many times a certain string or number appear inContinue reading “How to use COUNTIF and COUNTIFS in Microsoft Excel”

Learn how to Mail Merge to create customized letters using Microsoft Word and Excel. Quickly take a spreadsheet with contacts and create bulk letters with ease. No need to paste individual names, addresses, and other information into a letter. Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft WordContinue reading “How to Mail Merge Letters – Office 365”

This step-by-step tutorial shows you how to use the Multi-Camera Editor that comes with Corel VideoStudio to screen your footage, switch angles, cut and delete, add transitions and easily align clips. Many thanks to Tara Brown for helping with this video! Check out Tara Brown’s YouTube channel for photography tips and tricks: https://www.youtube.com/channel/UCS-M…

In this step-by-step video, learn how to share a Folder or Hard Drive on one computer with all the other computers on your home network. Share photos, videos, apps, and other content between computers. To share a folder or drive, open File Explorer. Right click on the folder or drive and click on properties. InContinue reading “How to Share Folders & Drives from one Computer to another Computer – Windows 10”