At this page, I will share Tips & Tricks on using Excel (E.g: Introduction to functions and shortcut keys). Stay tuned to this page for more updates!
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.
XLookup, is it really worth the rave? 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!
The easiest way to learn Excel Macros interactively 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.
What to do when stuck with a file with complicated 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.
Microsoft Excel Analytics – Medium 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
“Microsoft Excel Essentials — User-Interface and 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.
Struggles of Using VLookUp() VLookUp is one of the most common formulas used by all working professionals using Microsoft Excel. However, as popular as it may be, most…
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.
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..?
BuddyMeter -How Well Do You Know Your Friend? Give this quiz and prove you are a true friend!
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.
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?
Excel Tips & Tricks - Why doesn't my VLookUp Work 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...