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 ...
MUO on MSN

The strangest Excel functions you'll never use

D espite its age, Excel continues to evolve with new functions being added over time. There are newer better Excel functions ...
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 ...
IT Business Edge

Detailed Guide Provides At-A-Glance Excel 2013 Help

Often the task of training new employees or fielding questions about new software falls on the IT department. Though most IT staff is up to the task, it can take time away from their other daily job ...
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 ...