XLOOKUP in Excel – Tutorial for Beginners

In this step-by-step beginner’s tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let’s say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have anotherContinue reading “XLOOKUP in Excel – Tutorial for Beginners”

Excel Macros & VBA – Beginners Tutorial

In this step-by-step overview, learn how you can eliminate repetitive and boring tasks in Microsoft Excel using something called macros and VBA, or Visual Basic for Applications. With macros, you can automate your work in Excel, which will help you save time and effort. Macros are an extremely powerful tool that will take your usageContinue reading “Excel Macros & VBA – Beginners Tutorial”

How to Build Search Box in Excel

In this step-by-step overview, learn how to add an advanced search box to your Excel workbook. You can insert a search box with no knowledge of VBA or coding. Imagine you have a cookie customer list, and you want to find the chocolate chip cookies, you can insert a search box to find that. We’llContinue reading “How to Build Search Box in Excel”

How to Convert PowerPoint to PDF

In this step-by-step overview, learn how to convert a Microsoft PowerPoint presentation into an Adobe PDF. We look at three ways to export your PowerPoint to PDF, including using File – Export, File – Save As, and File – Print. We also explore various options, like converting all slides or just a range of slides,Continue reading “How to Convert PowerPoint to PDF”

How to Add Watermark to Word Document

In this step-by-step tutorial, learn how to insert a watermark into a Microsoft Word document. You can select a preset watermark, like confidential, disclosure, or urgent. You can also customize a watermark to include any text. You can adjust the font, size, color, and even the transparency. Lastly, we look at how to insert aContinue reading “How to Add Watermark to Word Document”

How to Create Parallax Effect in PowerPoint

In this step-by-step tutorial, learn how to create the Parallax Effect in Microsoft PowerPoint. Parallax is sure to impress your audience. You’ll be viewed as the expert in PowerPoint. One word of caution, you don’t want to overuse this in your presentations. I’d recommend just using it once in a presentation. We start by pullingContinue reading “How to Create Parallax Effect in PowerPoint”

How to Perfectly Align & Distribute Objects in PowerPoint

In this step-by-step tutorial, learn how to align objects like pictures, text boxes, and shapes perfectly. We look at three different tools. First, we explore how the helper lines help place objects on the slide and in relation to other objects on the slide. Next, we look at how to use the ribbon alignment tools.Continue reading “How to Perfectly Align & Distribute Objects in PowerPoint”

How to Link Excel to PowerPoint to Update Data Automatically

In this step-by-step tutorial, learn how you can link a Microsoft Excel spreadsheet to a PowerPoint presentation. When you update the table or chart in Excel, PowerPoint will also update. Additional resources How to make animated cartoon character of yourself: https://youtu.be/7KXrLkghRfg Timestamps 0:00 Introduction 0:49 Link Excel table to PowerPoint 3:10 Link Excel chart toContinue reading “How to Link Excel to PowerPoint to Update Data Automatically”

How to Turn Data into Interactive Map Chart in Excel

In this step-by-step tutorial, learn how to take data and transform it into a visual map using Microsoft Excel. First, we look at how to create an Excel map using two columns of data. Next, we explore how to create a dynamic map that you can interact with using a drop-down list. With a dynamicContinue reading “How to Turn Data into Interactive Map Chart in Excel”

How to Make Animated Cartoon of Yourself in PowerPoint

In this step-by-step tutorial, learn how to make an animated cartoon of yourself in Microsoft PowerPoint. We start by using a free add-in called Pixton Cartoon Characters to create an avatar of yourself. You can choose the body type, color, hair, outfit, and the pose. Pixton remembers what characters you’ve created so you can quicklyContinue reading “How to Make Animated Cartoon of Yourself in PowerPoint”