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 ...

How to shop around for medical procedure prices at Rhode Island's 10 hospitals

Opening South County Hospital's spreadsheet, the hernia code is easier to find, as there's only one entry instead of an entry ...
MUO on MSN

Learning REDUCE in Excel completely changed how I use spreadsheets

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...
Family Destinations Guide

The Gigantic Flea Market In Illinois That’ll Make Your Bargain-Hunting Dreams Come True

Sunday mornings in Illinois have a special kind of magic when you’re headed to Wolff’s Flea Market in Rosemont. A sprawling wonderland where bargain hunters and treasure seekers converge in a ritual ...
Houston Chronicle

How to Use Excel VBA for Printing

Millions of small business owners and entrepreneurs all over the world use Microsoft Excel to help with common accounting, forecasting and inventory tasks. With Excel's integrated tools, it is ...
JournalofAccountancy

Using TEXTSPLIT to dissect Excel text strings

Q. I have used the Excel functions LEFT, MID, and RIGHT to dissect cells. However, I have some spreadsheets where each piece of information is a different length and uses different delimiters. Is ...
JournalofAccountancy

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

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...