News

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.
Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.
Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.
Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.