Category Archives: Uncategorized

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”

Learn how to combine cells in Microsoft Excel using the concatenate function in this step-by-step tutorial. Access the sample data that I use in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIZfJ… The CONCATENATE function joins two or more text strings into one string. In Excel 2016, Excel Mobile, and Excel for the web, this function has been replacedContinue reading “Concatenate Excel Tutorial”

Learn how to use the SUM function in Microsoft Excel to add values. See how you can add individual values, cell references or ranges or a mix of all three. Also learn how to use SUMIF to sum the values in a range that meet criteria that you specify. =SUM(A2:A10) Adds the values in cellsContinue reading “How to Use Sum in Excel Tutorial”

Learn how to add a table of contents into your document in Microsoft Word. First, I show you how to add headings to your document. Text that uses a heading is automatically included as part of a table of contents. Once headings are created, we click into the References tab and insert a table ofContinue reading “How to Make a Table of Contents in Word”