Professor Excel Tools Premium

Professor Excel Tools Premium Overview

‘Professor Excel Tools’ extends your Excel with great new functions. The goal: Help you with your every day work. Try it for free now – usually it’s worth within the first days of use. Add more than 120 great functions to Excel. Extremely easy to use, lightweight.

Features of Professor Excel Tools Premium

• Insert Special Formula
  Professor Excel Tools provides a lot of useful formulas which Excel doesn’t have: See all formulas->
• Insert IFERROR
  Easily wrap the ‘IFERROR’ formula around your existing formula on all selected cells. If your formula is already wrapped in an IFERROR formula, the existing IFERROR formula will be updated. Instead of IFERROR, you can also insert IFNA.
• Swap Two Cells
  Swap two cells: Quickly exchange two cells. You can define within the settings, if existing cell links should adapt as well or not.
• Insert ROUND
  Easily wrap the ‘ROUND’, ROUNDUP or ROUNDDOWN formula around your existing formula on all selected cells.
• Delete Last Letter if Blank
  ‘Delete Last Letter if Blank’: If the last character of a text cell is a space, it‘ll be deleted. This is especially useful if your data is not consistent for example if VLOOKUPs etc. don’t work.
• Force to Number
  ‘Force to Number’: Sometimes, Excel won‘t apply a number format although a cell value is a number. ‘Force Cell Format to Number’ is especially strong as it removes all blank characters, tries switching points and commas and removes possible thousands separators.
• Remove Conditional Formatting
  You want to remove the conditional formatting rules but keep the format? No problem, select the cells and click the “Remove Cond. Formatting” button.
• Quick Number Format
  Define your favorite number format within the settings and apply it with just one click.
• Show as Thousands
  Display all selected cell values in thousands with just one click.
• Show as Millions
  Display all selected cell values in millions with just one click.
• Format as Headin
  Add your favorite ‘Heading Format’ to heading cells with just one click. You can change the format within the settings.
• Format as Value Cell
  Add your favorite ‘Content Format’ to content cells with just one click. The formatting of values (e.g. number, date) won’t be affected. You can change the format within the settings.
• Clean Formulas
  You don’t like messy, long formulas? Remove the own sheet name or all ‘=+’ in the beginning of the formula.

System Requirements for Professor Excel Tools Premium

RAM: 2 GB

Operating System: Windows 7, 8, 8.1, 10 and 11

Space Required: 10 MB