Learn how to use the Excel PowerPivot functionality for data modeling in data analysis in your spreadsheets. Once mastered this function ...

AI isn't changing everything. Spreadsheet whizzes are still competitive in the current job market.

As I mention in How to use Excel’s Data Model to turn related data into meaningful information, you might create complete records on a single sheet using complex formulas to lookup data.

Data analytics is the science of analyzing raw data to make conclusions about that information. It helps businesses perform ...

Learn how to use Microsoft Excel to unearth and interpret the wealth of data hidden in the general ledger.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

When most people think of Microsoft Excel, they think of organizational charts, budgets and quantitative formulas. However, there is much more to Excel than data manipulation. Adding multimedia ...

Learn how to use a 3D animated model in Microsoft Excel. 3D models are 3-dimensional objects, and they can be animated.