This is a precarious time to write about history's golden ages. Ours is an era of authoritarian and populist revival, with savage dictators trying to extinguish neighbouring democracies, when the fear ...

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

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

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be ...

It is really easy to unhide all rows and/or columns in Excel, but make sure that the cells are not frozen and the sheet is not locked.

In this podcast, former Motley Fool podcast host Chris Hill -- now host of the podcast Money Unplugged -- returns as a guest ...

Enter the “ Column Column Chart ” in Microsoft Excel, a clever visualization technique that combines category-level data with overall totals to tell a more complete story.

If you are working with Excel files with hidden columns, it's important to learn how to unhide columns in Excel to extract maximum data.

For flexibility, Microsoft Excel comes with the Transpose feature, which lets you switch columns and rows in Excel. The Transpose function in Excel changes your columns and rows’ orientation. It ...

The SUM formula can be applied to a certain number or cells or an indefinite series such as an entire column of data, which may grow or shrink at a later time.

How to Sum a Column of Zeros in Excel. You can use the Sum function in Microsoft Office Excel to sum columns of data, whether your data is in an Excel table or is simply a range in a column of ...

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.