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

elink.io | See Original The Superbowl is almost here. If you are tasked with creating blocks for a pool, there's still time to pull out your ruler, draw up a grid, and wrangle a bunch of friends into writing their names in the squares. Or, spare yourself some time...

How to Return Multiple Matches in one Cell Using a lookup?

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...

How to Delete every other Row in Excel

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...
VLOOKUP Reference and Quick Tips

VLOOKUP Reference and Quick Tips

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 one-stop shop to making the most of VLOOKUPs. All the VLOOKUP fundamentals are here...

read more
Stop Wasting Time Rewriting Formulas

Stop Wasting Time Rewriting Formulas

Stop Wasting Time Rewriting Formulas, Save everything in a Scriptionary When’s the last time you spent over fifteen minutes in Excel fumbling through the formula bar to recreate a formula you already know?  The cycle of anger and blame begins as you think “Why didn’t I just save the answer last time?". After first cursing at yourself, the...

read more
How to make Shareable Spreadsheets

How to make Shareable Spreadsheets

I want to share a really helpful concept with my Excel Shortcut readers. It's called Spreadsheet Shareability and it will definitely help you get recognition as an Excel Pro within your Organization. Have you noticed that certain Spreadsheets are shared and/or frequently used throughout organizations? On the other hand, there are worksheets...

read more
3 Reasons to Stop Working Right Now, and Learn Some Excel shortcuts

3 Reasons to Stop Working Right Now, and Learn Some Excel shortcuts

So why do you need to learn Excel shortcuts or any shortcuts for that matter? Let's go over three reasons, and an extra bonus reason of how learning shortcuts will help improve your life. **Reason 1** Saving Precious Time - To save the most time possible, pay close attention to the tasks where you most often reach for the mouse. Common mouse...

read more
The Top Five Technologies to Combine with Microsoft Excel

The Top Five Technologies to Combine with Microsoft Excel

Combine one of these Applications with Excel and Land a Job Right Now. Excel is still the number one application to learn for success in any business arena. Most professionals know this application isn’t going anywhere and have developed some degree of proficiency. To separate yourself from the competition, get versed in at least one of the...

read more
How to Become an Advanced Excel User (or Excel Guru)

How to Become an Advanced Excel User (or Excel Guru)

Speed up your Excel Guru Journey using the following techniques:
1) User Traditional Methods like Excel Tutorials, Training Classes, and Textbooks
2) Combine Excel Projects with Existing Passions
3) Follow the Existing Excel Gurus – Online and in Person
4) Make Sure to Practice a lot – Most effective to Reverse Engineer Great Spreadsheets
5) Master the Shortcuts
6) Teach Others about Excel
7) Create an Excel Related Business

read more
Painting Estimate Template

Painting Estimate Template

Estimate the Amount and Cost of your Next Paint Job Are you ready to start marking up all of the walls in your house with fresh paint? Before you go to the store to purchase the paint for your next job, try using this calculator for an accurate estimate of the paint amount and the Total Cost of the Job. How to Use this paint Estimator tool Start...

read more
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
Share This