Array formulas may be Excel’s most powerful feature for summarizing data. However, they also are one of Excel’s least-used features. Here’s how to use this hidden power.
Category: Smart Excel Tips
Excelling PivotTables – All you should know about PivotTables
PivotTables are Awesome. Awesome in general, but more specifically awesome for processing large flat tables of data.
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.
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
Microsoft Excel: Useful Functions You Should Get to Know
In this article we’ll discuss categories of functions – what they do and various examples – and to illustrate how they work, we’ll show you several example spreadsheets. We encourage you to follow along by creating your own spreadsheets.
Top 4 Most Important Financial Excel Formulas Explained
Top four important Excel formulas to help you get your finances under control.
Tips for using Excel to make Office Collaboration Smoother & Smarter
Tips for using Excel to make Office Collaboration Smoother & Smarter
How to Decide Which Excel Lookup Formula to Use
If your intent is to someday become an Excel power user, you will need a solid understanding of all the lookup formulas available to you. Below is list of the most popular Excel lookup formulas with tutorials linked as reference.
Use SUMIFS to sum cells that match multiple criteria in Excel
Excel’s SUMIFS function extends SUMIF so you can add up values in a range of cells that meet multiple criteria. Learn to use the SUMIFS function here