Category Archives: Uncategorized

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”

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 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”

In this video learn how you can easily record your voice and audio on Windows 10. I walk through two different apps – the first is the Voice Recorder app that comes pre-installed as part of Windows 10. It’s basic but gets the job done. Next, I show Audacity from http://www.audacityteam.org, which is a freeContinue reading “How to Record Voice on Windows 10”

Learn how to install and use Zoom Video Conferencing in this step-by-step tutorial lesson. Host conferences with up to 100 video participants or students for free. Want to use Zoom on your phone? Watch the tutorial here: https://youtu.be/pC1kLG_Mbds In this video, I cover how to download and install the zoom client. I then walk throughContinue reading “How to use Zoom”

Learn how to download and install Microsoft Office, which includes such popular programs as Word, Excel, and PowerPoint, for free on your iPhone or Android device. Not only do I show you how to get the Office app, I also walk through the key functionality of the new Office app.

Get an behind the scenes look at my studio setup for my YouTube videos. Here’s all the primary equipment I use: Cameras & camera stabilization Sony A6500: https://amzn.to/2EElR8A DJI Mavic Pro: http://amzn.to/2kd7UYY GoPro Hero4 Silver: http://amzn.to/2kD6wvh Feiyu Tech G4 Gimbal: http://amzn.to/2kD8QlU Moza Aircross: https://amzn.to/2GW4aTS Lighting Aputure 120dii: https://amzn.to/2TgVf6U Microphones Rode NT-USB Studio: https://amzn.to/2L1okjW Rode NT-USBContinue reading “My YouTube Studio Tour”

earn how to Mail Merge with WPS Office made by Kingsoft. WPS Office is free to download at http://www.wps.com. Mail Merge allows you to send customized envelopes, letters, certificates, and emails. Mail Merge leverages WPS Office documents and spreadsheets. Looking to Mail Merge with Attachments, Custom Subjects, CC / BCC others, or set the defaultContinue reading “How to Mail Merge for Free using WPS Office”