Specializing in Advanced Spreadsheet & Office Macro Solutions.

Date Published: 1/8/2005

Version:

1.00

New Year, New Periodicity, New Compromise
OfficeHelp.Biz January 2005 News
Printer friendly version

Welcome to OfficeHelp.Biz first 2005 Newsletter. Starting this January, there will be some changes on OfficeHelp.Biz. Read about them and find out what’s in store for January.

The Newsletter periodicity

Starting from January 2005, the Officehelp.Biz newsletter will be monthly, sent during the first week of each month.

Our Compromise on Content

There will be at least two new contents for each month, and one of them will be FREE. Access to the free content will, however, be limited to the newsletter subscribers.

Subscribing to the OfficeHelp.Biz newsletter is free and the only requested information from you is an email address. There are no privacy risks, as we know nothing about you. But, even if we did, we wouldn’t share it with anyone else, as our Privacy Policy clearly states.

To access the FREE PC Tips, once registered, all you need to do is to enter your email into the first access to a free content. Your login will be remembered on subsequent pages during the same session.

The content forecasted to be published during the following month will be disclosed, as well as the additions made during the past month (since you got your last newsletter).

Access to Paid Contents

A new, subscription model, is being prepared, allowing the purchase of a low-price subscription granting access to ALL OfficeHelp.Biz paid content at once. Access to Paid content as a single-product purchase will remain.

New Content Disclosure

The content forecasted to be published during the following month will be disclosed, as well as the additions made during the past month (since you got your last newsletter).

New Contents added in December 2004

New Content Category: Design Templates – Design templates are documents that can be re-used maintaining the original formatting. They allow individuals and corporations to systematically and consistently create good-looking documents without having to create them from scratch. Added one Word template.
FREE PC TIP: Where and How to find "Safe" Free Software? - The Internet is full of free software, but it’s not always easy to find what we want. Also, there is an increasing trend for the replacement of “Free” software with AdWare, advertisement supported software riddled with SPYWARE that will spy on your browsing habits and display annoying adds.

New Contents to be published during January 2005

The following contents will be added in January in time for the February Newsletter:

MACRO: Internet Explorer Privacy Manager, in Excel – Every time you use your browser, it will register information about the pages you visited. This can be annoying and even misused. You can manually clear most of this information, but it is a time consuming process. There are commercial software around to clean it, but they are expensive and cannot be used on corporate PCs, where software installation is usually locked to end-users. 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.
PC TIP: How to save the workspace (all open files) at once in excel – It is quite common to have several related Excel files opened at the same time. If you stop working, you will have to remember them and open the again later, right? NO, it is possible to save a snapshot of your work and open them again, in seconds, even after shutdown. Start saving time now, save your workspace for later!
PC TIP: How to create PDF files from office documents – PDF is the most common and popular format for sharing final version of documents, specially to the public. Its reader is free and it has become the standard for Internet document publishing. Unfortunately, you can’t create the using the tools you’re used to: Office application. Or can you? And for free? Yes, you can. Find out how in this FREE tip.

DEMOS will be available of all our macros, during January. Working versions, limited on the scale of the output they will generate, will be available for FREE DOWNLOAD. Test-drive our products.

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.