Save time and improve your reporting skills with these important tips.
Category: Excel Tips
Formula To Count The Number Of Sheets In The Excel
In fact, MS Excel doesn’t have any Straight Formula to Count the Number of Sheets in the Workbook. But, we have Indirect Way to Count the same. Check in here for simple step by step instructions.
5 Interesting and Funny Excel Tricks You Must Know
MS Excel is a sea of knowledge. Whatever proficiency you may have in Excel but still I would say there would be a lot of thing yet to be known. I just love MS Excel. Lets learn these funny and interesting Excel tricks.
3 Crazy Excel Formulas That Do Amazing Things
In this article, I plan to show you how powerful formulas and conditional formatting can be, with three pretty useful examples.
10 Things You Should ALWAYS Do (or Not Do) in Excel
I have jotted down a list and had ten things before I knew it, so here goes! They’re numbered…but they’re in no particular order.
Automate Excel Charts in Two Keystrokes
Today I’ll show you how to automate an Excel chart with just two keystrokes. I’ll first show you the typical way that most users accomplish adding data to a chart, and then I’ll share the simple technique that eliminates this mundane need.
Three Key Principles of Visual Design in Excel
Visual Design is a concept that many people don’t think about when using Excel. These are simply three things you should keep in mind whenever creating an Excel output.
Common Microsoft Excel Problems – Solved!
Here is the list of Common Microsoft Excel Problems – with solutions.
Solutions to Three Common Problems when Using VLOOKUP()
This article addresses some common issues you may encounter when you use the VLOOKUP function.
Top 10 ways to Clean your Data in Microsoft Excel
Here are the top ten ways to clean the data, and briefly describe the importance to data mining