Have you got stuck with the lookup related functions in the excel and you end up working with manual work. Then you will find this post related to lookup and reference functions very useful. I know, usually you get busy with other project related work and that’s why you don’t get much time to learn simple yet extremely useful excel ...
Read More »How To
Pivot Tables – Step by Step Guide
I will explain thoroughly how to create pivot tables using one of the real life (engineering ) example using MTO(Material Take-off) list. So let’s start pivoting using Microsoft excel 2010. You can see video here quickly which will show all required steps to create this pivot table. How-to: 1. Insert a pivot table 2. Select the data When you click ...
Read More »7 Excel Functions You Must Know to Work Smarter
Ever wondered how your colleague quickly generated the pivot tables, graphs, or used text/string related functions in excel? It’s easy, it’s just a matter of knowing how it works. I will walk you through extremely useful excel functions required quite frequently while working on excel data. And these are must-know functions for every engineer. In this post, I will cover ...
Read More »