Excel

I use these four excel functions every time I have to handle messy spreadsheets.

Learn how to create a heat map in Excel using conditional formatting. A heat map is a great tool as it helps you to visualize data and quickly see how the data is distributed. In this tutorial, we cover the following: 1. Creating a Heat Map in Excel Using Conditional Formatting 2. Dynamic Heat Map in Excel Example 1: Heat Map using Scroll Bar Example 2: Dynamic Heat Map in Excel using Radio Buttons 3. Heat Map in Excel Pivot Table #Exceltips #ExcelTricks #MSExcel

Excel has native regex support, and it works exactly how you'd expect.

Excel has better options now!

Excel can do the math. Your job is to tell it what your numbers actually are.

Excel has better options now!

Complex Excel formulas don't have to be intimidating.

Keep the cells but hide their content.

This could totally change how you work in Excel.

Stop manually sorting spreadsheets when Excel's built-in FILTER does the heavy lifting.

Do you want to become an Excel pro? Learn how to use these essential SUM functions and master data analysis like a pro.

To make a workable and practical drop down list in Excel we need to get a sorted unique data for from the data range that is unsorted and has duplicates. An...

In this tutorial learn three techniques to extract unique data from unsorted jumbled data to make dynamic drop down lists that can sort and update even if source data changes. Free Excel #tips, #tricks, #tutorials, #templates, #dashboard workbooks, #formula corebook and #resources.

Learn how to do Running totals and running balance super easily with this technique in Excel Pivot Tables in this step by step tutorial for beginners

Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]