Excel-Applied.com

12/09/2019

Eager to try XLookUp? We have included a lower equivalent of Xlookup in the form of UDF within this article. Read more to find our take on Xlookup and try experiencing it now.

With the recent release of XLookUp for office 365, everyone has been raving about the latest function and how it can replace VLookUp with…

15/08/2019

Always wanted to learn VBA, try learning through the macro recorder function. Come read the basics now!

In all of my training sessions, people have always expressed their desire to learn developing macros and coding VBA for Excel. As always…

14/08/2019

Inheriting files that are too complicated to understand? Use these tips to better understand the formulas.

People come and go in your workplace and many times, Excel files that are used to simplify reporting are passed on from one to another. If…

06/08/2019

We have created a new medium publication to write on Excel Tips and Tricks for everyone to share. Feel free to follow the publication to keep updated with more innovative formulas and projects.

Helping everyone achieve more with Microsoft Excel. From Excel Basics to Advanced VBA, we cover Excel Applications for people from all professions.

29/04/2019

For absolute beginners of Excel or people who wish to know more about cell referencing

A place where words matter

14/03/2019

Everything you need to know about VLookUp and the baffling errors you face using it.

VLookUp is one of the most common formulas used by all working professionals using Microsoft Excel. However, as popular as it may be, most…

12/02/2019

Trim() is a good formula to use to remove all the invisible spaces before and after text. Despite the spaces being invisible, it will still affect your match and lookup formulas.

25/12/2018

Excel-Applied wishes everyone a Merry Christmas and a Happy New year! We promise to be active again in the coming year ahead! Cya!

16/05/2018

See how much you know excel..?

Give this quiz and prove you are a true friend!

06/06/2017

Tip of the day: 1 is different from "1". The former is the number 1 while the latter is a string that contains 1. If you are matching a number to a string or vice versa, you will not be able to get a match. So keep in mind when using lookup or match functions on the data type or you might be confused why your formula is not picking them up.

17/05/2017

Excel Tip:

When using SumIfs(), CountIfs() or other aggregation function, you can use ">35" to represent an inequality comparison in your formula

EG: = sumifs([Revenue],[Price],">=20")

The above formula will sum up the revenue whose price is above or equals to 20

11/05/2017

WHY DOESN'T MY VLOOKUP PICK UP THE VALUE WHEN IT'S THERE!!!???
If you're still baffled, check out this video to find out one of the reason its not working and how to solve the problem?

In this video, we will explain one of the main reasons why your VLookUp or other lookup formulas doesn't work. We will be explaining to you the underlying re...