| Content Type |
Application |
Author |
Price |
| Macro |
Microsoft® Excel® |
OfficeHelp |
9.95 USD
4.45 USD |
50% DISCOUNT on this Macro for limited time.
ExMiniTools - Utilities Toolbar for Microsoft® Excel® - Version 2.00
Tested on Microsoft® Excel® Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0) - should work on any version above 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. |
|
|
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)
 |
Actual to Budget variations
 |
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.
|
Download FREE
Demo |
|
| EXCEL ONLY - No setup required. Just add to AddIns
under Excel Options and run! |
|
|
New Toolbar Buttons - NOT
available on the Regular Excel ® Feature Set
- Copy EXACT Formulas - No Adjustments in cell references
when pasting whole ranges. No more manual copying of
each cell formula.
- 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.
- Apply alternate backgrounds (Row/Column) in a
single click - Much easier to read, specially in
print. Just Select & Apply.
- 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
|
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)
REMOVE cell #ERRORS automatically on
the selected range before copying tables to other
applications like Microsoft® Word
|
|
|
Download FREE Demo
EXCEL ONLY - No setup required. Just add to AddIns
under Excel Options and run! |
|
|
|
|
|
|
50% DISCOUNT on this Macro for limited time.
ExMiniTools - Utilities Toolbar for Microsoft® Excel® - Version 2.00
Tested on Microsoft® Excel® Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0) - should work on any version above Office 97 |
|
|
