Category Archives: Uncategorized

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”

Learn how to check how much hard drive space you’re using, and if you’re running low, how to clear out space. In this video, I demonstrate how to access the Microsoft Windows 10 storage settings. In storage settings, you can see how much hard drive space you’re using overall as well as by category, likeContinue reading “How to Free Up Space on Windows 10”

Learn how to get the Microsoft Office desktop apps for free, including Word, Excel, and PowerPoint, if you’re an eligible student or educator. All you need is a valid school email address. It’s not a trial – so get started today at https://www.microsoft.com/en-us/educa… Even if you’re not eligible, I’ll show you how to use theContinue reading “How to Get Office 365 Free for Students”