Latest stories

11 Tips to Reduce Excel file size by at least 20%

How do I reduce excel file size? The most often asked question. Well, in this step by step tutorial I’ll walk you through various best practices to reduce excel file size and how to optimize excel workbook to work better. #1 Save your workbooks in a Binary format This is my favorite tip and it always works great. I have been recommending this tip since I started writing this...

FastComet Hosting Review: 21 Reasons Why You Should Buy

Let me get it right.. This is not my regular excel tutorial instead this is a FastComet hosting review — “and of course this is not a paid review – in fact, this website is also hosted with them”¬† In general, this is how it starts… One fine day you come up with an idea to open a website/blog and write about your favourite¬†topic. Then, the process starts like this...

How to fill blanks in Pivot Table [Excel Quick Tip]

Pivot tables are great for summarizing and analyzing data. I use it very often and I believe you too. But there is a small problem… …i.e. pivot tables do not show repeated column labels or content. Meaning – we need to fill blanks in pivot table to do v-lookup Ok..its difficult explain so here is an example. In my above example, the region “East” has...

51 Best Excel Tips and Tricks to skyrocket your productivity [2021 update]

So, you want to learn various excel tips & tricks to up your productivity game? if so, you have landed in a right place. There has been so much written about the best excel tips and tricks on the internet, I could literally find 2,23,000 exact matches by the time of writing this article. So, I don’t want to write one more article with all the garbage. Instead, I have selected these tips...

How to Solve Your Real Problems With Excel Goal Seek

We want to generate $1m Revenue in 2018 said by CEO. Well, that’s ambitious goal… Considering our current year Revenue is at $0.7m but how do we achieve that..? let’s see if we can use Excel Goal Seek to put some foundations. By the way, we are into Chocolate business. I’ll walk you through step by step on building various models to achieve 1m revenue target by using Goal...