Excel Trick - Easy, Smart & Effective!

VBA Wait and Sleep Functions – Explained

Wait and Sleep functionality in programs is required to hold or pause the program execution for a specified time. These methods suspend all the activities

Excel SUMIF and SUMIFS – Explained

As the name suggests SUMIF and SUMIFS formulae are formed by combining SUM and IF functions. In simple English, this implies that these functions can

VBA Substring – How to Substring in Excel Macro

Substring is one of the most popular functions in any programming language. It eases your tasks while dealing with strings. As the name suggests a

Counting Unique Values In Excel – 5 Effective Ways

Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each

HLOOKUP in Excel – With Examples

HLOOKUP function in Excel is a sibling of the VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called

VBA On Error Statement – Handling Errors in Excel Macros

While writing Excel Macros we generally put more focus on the coding part and getting the desired result but during this process, we forget an

VLOOKUP In VBA – With Examples

In my earlier post, I had written about VLOOKUP in Excel. It was a massive post of around 2500 words, it explains most of the

VBA MsgBox – How to use

In VBA, the MsgBox function is used for displaying a dialog box with a predefined message. It returns an integer value based on the button

Sum Cells based on Background Color

Few weeks back, one of my regular visitors dropped me an email describing an issue that he was facing. His task was to add the

VBA DIR Function – How to Use in Excel

DIR is a very special function in VBA, its job is to return a string representing the name of a file, directory, or archive that

VBA Split Function – How to Use

VBA, just like any other language gives you a set of functions to perform various operations on strings. And VBA Split is one of those

Excel VLOOKUP – Massive Guide with 8 Examples

VLOOKUP is one of the most useful and important functions in Microsoft Excel. It is generally used to look up a particular value in huge

Excel Functions

Formula Errors

#N/A Error In Excel – How To Fix

Sometimes, when you’ve used a bunch of lookup tables on your Excel sheet, you might spot a #N/A error. The #N/A error is typically associated

#NAME? Error In Excel – How To Fix

The #NAME? error is a common Excel error because it’s easy to make mistakes that can cause the #NAME? error. In most cases, you’ll be

#DIV/0! Error In Excel – How To Fix

When you’ve done some computations on your Excel sheet, you sometimes look at the whole thing later and find that one of the cells has

#NUM! Error In Excel – How To Fix

The #NUM! error is a frequent visitor on your worksheet. This can make you want to pull your hair out if you’ve used the output

#REF! Error In Excel – How To Fix

Say you’ve got this worksheet from a couple of months ago ready to work with. You pull it up on your computer and start working.

#NULL! Error In Excel – How To Fix

The #NULL! error is less common than other errors like #VALUE! or #NUM! errors. The error is basically Excel telling you that you’ve supplied an

How to Insert, View, Move And Remove Page Breaks in Excel

If you feel your data is crowding the page it is to be printed on and dividing the data would help with clarity, you can

How to Lock Cells in Excel – Protecting Excel Worksheets

Whether you are trying to steer clear of accidental overwrites, feeling fickle, or trying to protect some important data; all your reasons are good enough

How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us

How to Find and Fix Circular References in Excel

A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s

Excel Flash Fill – How To Use

What is Excel Flash Fill, and more importantly, what is so special about it? Flash Fill is a special tool in Excel that can automatically

How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can

How to Calculate Business Days in Excel (3 Easy Formulas)

Where are you from? Are you a TGIF person or is your Saturday spirit drowning somewhere behind the office walls? The most common understanding of

How to Calculate Years of Service in Excel (3 Easy Ways)

Finding out the years of service of employees may come with their resignation. The intent may be to find out the employment duration or to

How to Calculate Weighted Average in Excel (2 Easy Formulas)

We all know how averages work, right? Means or averages are easily calculable and represent a central value. That's all fine for regular numbers but

How to Calculate Square Root in Excel (4 Easy Ways)

Hello there citizen of Excel town! Here's a brainwave. Have you ever thought about getting Excel to do what you have been doing for a

How to Square a Number in Excel (In 5 Different Ways)

The aim is simple. Squaring a number, a number raised to the power 2, the number multiplied by itself; it's all the same thing, you

How to Calculate Age in Excel (7 Easy Formulas)

Excel doesn't have a dedicated function for calculating age, but there are several ways we can use someone's date of birth to compute the person's

Feedback

Excel Trick helped me hone my Excel skills from my college course enough to be able to secure a job during the pandemic. I have now become the excel go-to (still a lot to learn)! So I owe you much of my career. Thanks!

I am writing to thank you for your generosity in sharing your knowledge. You have one of the most useful, unobtrusive sites I have had the pleasure to find. I sincerely appreciate your efforts!

The best excel tutorials I've ever come across! Your articles save me tons of time to do my work, and every formula that I've ever encountered with you has all the right answers!