Category Archives for "Excel Tips"

Tips on how to use Microsoft Excel

How to Find and Remove Duplicates in Excel

In working with data from any source, you need to make sure you don’t have duplicate values. In many systems, this can be particularly cumbersome. In my favorite manual data processing tool, Excel, there are a few ways to simplify this process. I’ve used this technique to remove duplicates from Excel for years for its […]

Never See Errors Again in Excel

We’ve already looked at how to use VLookup to return a corresponding value from another sheet here (VLookup Basics). Now we’re going to expand upon that and add some conditional logic to determine if a value exists in another sheet. Our example is looking up order numbers on a separate sheet that contains all returns. By […]

Excel Dashboard Training

In my latest course, Business Dashboard Fundamentals, I cover step-by-step how to make Excel Dashboards. These Excel Dashboards are just one of the two practical methods I provide of building Business Dashboards. Beyond just the practical examples of building Excel Dashboards I cover the fundamental topics of Visual Perception, Common Charts, Dashboard Planning, Dashboard Design, […]