How to Compare Two Sets of Data in Excel with AI

Do you need help reconciling data from two different workbooks in Excel? Today, I will show you how to make quick work of duplicate records.   While Excel is my go-to tool for making sense of data, this demo compares two Excel-based data sets using a brand-new tool,...

Tired of Nested IFs in Excel? Make this SWITCH!

The Nested IF Nightmare Every Excel worksheet starts innocent enough. You open the formula box and create a simple “if this, then that” formula. The logic is clean, but you need to add one more condition. And then another one. Next thing you know, you’re drowning in...

Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

Updated for Superbowl 57 This Version is unlocked, so be careful with the formulas. You have to press F9 to Regenerate the squares because calculations are set to manual. This spreadsheet is for educational purposes only. Please check your local gambling restrictions...
How to Add a Microsoft Excel 365 File to WordPress Website

How to Add a Microsoft Excel 365 File to WordPress Website

Summary WordPress is an effective all-around Content Management tool. The frequent updates to the software help them to keep up with the latest trends and can keep its user's sites on the cutting edge. Unfortunately, when WordPress releases a patch, the functionality of some of its old features can be lost or rendered less effective. To counter...

read more
Mulch Estimator

Mulch Estimator

If you have an upcoming yard project and you need to know how much mulch to purchase I suggest downloading the Attached Spreadsheet for an accurate estimate. The tool also is great for estimating the cost of the project and evaluating bulk mulch delivery or digiorno... I mean delivery or buying bags of mulch at the store. I'm no expert in...

read more
Excel Guide to Lookups and Matching Cells

Excel Guide to Lookups and Matching Cells

Excel Guide to Lookups and Matching Cells Overview Lookup functionality is undoubtedly one of the most heavily used features in Microsoft Excel. There are several functions or formulas used to look up Excel information. Today we will learn about some commonly used lookups and whether they can be used more effectively. The most popular approach to...

read more
Identify Duplicate Cell Values in Excel (3 Ways)

Identify Duplicate Cell Values in Excel (3 Ways)

“There’s more than one way to skin a cat,” one of my instructors would often say. While the instructor who frequented this phrase may be a sick freak, the memorable phrase rings true for many situations in life. It absolutely applies to excel problem solving where different strategies or formulas can be used to address a data-related challenge....

read more
Ultimate Guide to Cell References

Ultimate Guide to Cell References

Cell References In storytelling, a static character maintains the same persona from the beginning of the novel until the end. A good example would be the ultra-intelligent, pipe-smoking crime detective Sherlock Holmes. Conversely, a dynamic character is more malleable and transitions throughout the trials of the narration; think Edmund Dantes of...

read more
4 Most Useful Excel Functions

4 Most Useful Excel Functions

4 Most Useful Excel Functions Microsoft excel is a powerful tool used for data manipulation and organization. The mastery of its functions and formulas can help you exceed expectations and make you a Rockstar among your cubicle mates. However, new excel users may find the multitude of options overwhelming. If you are unfamiliar with excel, here...

read more