Professor Excel

EXCEL ADD-IN: PROFESSOR EXCEL TOOLS

Save a lot of time in Excel!

'Professor Excel Tools' extend your Excel with great new functions. The goal: Make you saving time. Help you with your every day work. Try it for free now - usually it's worth within the first days of use.

TickAdd more than 60 now 90 great functions to Excel

TickExtremely easy to use, lightweight

TickNo sign-up. Try it for free!

Download Free Trial
(Download starts immediately)

YOUR ADVANTAGES

More than 90 features!

Extend Excel with more than 90 very useful features.

Easy to use!

Start right away: Professor Excel Tools are easy to use but still very powerful.

Lightweight!

No crammed computer, no spam. What are you waiting for?

THE FEATURES

features, ribbon, professor, excel, tools, add-in, add-on, plug-in

Copy and Paste Functions

Copy

Copy a range of cells in order to use the special paste functions

Copy Again

Copy the last copied cell range again

Paste as Link and Transpose

With ‘Paste as Link and Transpose’ you can link and transpose your pasted data to the source data.

Paste Exact Formula

With ’Paste Exact Formula’ you can paste a cell or a range of cells without changing their references.Expand example->

For example, your formula in cell A1 links to A2. If you copy and paste it with the normal copy and paste function in Excel to B1, the link will automatically be adapted to B2. Using Professor Excels ‘Paste Exact Formula’ function prevents this – your cell reference will still link to cell A1.

Paste Table Into One Column

‘Paste Table Into One Column’ offers three options for pasting a table underneath each other. A reason could be to make your data “pivotable” (expand details->)

  • Keep original references: If you have formulas within your data, their cell references will persist
  • Paste as values: All formulas will be replaced by their values
  • Link to source: Instead of values or formulas, simple links to original cells will be pasted

Quick Cell Functions

Insert Special Formula

Professor Excel Tools provides a lot of useful formulas which Excel doesn’t have: See all formulas->

PROFEXBackgroundColor: Returns the RGB values of the background color from the selected cell. PROFEXColumn: Returns the column letter (not number) of the selected cell. PROFEXFileName: Returns the filename of the selected cell‘s workbook. PROFEXFontColor: Returns the RGB values of the font color from the selected cell. PROFEXHyperlinkAddress: Returns the hyperlink address of the selected cell. PROFEXIndentLevel: Returns the indent level of the selected cell. PROFEXMaxIf: Returns the maximum from a cell range under a condition in another range. PROFEXMinIf: Returns the maximum from a cell range under a condition in another range. PROFEXSheetName: Returns the sheet name of a selected cell. PROFEXWeekdayName: Returns the weekday name in English of a date.

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 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

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 Heading

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.

Workbook Tools

Table of Contents

Professor Excel offers a feature to insert a new worksheet called ‘TableOfContents’ which contains a list of all worksheets. See details->

You can define the headline color, the headline font color as well as the following specifications for the list of sheets:

  • Do you wish to add links to each worksheet?
  • If you got groups of sheets, for example all Inputs and have separator sheets (‘Inputs–>’ e.g.), Professor Excel can identify them and highlight those sheets in the table of contents.
  • Furthermore, do you want to get a list entry for the table of contents itself?

Table of Colors

Besides a table of contents, you can add a table of color keys.

Recalculate Selection

If you are working with large Excel workbooks and even the manual calculation takes too much time you’ll love this function as it only calculate the selected cell range.

Refresh Status Bar

Professor Excel can show the most important specification of the current workbook in the status bar. Within the settings, you can define what information you want to display in the status bar: Filename, date & time last saved, last saved by, number of hidden and very hidden worksheets and the filesize.

Name Manager

The built-in name manager doesn’t show all the names of your workbook? Use the Professor Excel ‘Name Manager’.

Headers and Footers

Professor Excel provides the functionality to only change the headers and footers for printing worksheets (all other printing preferences will be left untouched). The last settings will be saved, so that you can reapply them comfortably.

Merge Files

Professor Excel copies all worksheets from all selected workbooks into the active workbook.

Compare Sheets

‘Compare Worksheets’ compares two worksheets (for example original and update) and points out all changes. You can define how the differences should be highlighted.

Get Directory

‘Get Directory’ creates a list of all files within a folder and subfolders. You can select the information shown in the list: File name (optionally with a link to the file), file path, date and time last saved, date and time created, file size and file type.

Break Links

‘Break Links’ is a powerful function for breaking links to other workbooks. It can remove the following type of links: Break workbook links, data validation rules, data connections, PivotTables, conditional formatting, named ranges as well as hyperlinks.

Remove Professor Excel Formulas

‘Remove PROFEX from Workbook‘ offers the possibility to remove all PROFEX formulas and replace the cells by their calculated values.

Display and Layout Tools

(Un)hide Rows and Columns

Hide or unhide rows and columns on several sheets or the complete workbook at once, no matter if rows and columns are hidden or grouped. Set a grouping level or expand/collapse grouping or set it to the minimum or maximum level.

Unhide Sheets

Professor Excel Tools provides an easy method of unhide all hidden and very hidden worksheets.

Font Manager

‘Font Manager’ can change the font in your whole workbook or selected sheets to a single font type (Arial e.g.). The font size can also be changed. Of course both font options it can be left untouched as well.

Layout Manager

‘Layout Manager’ comfortably adapts a layout to either all worksheets, selected worksheet or the current worksheet only. See details->

It can define the following layout options:

  • Gridlines: Show, hide or change the color.
  • Zoom: Select a zoom factor.
  • Page break preview: Switch between page break preview and normal view.
  • Formulas: Show formulas instead of the resulting values.
  • Zero values: Show or hide all zero values.
  • Grouping directions of rows and columns.

Sort Sheets

‘Sort Sheets’ can sort the sheets by their name or group them by their tab color. You can choose if you want to sort all worksheets within the active workbook or just selected worksheets.

Finalize Functions

Reduce the File Size

This function helps you to reduce the file size of your workbook: It provides a list of the size in MB of each worksheet and helps you to remove all unused cell ranges. Furthermore it can remove or compress all the pictures in your workbook.

Export Manager

Change one variable from a list and let Excel export it (as PDF or Excel files) or create copies within your current workbook.

Send worksheet as PDF file

Attach the currently selected worksheet(s) as a PDF file with just one click to a new e-mail.

Send worksheet as XLSX file

Attach the currently selected worksheet(s) as a XLSX file with just one click to a new e-mail. Existing workbook links will be cut.

Send worksheet as PDF and XLSX file

Attach the currently selected worksheet(s) as both a XLSX and PDF file with just one click to a new e-mail. Existing workbook links will be cut.

Send entire workbook as PDF file

Attach the current workbook as a PDF file with just one click to a new e-mail.

Send entire workbook as XLSX file

Attach the current workbook with just one click to a new e-mail.

Send workbook as PDF and XLSX file

Attach the currently workbook as both a XLSX and PDF file with just one click to a new e-mail.

Save worksheet as PDF file

Save the currently selected worksheet(s) as a PDF file with just one click.

Save worksheets as XLSX file

Save the currently selected worksheet(s) as a XLSX file with just one click. Existing workbook links will be cut.

Save worksheet as PDF and XLSX file

Save the currently selected worksheet(s) as a XLSX and PDF file with just one click. Existing workbook links will be cut.

Save workbook as PDF file

Save the entire workbook as a PDF file with just one click.

Save workbook as XLSX file

Save the entire workbook as a XLSX file with just one click.

Save workbook as PDF and XLSX file

Save the entire workbook as a XLSX and PDF file with just one click.

YOUR BENEFITS

Save a lot of time!
Start saving time today and try Professor Excel Tools
Improve your results!
Improve your results immediately - what better argument is there for the next career step?
Concentrate on your content!
Don't waste your concentration on Excel - focus on your content and calculations.

 

Still undecided? Try it for free!

Just click the download button and the download starts right away.

 

Download Free Trial
(No sign-up, download starts directly)

System requirements

Professor Excel Tools runs on the following systems:

  • Windows 7 and higher
  • Microsoft Office 2007 and later

Excel on a Mac computer is not supported. The Add-In is built on standard Excel VBA libraries. It only works if Excel Add-Ins are allowed (settings can be changed within the Trust Center). Please use the free trial version for checking if Professor Excel Tools runs on your computer.

Price

Number of licenses/units Unit Price
1-5 USD: 49.99
6-10 USD: 47.99
11-15 USD: 45.99
16-20 USD: 43.99
21-30 USD: 41.99
31-50 USD: 39.99
51-100 USD: 37.99
From 101 USD: 33.99

Please check the order page for the final prices. Also prices in your currency will be shown there.