Financial Analysis of buying a motorcycle
Filter and Copy Macro
We come across filtering data a lot in excel. Instead of selecting one by one in a list of hundreds or even thousands, we can use a quick macro to filter that data. The attached excel template in this post lets you filter your data quickly either it has 10,000 rows or 1M. You simply... Continue Reading →
Automate formulas using offset
In this post, I will show you an example of how you can automate reporting using the offset function in excel and save a lot of time. The offset function is very useful for referencing a cell and moving a certain direction from there. For this example, I will use offset and sum functions together... Continue Reading →
Lookup: single and multiple criteria in Excel
In this post, I will discuss how to do a single and multiple criteria Lookup. To get the results, we should be using Vlookup function and Index-Match function. Excel File: lookup https://youtu.be/XcfiFgWRzEA Let's get to single criteria Lookup. For Single criterial lookup: =VLOOKUP(C27,E1:H21,4,0) C27 = The criteria we want to use to get a value... Continue Reading →
Find unique values and duplicate ones – Excel
In this post, I will show you tools in excel that you can use to get unique values from a data set and identify how many duplicate values exist in your data. This is very helpful to do a lot of analysis and creating cheat sheets that you can use an easy Vlookup on. ... Continue Reading →
Identifying changes visually in Excel through conditional formatting
In this post, I will show you how you can visually identify the changes in a data compared to the prior cell. This can be customized to look at 3 columns back, 2 rows up or any cell or range of cells without explicitly defining them. The following video will walk you through the process... Continue Reading →
Reinventing the blog
I have been posting irregularly on various topics ranging from Nepali politics, personal thoughts to social issues until now. I have refocused my attention to my technical strength. I am re-inventing this blog to be an intersection between various tech tools and ways of optimally using it in our daily life. I am passionate about... Continue Reading →