7 EXCEL TABLES BEST KEPT SECRETS
When was the last time you used excel tables? Do you know how powerful excel tables are? If you...
7+ WAYS TO LOOKUP NUMBER VALUES
The ability to lookup number values in excel is a must-have for all data analysts. Some Excel...
HLOOKUP with multiple criteria (OR/AND logic)
When was the last time you comprehensively looked at the HLOOKUP function and its alternative? To...
FOMC Dot Plot Chart Using REPT Function
On Linkedin, a user commented on how he has been struggling to recreate the Federal Reserve dot...
This is an Example of a Right Sidebar Blog Post
This is an example of a WordPress post, you could edit this to put information about yourself or...
This is an Example of a Full Width Blog Post
This is an example of a WordPress post, you could edit this to put information about yourself or...
This is an Example of a Right Sidebar Blog Post with Commenting
This is an example of a WordPress post, you could edit this to put information about yourself or...
This is an Example of a Left Sidebar Blog Post
This is an example of a WordPress post, you could edit this to put information about yourself or...
7 WAYS TO USE EXCEL REPT FUNCTION
When is the last time you used the REPT function in Excel? REPT is one of excel's...
How To Replace Nested IF Function: 14 Alternatives
IF function is one of the most used functions in Excel. In my opinion, it is the foundation of all...
FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA
In the previous article, we looked at 6 ways to find the last or Nth occurrence in a Sorted list...
FIND THE LAST OR Nth VALUE IN EXCEL (SORTED LIST)
Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not...