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 »