by Tito | Jan 8, 2025 | General Productivity, Popular, Uncategorized
Merging separate Word documents into a single file is a typical office challenge. There are many reasons to merge multiple docs into one, including consolidating reports at work, merging chapters of the book you’re writing, or combining meeting notes. There are...
by Tito | Dec 2, 2024 | Uncategorized
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,...
by Tito | Nov 14, 2024 | Excel
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...
by Tito | Feb 11, 2022 | Uncategorized
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...
by Tito | Jul 30, 2021 | Uncategorized
VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn’t enough. I’ve been tasked with finding a way to put return not just the first but the second, and third match. At first, I...
