CategoryExcel Formulas

Excel Vlookup Tutorial for Humans [updated for 2021]

E

In this tutorial we will learn how to use VLOOKUP formula in Excel to get things done effectively. In case, If you don’t know what is VLOOKUP then no worries….you are in a right place. I’ll start with basics and then gradually walk you through all real-world use cases. Lets kickstart this Excel VLOOKUP tutorial and get most out of this. Why should you learn Vlookup? Trust me...

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

10 Reasons for Excel Formulas not Working [and How to Fix Them]

1

“Oh My God” excel formulas not working in my report. Sounds familiar right? If so, don’t worry, you are just one among many excel users who face this problem very often. Just think about it. You have built an excel model for Sales Forecast using various logics with fairly complicated formulas. [‘IF’ formulas with 64 conditions – just kidding] And when you try...