Author Archives: kerrystratvert

In this step-by-step tutorial, learn how to take a screenshot on Windows 10 using the Snip & Sketch tool that comes pre-installed with Windows 10. Resources called out in this video: How to Upgrade to Windows 10 for free: https://youtu.be/jrEZMDhf4Qw Timestamps 0:00 Introduction 0:49 Launch Snip & Sketch 1:56 Multiple ways of capturing screen 2:44Continue reading “How to Screenshot on PC”

In this step-by-step tutorial, learn how to Mail Merge using Excel Online and Power Automate. Once your Mail Merge is ready, send your emails using Outlook or Gmail. All of these tools are free to use. Customize and personalize everything, including the to/cc/bcc recipients, the subject, and even include custom attachments. This is the ultimateContinue reading “How to Mail Merge using Power Automate”

In this step-by-step tutorial, learn how to use stock images, icons, cutout people, stickers, and illustrations in your Word documents, Excel spreadsheets, and PowerPoint presentations. Timestamps 0:00 Introduction 0:56 Requirements 1:21 Insert stock photos 2:14 Browsing & finding stock photos 3:40 Icons 4:02 Cutout people 4:54 Stickers 5:13 Illustrations 5:50 Formatting objects on slide 6:22Continue reading “How to use Stock Photos in Word, Excel and PowerPoint”

In this step-by-step tutorial, learn how to record your PowerPoint presentation as video. Watch how to insert a narration, video, and then export your PowerPoint to a video presentation. Timestamps 0:00 Introduction 0:41 Use PowerPoint to make video 7:03 Export as video 9:28 Use OBS to make video 13:34 Wrap up

Follow these quick steps to find out whether Windows 11 will run on your computer. Microsoft recently announced Windows 11 and there are several new features, speed improvements, a new look and feel, and best of all, it’s a free upgrade. But there is also a higher bar for the system requirements. Find out ifContinue reading “Windows 11 Requirements: Can your PC run it?”

In this step-by-step tutorial, first we learn how to create a basic dropdown list in Microsoft Excel. Next, we look at how to create multiple dependent drop-down lists. With multiple dependent drop-down lists, the second or the subsequent drop-down list adjusts based on the selection in the first drop down list. This is helpful toContinue reading “How to Easily Create Multiple Dependent Drop-Down Lists in Excel”

Find out about 5 features that’ll make Windows 11 even better. Speak to your PC and have your computer write what you see, including all punctuation. Set up multiple desktops to separate your work and customize those desktops with names, backgrounds, and ordering. Snap your windows more easily using a new snapping helper. Also, findContinue reading “5 Awesome Windows 11 Features you should use”

In this step-by-step overview video, get an overview of everything that is new in the Windows 11 insiders preview build (22000.51). Microsoft released the insider preview on Monday and there are lots of new features and capabilities to explore. We start by looking at the task bar and how it’s centered aligned. We also lookContinue reading “In-depth Look at Windows 11 Insider Preview”

In this step-by-step tutorial, learn how to use Microsoft Whiteboard in Microsoft Teams and as a standalone app. Create a new whiteboard and collaborate with others at the same time. Bring ideas, content and people together – from your computer, phone or tablet. Timestamps 0:00 Introduction 0:52 Launch whiteboard in Microsoft Teams 1:25 Using WhiteboardContinue reading “How to use Microsoft Whiteboard”

In this step-by-step tutorial, learn about 3 new presentation tricks that will make your next MS Teams meeting even better. Standout while presenting in front of your content. With standout, you’ll overlay any content that you share on your screen. Next, we look at annotation tools that are available in PowerPoint Live. With annotation tools,Continue reading “3 AMAZING Presentation Tricks that will make your Next Microsoft Teams Meeting BETTER”