Small Business Computing

Working with Even More Functions in Excel

As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...
Small Business Computing

Working with Functions in Excel

Functions, some of the most useful tools in Excel, let you perform a variety of tasks automatically within a spreadsheet. They return different results depending on certain circumstances, such as ...
MUO on MSN

Your Excel formulas don't have to be unreadable — here's the one function that fixes them

Monster formulas don't have to stay monstrous.
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 ...