Category Archives: Excel How To Videos

Simple and easy to follow excel how to videos.

How To Delete Duplicates In Excel: In Just One Click

Click here to view our video tutorial Click here to download our PDF tutorial Duplicate entries have a way of sneaking into even the most carefully kept spreadsheets. Maybe you merged two contact lists, imported data from a form that … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , | Comments Off on How To Delete Duplicates In Excel: In Just One Click

How To Combine Two Columns In Excel: No Formula Needed

Click here to view our video tutorial Click here to download our PDF tutorial If you’ve ever needed to merge a First Name and Last Name into one Full Name, you already know the usual routine: type a formula in … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , | Comments Off on How To Combine Two Columns In Excel: No Formula Needed

How to Find and Use a Grocery List Template in Excel 365

Click here to view our video tutorial Click here to download our PDF tutorial A grocery run rarely goes as planned when the list lives on the back of an envelope or scattered across text messages to yourself. Items get … Continue reading

Posted in Excel How To Videos | Comments Off on How to Find and Use a Grocery List Template in Excel 365

How to Find and Use a Summer Activity Calendar Template in Excel 365

Click here to view our video tutorial Click here to download our PDF tutorial Summer schedules have a way of filling up fast. Between camps, vacations, birthday parties, pool days, and family visits, it’s easy to lose track of who’s … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , | Comments Off on How to Find and Use a Summer Activity Calendar Template in Excel 365

How to Find and Use a Profit and Loss Statement Template in Excel 365

Click here to view our video tutorial Click here to download our PDF tutorial Business owners juggle numbers from a lot of different places — sales figures, expense receipts, tax records, and profit margins — and keeping it all straight … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , | Comments Off on How to Find and Use a Profit and Loss Statement Template in Excel 365

How to Find and Use a Trip Planner Template in Excel 365

Click here to view our video tutorial. Click here to download our PDF tutorial. Planning a trip involves juggling a lot of moving pieces — flight times, hotel confirmations, daily activities, and of course, your budget. Rather than tracking all … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , , , , , | Comments Off on How to Find and Use a Trip Planner Template in Excel 365

How to Use the Excel QR Code Generator in Excel 365 (Step-by-Step Guide)

Click here to view our video tutorial. Click here to download our PDF tutorial. If you’ve ever wanted to create a QR code directly in Excel without relying on outside tools, you’ll be glad to know that Excel 365 includes … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , , , , , | Leave a comment

How To Remove Numbers After the Decimal in Excel

Click here to view our video tutorial. Click here to download our PDF tutorial. How to Remove or Hide Numbers After the Decimal in Excel (Step-by-Step Guide) If you work with numbers in Excel, you may often find decimal places … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , | Leave a comment

How to Remove Conditional Formatting in Excel (Entire Worksheet)

Click here to view our video tutorial. Click here to download our PDF tutorial. If you’ve applied conditional formatting to your Excel worksheet and it doesn’t look quite right, you may want to remove it and start over. Conditional formatting … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , | Leave a comment

How To Use Conditional Formatting Traffic Lights In Excel

Click here to view our video tutorial. Click here to download our PDF tutorial. Want to add traffic light icons to your Excel data to quickly spot trends? In this guide, I’ll show you exactly how to use conditional formatting … Continue reading

Posted in Excel How To Videos | Tagged , , , , , , , , , , , , , , , | Leave a comment