CategoryExcel reports

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

1

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

51 Best Excel Tips and Tricks = Professional In Excel [Free Ebook]

5

This is the largest collection of best excel tips and tricks on the web. I know, you have got a lot of advice out there about various excel tips and tricks, but you still tend to crave for more, aren’t you? “Excel Tips” The reason is very simple. Microsoft excel is not just a piece of software, it’s a skill. Burning Glass research suggests that “nearly 8 in 10 middle...

How Planned vs Actual Chart In Excel Can Ease Your Pain

H

The planned vs Actual chart in excel will give you an edge over traditional tabular analysis. In fancy terms, we call it as a Budget vs Actual analysis or Variance analysis. Indeed, it’s quite essential to assess the performance of our plans against actual results periodically. So, in this step by step tutorial, we are going to take a look at how to build planned vs actual graph in excel...

The Step-by-Step Guide to Creating Excel Heat Map That’ll Impress Your Boss

T

Creating excel heat map is an art. You need to know which colour combinations work better for your scenarios. According to a research conducted by Prof. Richard Wiseman, “about 25% of people found documents with colours are easier to analyse”.  In fact, colours can play a pivotal role in your analysis when you use it wisely. For example, if you’d like to highlight high-cost...