For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

In this guide, you'll learn how to freeze top 2 rows in your Microsoft Excel spreadsheet and keep headers visible while scrolling.

Work Faster in Microsoft Excel: 10 Secret Tricks By Helen Bradley Jan 25, 2012 6:00 pm PST ...

If the AutoCorrect function is not working in Microsoft Excel, it is likely that you haven’t configured the respective options correctly. So, set up the autocorrect options correctly.

Figure B All values in the selected range (C3:F6) equal to or less than the value 21 are red. This is a simple rule in Excel, and you’ve probably applied something similar to your own work.

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial. Image: Aajan, Getty Images/iStockphoto ...

In Excel you have two clear and obvious ways to work on three or more spreadsheets: You can have too-small windows that don’t give you the big picture, or you can clumsily switch between them.

Summarize all your project activities and resources in a separate excel worksheet to be able to speed up the process of creating the work breakdown structure in excel.

How to Plot a Formula in Excel. Unless you are an accountant or a math whiz, the formulas used in financial calculations may seem like random, nonsensical strings of numbers, letters and Greek ...