Specializing in Advanced Spreadsheet & Office Macro Solutions.

Content Type	Application	Author	Price
Macro	Microsoft Excel	OfficeHelp	Free

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

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.

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

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

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

Printer friendly version
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), 2013, 2016 - should work on any version from Office 97

Back

00052- Design Chart Templates for Microsoft® Excel®		Microsoft Excel	Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.

00054- Automatic Copy/Paste for Microsoft PowerPoint®		Microsoft Excel	Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.

00051- Organization Chart Maker for Microsoft® Excel®		Microsoft Excel	Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.

00037- Traditional Calendars for Excel		Microsoft Excel	Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.

00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel		Microsoft Excel	Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.

00044- Custom GANTT Charts for Microsoft® Excel®		Microsoft Excel	Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.

00027- Get all OfficeHelp.Biz CALENDARS at once!		Microsoft Excel	Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?

00046- Calendar Templates 2007 with Holidays for Excel		Microsoft Excel	Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.

00002- Calendar Plan Generator - ADVANCED Edition		Microsoft Excel	Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.

00040- Get all OfficeHelp.Biz TEMPLATES at once!		Microsoft Excel	Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?

00036- Calendar Plan Generator - Source Code Edition		Microsoft Excel	Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.

00043- Calendar Plan Generator - BASIC Edition		Microsoft Excel	Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!

00028- Calendar Plan - Year Planner Template		Microsoft Excel	Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.

00001- Queue Servicing Calculator		Microsoft Excel	Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.