The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Want to transpose Rows into Columns in Excel or Google Sheets? This post shows how to switch or swap Columns and Rows in Excel and Google Sheets.

Advanced: Creating Partially Filled Column Graphics You can make use of Excel's ability to replace columns with images to create more specific comparisons, like a male-female ratio chart.

Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.