Financial Justification – Motorcycle

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...

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...

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...

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.  ...

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...

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...