Category Archives: Uncategorized

Learn how to use formulas in Excel, including the following functions & formulas: Timestamps 0:00 Introduction 0:55 Add 1:55 Subtract 2:18 Multiply 2:50 Divide 3:20 Sum 4:46 Min 5:05 Max 5:30 Count 6:15 Counta 6:48 Average 7:20 Median 7:54 Concatenate 8:29 If 9:10 Countif 9:40 Vlookup 10:58 Sumif 11:46 Current Time

Learn how to set up automatic replies in Outlook Desktop and Outlook on the web for when you go on vacation or when you’re out sick. To set an out of office reply, click on File and select Automatic replies.

Learn how to make a PDF file by easily converting a Microsoft Word document to an Adobe PDF file. In this tutorial, I show you how to convert a Word to PDF using Word that comes with Office 365. I also show you how to convert a Word document to a PDF using Office.com, whichContinue reading “How to Convert Word to PDF”

In this video I walk through how to calculate percentages in Excel 365.

In this video, learn 10 different ways to keep your battery working longer. Techniques include the following: Turn off your phone Stop searching for a signal. Use low power mode Don’t run battery all the way down Turn off vibrate Turn down brightness Avoid using unnecessary apps Keep calls short Turn off cellular data AvoidContinue reading “How to Make iPhone Battery Last Longer”

Learn how to set a song as your custom ringtone on your iPhone in this short tutorial video. Open iTunes Make sure that your song is in iTunes Find the section of the song that you want to use Open the song’s information menu – Click the song to select it, click Edit (Windows) orContinue reading “How to Set a Song As Your Ringtone on iPhone”

In this tutorial, learn how you can password protect a Microsoft Excel workbook.

Learn how to create a photo slideshow in Microsoft PowerPoint in this tutorial video. See step-by-step how to import photos, how to make quick edits to the photos, and how to bring them into a slide presentation. See how to set a time for the photos to stay on the screen. See how to addContinue reading “How to make PowerPoint Photo Slideshow”

Learn how to use conditional formatting in Microsoft Excel in this step-by-step tutorial. I cover the following: Highlight cells, including greater than, less than, between, equal to, text that contains, a date occurring, duplicate values Top and bottom rules, including top 10 items, top 10%, bottom 10 items, bottom 10%, above average, below average DataContinue reading “Conditional Formatting in Excel Tutorial”

In this tutorial video, learn how you can use Microsoft Word to convert a photo (e.g. jpeg, gif, png) into an editable Word document. You can now take a photo of a document and create editable text using the free Microsoft Office app available on both iPhone and Android. Watch my video here: https://youtu.be/B5eTrwlIZtE