PivotTables are Awesome. Awesome in general, but more specifically awesome for processing large flat tables of data.
Articles Tagged: Excel Tips
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.
Conditional Formulas in Excel & Tricks Using the IF Function in Excel
If ever there was a single function in Excel that I use the most, it’d probably be the IF function. It is a workhorse as far as I’m concerned, as it can be used in combination with several other functions for a plethora of purposes. Along with other Logical Functions like AND, OR, NOT, TRUE, and FALSE, you’ve got all the ingredients you need to create some really cool formulas that will help you not only sort your data, but can even help improve the aesthetics of your spreadsheets and help to automate the analysis of your data. Here are some reasons why I have unconditional love for conditional formulas in Excel.
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
Top 5 Benefits of Microsoft Excel
Microsoft Excel helps companies maximise the value of their data, helping to control costs more effectively and obtain business information.