Microsoft Excel has several built-in hierarchical maps that can help you to build a hierarchy in minutes. Access Excel's array of hierarchy charts through the Smart Art feature.

You can also try using Excel’s built-in Evaluate Formula feature to review array formulas. Here’s how you can do that: First, select the problematic cell and look into its formula bar.

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally. Simply insert the following form as an array: =AVERAGE(IF ...

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Microsoft Excel's dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP(). Image: 200dgr/Shutterstock Must-read Windows coverage.

This function takes a three dimensional array of data with four parameters to track trends as they vary along two variables, opens a new instance of Excel, enters the data in three Excel worksheets, ...