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
Category Archives: Uncategorized
How to Set Up Automatic Replies and Out of Office Messages in Outlook – Office 365
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.
How to Convert Word to PDF
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”
How to Calculate Percentages in Excel
In this video I walk through how to calculate percentages in Excel 365.
How to Make iPhone Battery Last Longer
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”
How to Set a Song As Your Ringtone on iPhone
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”
How to Password Protect an Excel Spreadsheet
In this tutorial, learn how you can password protect a Microsoft Excel workbook.
How to make PowerPoint Photo Slideshow
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”
Conditional Formatting in Excel Tutorial
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”
How to Convert Image to Word Document
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