Author Archives: kerrystratvert

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”

Free & No download required to rotate videos using an app that comes pre-installed as part of Windows 10. In this quick tutorial, learn how to prevent recording videos in the wrong orientation. Additionally, if you record video in the wrong direction, learn how to easily rotate it into the correct orientation using the PhotosContinue reading “How to Rotate Video on Windows 10”

FREE & No App Required. Learn How to Record your iPhone Screen using using this native / built in iOS functionality. This works on iPhone 11 or 10. Learn how to toggle on/off audio recording as part of your screen capture.SHOW LESS

Learn how to use the Xlookup function in Excel. Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you canContinue reading “How to Use XLOOKUP in Microsoft Excel”

Learn how to subtract and add dates in this step-by-step tutorial using Microsoft Excel. With subtraction, find out how many days are in between two dates. With addition, find out what date you’ll land on by adding days to a date. Access the workbook that I used in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIdb9…

Learn how to share your Office 365 Home subscription plan with up to 5 other people. Office 365 includes such popular programs like Word, Excel, and PowerPoint, 1 TB OneDrive storage per user, and 60 minutes per month Skype calling. If you share with 6 people total, the price per month works out to aroundContinue reading “How to Share an Office 365 Home Subscription”

Learn how to take photos and videos from your computer and bring them to your Apple iPhone without any cables and without installing any software. This works regardless of your operating system (Windows or Mac) and only requires a web browser. In this video, I walk through how to access icloud.com, how to upload aContinue reading “How to Transfer Photos and Videos from Computer to iPhone”

Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect. An IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.Continue reading “IF Function in Excel Tutorial”