OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Queue Servicing Calculator

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.


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

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

 

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

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.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2017 OfficeHelp.Biz