How-To Geek on MSN

How to use the PivotTable Fields pane in Microsoft Excel

You can create a PivotTable in Excel from an external data source, a table in your worksheet, or a pre-built data model. To ...
JournalofAccountancy

Using 3 Excel View tools to manage large spreadsheets

Q. I work with large spreadsheets. These spreadsheets have hundreds or even thousands of rows and often 10 or more columns. It’s so much to process that I become confused and make mistakes. Does Excel ...
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

If you would like to follow along in using these functions, you can download this Excel workbook and view the video at the ... This time, I need it to start reading from the end of the text string and ...