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...
Have you ever needed to delete every other row in Excel? You are not alone. There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...
There are plenty of websites that display stock tickers, technical information, and other important stock Information. Even though several websites do a fantastic job, sometimes you want to analyze them in your own little spreadsheet. Getting Stock Market Data into...
We will create some brand new tables in SQL Management Studio using Excel as a template in this tutorial. The sample data is a fictitious list of Experts and their areas of specialty. Below is a quick Description of our tables and a short sampling of each. This...
Vlookup has been a leading feature of Microsoft Excel for a long time. For many users, its the first function they think of when opening a spreadsheet. Excel has several types of Lookups but VLOOKUP is the most commonly used of the bunch. Let this page be your...
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,...
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...
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...
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...
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 tried to...
