Excel Formula Errors – Understand and Debug Them
In this installment of spreadcheats we will learn how to understand excel formula errors and fix them. The #DIV/0!, #NAME?, #N/A, #NULL!, #NUM!, #REF!, #VALUE! errors and how to fix them.
Using Array Formulas in Excel – Find if a list has duplicate items
In this installment of our spreadcheats series, we will learn how to use array formulas and findout if a list has any duplicate items. We will use Countif and array formulas to do this …
Excel Conditional Formatting Basics
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of spreadcheats.
How to use Excel Chart Templates and Save Time
Learn how to use excel chart templates in this installment of spreadcheats. Save time.
5 Areas where Mouse Kicks Keyboard’s Butt
We are a big advocate of keyboard shortcuts. I think learning a handful of keyboard shortcuts can improve your productivity tremendously, whether you are using excel or firefox.
But using only keyboard shortcuts is like using only right hand. So, we have compiled 5 incredible ways mouse can help you be productive while using MS Excel.
“Too Many Worksheets” Driving You Nuts? Read This!
Learn how to create Table of Contents in Excel and other tricks to manage when you have too many worksheets.
Make a Dynamic Chart using Data Filters
As part of our spreadcheats series, we will learn how you can use data filters to create dynamic charts in Microsoft excel