In this step-by-step tutorial, learn how to use the SUMIF Function in Microsoft Excel. With sumif, you can sum cells that meet a certain criteria. Along with SUMIF, we also look at how to use the SUMIFS function, which allows you to sum based on multiple criteria. Additional resources Sample workbook to follow along TimestampsContinue reading “SUMIF Function in Excel Tutorial”
Category Archives: Microsoft
How to Print Excel Sheet
In this step-by-step tutorial, learn how use Excel page setup and print. We cover how to print to one page, how to print your Excel sheet in A4 size full page, how to include table lines / gridlines, and more. By the end of this video, you’ll know how to customize how your Excel sheetContinue reading “How to Print Excel Sheet”
Excel Tips and Tricks
In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pickContinue reading “Excel Tips and Tricks”
Excel Formulas and Functions | Full Course
In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you’ll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advancedContinue reading “Excel Formulas and Functions | Full Course”
How to Recall Mail in Outlook | Undo Send Any Email
In this step-by-step tutorial, learn how to recall, undo, or delete send mail in Microsoft Outlook. Timestamps 0:00 Introduction 0:40 Recall mail in Outlook desktop 1:20 Recall mail using simplified ribbon 1:38 Limitations 3:01 Delay delivery for an individual email 4:02 Create rule to delay all outgoing emails 6:03 Undo send with Outlook on theContinue reading “How to Recall Mail in Outlook | Undo Send Any Email”
How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio
In this step-by-step tutorial, learn how to make organization charts in Word, Excel, PowerPoint, and Visio. We also look at how you can make your org chart available in Microsoft Teams, Outlook, and even on Office.com using the People Graph. We’ll start with the basics of making an org chart using Smart Art directly inContinue reading “How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio”
How to Make Text to Speech Videos for FREE
In this step-by-step tutorial, learn how to make your own text to speech videos for free that you can use on YouTube, TikTok, Facebook, Instagram, and other video services. With this free text to speech web app, you can choose from 170 unique voices in 70 different languages. The voices cover males, females, neutral, aContinue reading “How to Make Text to Speech Videos for FREE”
How to Increase Wi-Fi Speed
In this step-by-step tutorial, learn how you can improve your Wi-Fi speed using equipment that you already have. By following these steps, I was able to drastically increase my Wi-Fi speed. We start by running a speed test using ethernet to measure how fast your internet is. Next, we measure your Wi-Fi to identify whetherContinue reading “How to Increase Wi-Fi Speed”
How to Setup Dual Monitors on Windows PC
In this step-by-step tutorial, learn how to set up multiple monitors on your laptop or desktop Windows 11 PC. With multiple screens, you can duplicate your monitor, extend your display, or just show on one of your monitors. We walk through how to identify what display port you have on your computer and on yourContinue reading “How to Setup Dual Monitors on Windows PC”
How to Share One Mouse and Keyboard Across Computers
In this step-by-step overview, learn how you can control up to 4 computers from a single mouse and keyboard with this FREE tool made by Microsoft. With Mouse without Borders, you can drag and drop, copy and paste text, screen capture, and transfer files across multiple computers with ease. Additional resources Mouse without Borders webContinue reading “How to Share One Mouse and Keyboard Across Computers”
Kevin Stratvert 