Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Category Archives for Formulas
How to Calculate Compound Interest in Excel
Compound interest is one of the most important financial calculations which most of us often do in our work.And, it’s must to learn to calculate it in Excel.But, before you do that you need to understand what actually compound interest is.Investopedia says:Compound interest is interest calculated on the initial principal and also on the accumulated […]
➲ Continue ReadingHow to Use Wildcard Characters in Excel
Sometimes working with data is not that easy, sometimes we face complex problems.Let say, you want to search for the text “Delhi” from the data. But, in that data, you have word “New Delhi” not of “Delhi”.Now, in this situation, you can’t match or search.Here, you need a way which allows you to use only […]
➲ Continue ReadingHow Combine IF and AND Functions in Excel
As I told you, by combining IF with other functions you can increase its powers. AND function is one of the most useful functions to combine with IF function. Like you combine IF and OR functions to test multiple conditions. In the same way, you can combine IF and AND functions. There is a slight difference in using […]
➲ Continue ReadingHow To Combine IF and OR Functions in Excel
IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power. Combining IF and OR functions is one the most useful formula combination in excel. In this post, I’ll show you why we need to combine IF and OR functions. And, […]
➲ Continue ReadingVLOOKUP MATCH Combination
In this post, I’ll reveal the secret about how I use VLOOKUP And MATCH to create data for my Dynamic Charts. I’ll also tell you about reasons to use VLOOKUP And MATCH to increase the power of VLOOKUP. But before doing this let me explain you everything about the combination of these two awesome functions.
➲ Continue Reading