When it comes to working with data in a tabular form, most people reach for a spreadsheet. That’s not a bad choice: Microsoft Excel and similar programs are familiar and loaded with functionality for ...

Have you ever wished Excel could do more of the heavy lifting for you? Imagine transforming hours of tedious data cleaning and analysis into just a few clicks. That’s exactly what Microsoft’s ...

Power Pivot excels in handling large datasets and performing complex analytics, using data modeling and DAX expressions, but ...

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

I traded the static results of Flash Fill for dynamic formulas that update automatically.

Jeff Carlson writes about mobile technology for CNET. He is also the author of dozens of how-to books covering a wide spectrum ranging from Apple devices and cameras to photo editing software and ...

Learn to create a yield curve in Excel and understand its implications for interest rate forecasting. Follow our simple guide to plot your own financial data.