Formula Assistants Menu

Part of the Spreadsheet Assistant — a menu full of functions that save you time with formulas and numbers.

The following is the Formula Assistants menu that appears when you click on the Formula Assistants button. Any of the features can be added to Excel’s quick access toolbar for instant use at any time.

  • Perform Any Math Action on a range of cells (ex: + 100, * 25) while retaining existing formulas
  • Convert Text Numbers to Numbers for values imported from the internet or systems like SAP
  • Convert Trailing Negatives to Leading Negatives (6- becomes -6)
  • Adds a number of useful new functions to Excel
  • Any feature can be added to Excel's quick access toolbar for instant use
Formula Assistants menu in Excel
The Formula Assistants menu

The Formula Assistants is full of functions that will save you time. One we use a lot is the Perform Any Math Action feature. We just select a range of cells, click the menu item, type in the action (ex: + 100, * 25, etc) and click OK. Instantly the cells are modified — and existing formulas retained! It has saved us endless hours of work.

If you ever import numbers from the internet or from accounting systems like SAP, the numbers that come in are either text entries that you can’t use because Excel doesn’t recognize them as numbers, or they have the minus sign on the right (6-) instead of the left (-6). The Spreadsheet Assistant adds two features that solve this problem: Convert Text Numbers to Numbers and Convert Trailing Negatives to Leading Negatives.

The Spreadsheet Assistant also adds a number of useful functions to Excel. View a list of the new functions added to Excel.

Customers who viewed this also viewed