Author Archives: kerrystratvert

In this step-by-step tutorial, learn how to import and dynamically connect web data to your spreadsheet in Microsoft Excel. To import data from the web into your workbook, you need to ensure that there is a table of data on the web site that you would like to import. Once you import your data, ifContinue reading “How to Import Data from the Web in Excel”

Get a first look at the new Rode NT-USB Mini Microphone. Hear sound samples to compare it to the original Rode NT-USB mic and hear for yourself whether it stands up to the likes of the Blue Yeti and the Blue Yeti Nano. Thinking about buying the Rode NT-USB Mini Microphone? Check the latest pricingContinue reading “First look at the new Rode NT USB MINI Microphone”

In this step-by-step tutorial video, learn about when to use a relative cell reference and when to use an absolute cell reference. Access the sheet that I used in this video here: https://onedrive.live.com/view.aspx?resid=B09F9559F6A16B6C!66425&ithint=file%2cxlsx&authkey=!AApe11bg7y2WtC4 By default, a cell reference is a relative reference in Excel. This means that the reference is relative to the location ofContinue reading “Absolute, Relative and Mixed Cell References in Excel”

Learn how to create drop down lists in Excel in this step-by-step tutorial. By using drop-down lists, you can help people work more efficiently in worksheets by allowing people to pick an item from a list that you create. In this video, I show you how to create a pre-defined drop-down list and a drop-downContinue reading “How to Create Excel Drop Down List”

Learn how to close all open apps on the Apple iPhone 11 and 10 in this short tutorial video. I also show you how to close all open apps on older iPhones like the 8, 7, or 6 that have a dedicated home button. The iPhone keeps apps open in the background to improve performanceContinue reading “How To Close All Open Apps On iPhone 11”

In this step-by-step tutorial video, learn how to record your PC screen on desktop or laptop using Microsoft PowerPoint. I show how to record your full screen or just an area of your screen. You’ll also learn how to edit your video, including cropping and trimming and how to export your video, either on aContinue reading “How to Record Screen using Microsoft PowerPoint”

In this step-by-step tutorial for beginners, learn how to use Google Classroom. Google Classroom is a virtual classroom that allows: Teachers to create a class, send announcements, post assignments, distribute materials, post quizzes, grade, give feedback, communicate with students. You can also see who has and hasn’t submitted an assignment. Student to see all assignmentsContinue reading “Google Classroom Tutorial”