Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I’ve accepted a job ...

Ditch manual sorting for live formulas that rank top performers, fastest times, and equal scores as data changes.

The CHOOSECOLS formula is a catalyst when it comes to selecting specific columns from a table. This formula allows you to streamline your data analysis process by quickly and easily extracting the ...

Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some ...

Excel’s FIND function detects case differences to prevent mismatched IDs, flawed lookups, and hidden data errors.

Q. Is there a way to conditionally format Excel so that my formulas automatically display a different font color? In this example, we have now successfully applied conditional formatting to cell A1, ...

The company is adding some handy automation features to its web-based spreadsheet software. The company is adding some handy automation features to its web-based spreadsheet software. Microsoft has ...

If you are looking to learn and understand the basics of Microsoft Excel, this tutorial will guide you through all the essential features you need to know. Excel is the premier application used by ...

Microsoft Excel receives new features on a regular basis, which is important considering how widely it is utilized for various use cases, including data crunching, visualizations, and organization. A ...

There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets. Fortunately there a couple of ways you can combine multiple ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

Microsoft's program is capable of far more than you might imagine. Here are the hacks and tricks you need to know to make the ...