Spreadsheet Assistant's Formula Assistants Menu

Time-saving formula features added to Microsoft Excel.

Download a trial version now!

The following are just a few of the time-saving data features added by the Spreadsheet Assistant that make Microsoft Excel easier to use:

  • 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

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.

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 does not 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.

Return to the Spreadsheet Assistant overview to explore all the other assistant menus.

Customers who viewed this also viewed