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