Hosted on MSN

Old Excel functions you should stop using (and what to replace them with)

Excel is packed with functions, but if you're still relying on VLOOKUP, nested IF statements, or CONCATENATE, you're making your spreadsheets harder to manage than they need to be. Microsoft has newer ...
HUB

Excel 2013 workshop offers tips and tricks

Learn how the new functions in Excel 2013 can increase the accuracy of your data and help you work more efficiently (and pick up those ever-important keyboard ...
Purdue University

Data Visualization with Advanced Excel

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. To perform different types of scenario and ...
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 ...