Specializing in Advanced Spreadsheet & Office Macro Solutions.
Application Macros
Macros are software applications that run inside one of the
Microsoft Office(R) applications and can do tasks that are otherwise
impossible. They extend the usefulness of the Office applications by
adding features not originally there.
Download our FREE DEMOS!
Check each macro for a FREE Trial.
New Macros are published regularly. Subscribe our newsletter and be warned whenever there are new
contents on OfficeHelp. Our newsletter is NEVER send unsolicited and
is only sent whenever there is something new. You won't bee
submerged by messages from us. Check our Privacy Policy for more
details.
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.
Waking up at 6:00AM from your mobile phone appointments? Stop your Microsoft® Outlook® full-day appointments waking you up at 6:00AM the previous day by automatically overriding Outlook fixed and unchangeable “18 hours before” alarm settings for full-day appoints. Really EASY to use - Just install and forget. And sleep to your real alarm clock…
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.
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®.
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.
Create your own adjustable Budgets and Profit statements for Microsoft® Excel® at the click of a button. All formulas are automatically generated. Automatic Total and Sub-Total Columns per Period (Quarter, Semester, Year) and Category (Operational Income, Fixed Costs, Operational Costs). Fully Customizable look. Ideal for Small Business, Personal and Department level use.
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.
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.
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.
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!
Every time you use your browser, it will register information about the pages you visited. This can be annoying and even misused. Want to easily and fast clean all the records IE makes about your browsing? This macro is an Excel file and will run on any computer with Excel just by pressing one button. Clean your navigation trail.
Easily switch IE (Internet Explorer) connection settings between Corporate and Home / Public Hotspot (wireless) network settings. Corporate networks have extra security levels and don’t let their users to directly connect to the Internet. An intermediate server, also known as a Proxy, is usually necessary. But it is only available at the Office, so it will prevent Internet connection from home or a public wireless hotspot.
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.