Resources

Dynamic Arrays

Dynamic arrays can populate a range of cells from the values of an array. With dynamic arrays, any formula that returns an array of values will spill the results into the adjacent empty cells automatically. You can create tools like interactive pricing...

How to speed up lookup formulas

Lookup functions are extremely useful when working with large data sets. Although they almost always work instantaneously with small data, larger data sets is when things can get rough in terms of performance, as large operations can require more...

How to compare two columns in Excel

Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare...

How to wrap text in Excel

By default, Excel will cut off the characters that don't fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These...

How to use format painter in Excel

The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is...

How to add a custom button to Excel Ribbon

Ability to add a custom button helps you quick access to your macros or favorite actions directly from the Ribbon. The Ribbon was introduced in 2007 and made customizable with Excel 2010. So you can use this trick in all versions starting with 2010. This...