The PC HelpSite
www.officehelp.biz
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
ExMiniTools - Utilities Toolbar for Microsoft® Excel®

Application Microsoft Excel Version 2.00
Author OfficeHelp
Tested on versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any version from Office 97


Additional Functions & 1 Click Buttons for Excel® with AUTOMATIC SORTING (data changed? just recalculate to sort), EXACT COPY/PASTE (no formula changes), COMPARE FORMULAS in 2 ranges, COUNT UNIQUE values in ranges, RANK numbers in a range (is it the 1st or 4th?), RESTORE ADDIN FUNCTIONS (automatically remove file path from functions), apply ALTERNATE BACKGROUNDS (Row/Column) for easier table reading, automatically REMOVE #ERRORS and 1 Click access to 9 common features.

Contact Us for Support Manual / How-To FREE DOWNLOAD

New WORKSHEET functions

Automatic Sorting for Excel  - Data Changed? Just Recalculate!

Create ALWAYS SORTED tables (and charts) from your own data like Sales per Unit, Budget variations or any other! Use our functions to automatically get the numbers in the correct order:

Create Rankings (Top Sellers)
Click to Enlarge
Actual to Budget variations
Click to Enlarge

Ascending or Descending
Data changed? Just recalculate to reorder!

  • ASCENDING or DESCENDING
     
  • Reuse the same Templates (files) for Excel  every Quarter or Month - Just recalculate
     
  • Count UNIQUE values in RANGES - Unlike the standard Count() function, repeated values are only counted only once.
     
  • RANK numbers in a range - Is it the 1st, 2nd or other?
    Determine the sort order number of a given value in a range - Identify numbers in a range by their sort order.
    EX: Classify your P&L variations to Budget. What are the 3 larger variations?

Other Worksheet Functions & Buttons

  • Calculate Dates with Working Days - Calculate a task end date by adding a given number of working days to the start date, ignoring weekends and holidays. The standard function will add consecutive days to the start date, including weekends and holidays - not the way most people work!
     
  • Get Easter Date - Easter is a mobile date that changes every year and affects some date calculations. It is also need to forecast future holidays. Just give the year and it will return the Easter date.

Click here for a full description of the toolbar buttons & functions.


FREE Download.

Click HERE to DOWNLOAD.

Download is a ZIP file including the AddIn and a PDF installation manual (2 minutes to install).

EXCEL ONLY - No setup required. Just add to AddIns under Excel Options and run!

Click HERE to DOWNLOAD.



Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


New Toolbar Buttons - NOT available on the Regular Excel  Feature Set

Toolbar Buttons

  • Copy EXACT Formulas - No Adjustments in cell references when pasting whole ranges. No more manual copying of each cell formula.

Copy Exact Formulas

  • Compare Formulas in 2 Ranges - What has changed since last month? Don't manually compare each cell formulas. Compare all cells in a range in seconds.

Compare Formulas in 2 Ranges

  • Apply alternate backgrounds (Row/Column) in a single click - Much easier to read, specially in print. Just Select & Apply.

Click to Enlarge

  • SAVE TIME with direct, 1 click access to the "hidden" commands:
  • Calculate
    • Calculate Sheet
    • Calculate Selected Area
    • Calculate Active Workbook only  (F9 will calculate all open workbooks)
    • Manual / Automatic Calculation mode Toggle
  • Paste
    • Paste Values
    • Paste Formulas
    • Paste Formats
  • Broken links to AddIn Functions? Automatically recover them.

Do you use other AddIns for Excel to get data from your Financial, BI or Operations software? Do you get Broken Links when the files are open by different users?

FROM: =C:\Excel\AddIns\ExMiniTools.XLA!TopN(Q7:Q12;Q5;"A";Q3)

TO: =TopN(Q7:Q12;Q5;"A";Q3)

  • Copy TABLES to Microsoft WORD without ERRORS!

REMOVE cell #ERRORS automatically on the selected range before copying tables to other applications like Microsoft Word


FREE Download.

Click HERE to DOWNLOAD.

Download is a ZIP file including the AddIn and a PDF installation manual (2 minutes to install).

EXCEL ONLY - No setup required. Just add to AddIns under Excel Options and run!

Click HERE to DOWNLOAD.



Excel / Office Consulting Services

Like this product but need a specialized version? Prefer to have the changes professionally applied? Need a completely different Excel product for your own purpose?

Contact us here with your request and we will issue a quick estimate. Estimates are free and do not constitute any obligation to purchase the service.

Services also available for other Microsoft Office applications like Outlook, Word, Powerpoint,etc.


Contact Us for Support Manual / How-To  FREE DOWNLOAD


Get FREE PC TIPS every month:

 

www.OfficeHelp.Biz

(c) 2004 - 2021 OfficeHelp.Biz