Author Archives: kerrystratvert

In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you’ll understand the fundamentals ofContinue reading “How to use Microsoft Access – Beginner Tutorial”

In this step-by-step tutorial, learn how to properly play video and audio in Microsoft Teams meetings. Oftentimes, when you play video or music, your audience is unable to hear. I’ll show you how to play system sound. I’ll also show which sharing modes support computer sound and which ones don’t. Lastly, I also show howContinue reading “How to Play Video & Music Properly in Microsoft Teams”

In this step-by-step tutorial, learn how to create 3D objects and scenes using Microsoft Paint 3D. Paint 3D comes for free with Windows 10. Paint 3D is a raster graphics and 3D modeling application which is a refresh of Microsoft Paint. Paint 3D incorporates features of the Microsoft Paint and 3D Builder applications to combineContinue reading “How to use Microsoft Paint 3D”

In this step-by-step tutorial, learn how to use animations in Microsoft PowerPoint. Learn animation fundamentals, layer on multiple animations, adjust the duration and speed, and build out a complete animation scene. You’ll also learn how to use morph and advanced morph to animate objects. At the end, you’ll learn how to animate 3D objects. ByContinue reading “PowerPoint Animation Tutorial – Learn How To Animate”

In this step-by-step tutorial, learn how to use Power Pivot in Microsoft Excel. Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment,Continue reading “How to use Power Pivot in Excel”

In this step-by-step tutorial, learn how to use Goal Seek & Solver in Microsoft Excel. With Goal Seek, you can find the result you want by adjusting an input value. Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for aContinue reading “How to use Excel Solver & Goal Seek”

In this step-by-step tutorial, learn how to use VLOOKUP, HLOOKUP, AND XLOOKUP in Microsoft Excel. With VLOOKUP, you can find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. Additional resources:Continue reading “How to use VLOOKUP in Excel – Complete Tutorial”

In this step-by-step tutorial, learn how to create a fillable PDF form for free using LibreOffice (previously known as OpenOffice). LibreOffice is free and open source software that allows you to create forms and export as a PDF form. When you distribute your form, others can fill out your form easily. Once they complete yourContinue reading “How to Create Fillable PDF Form for FREE”

Learn how to get free Roblox gift cards that you can redeem for Robux using Microsoft Rewards. In this step-by-step tutorial, I’ll show you how to set up an account, how to earn points, and how to redeem your points for free Roblox gift cards. Microsoft Rewards offers free points for searching on Bing usingContinue reading “How to get FREE Robux using Microsoft Rewards”

In this step-by-step tutorial, learn how to merge multiple PDF files into one for free using online tools and an app that you can install on your PC. With an app on your PC, there are no limits to how many PDFs you can merge and the PDF never leaves your computer, offering a higherContinue reading “How to Merge PDF Files into One”