Category Archives: Uncategorized

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”

In this step-by-step tutorial, learn what the various OBS record settings mean and what to select to ensure that you record the best quality videos. In this video, I don’t recommend one set of settings as there is no one size fits all. Instead, I walk through what settings are most appropriate for a highContinue reading “Best OBS Recording Settings 2020”

Easily separate First Name from Last Name in Excel, including if there are middle names, and with no formulas. Simply use tables and fill series to separate the first name from the last name. In this video, I use the latest version of Excel that comes with Office 365.

Learn how to use AirDrop to share and receive photos, documents, videos, and more with other Apple devices that are nearby. Before you begin Make sure that the person you’re sending to is nearby and within Bluetooth and Wi-Fi range. Check that you and the person you’re sending to have Wi-Fi and Bluetooth turned on.Continue reading “How to Use Airdrop on iPhone”