Author Archives: kerrystratvert

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”

Learn more about the Personal Vault, a protected area in OneDrive that you can only access with a strong authentication method or a second step of identity verification, such as your fingerprint, face, PIN, or a code sent to you via email or SMS. Your locked files in Personal Vault have an extra layer ofContinue reading “First Look at the OneDrive Personal Vault”

In this step-by-step tutorial, learn how to record your computer screen for free using a free and open-source tool called OBS or Open Broadcaster Software. You can download OBS at http://www.obsproject.com. The screen recorder is very powerful. Watch the video to learn how to configure and set it up. Watch related playlists and videos HowContinue reading “How to Record Screen on PC for FREE using OBS”

In this tutorial video, learn how you can convert an image to text that you can edit using your iPhone or Android phone. I show you how to download and install the free Microsoft Office app and then I convert a letter to text that I can edit on either my phone or PC.

In this short step-by-step video, learn how to resolve the black screen issue in Open Broadcaster Software on Windows 10. My computer recently encountered this issue and I walk through how to resolve it.