Specializing in Advanced Spreadsheet & Office Macro Solutions.

Date Published: 4/17/2005

Version:

1.00

New Free PC TIPS? What's new in April 2005?
OfficeHelp.Biz April 2005 News
Printer friendly version

Hello! Welcome to OfficeHelp.Biz April 2005 Newsletter.

We just published our new contents for April. From now on, Newsletters will be sent immediately as soon as new contents are published and new contents are only published when a newsletter is due. This way, you will always be the firsts to know and check our new contents! We will also start soon with special prices for newsletter subscribers when products are acquired from links on the newsletter.

Keeping up with the critical subject of Outlook archives, we included a FREE PC Tip on the subject of repairing damaged Outlook email/calendar/contacts storage files. This tip can be used in conjunction to out Tutorial on the subject of backup of Outlook Email (and Contacts and Calendar) Archive files.

We also have a new Pricing Policy with the individual buyer in mind. Prices have been lowered and are now absolutely affordable compared to the productivity benefits you may get using them. Starting this month, our standard prices will be:

PC TIPS - Free
Tutorials - USD $1.95
Templates - USD $4.95
Macros - USD $9.95

Our Internet Explorer Privacy Macro is finally available. Not at production grade but as a beta (the word is normally used, in the computer world, to define a test grade product). You can download and test it for free, even if there are still limitations and it's not really completely finished. Check the details.

With it, you will be able to delete Internet Explorer's navigation trail on your PC (all records IE makes of what you've been seeing on the internet) as well as the recent file list of some common picture editing applications included in Windows and Office: Paint and Photo Editor. Since it is an Excel Macro, it runs inside Excel and doesn't need to be installed. As such, it will run on most PCs, even corporate ones.

Recently added Contents

PC TIP: Insert Automatic Tables of Contents in Microsoft® Word – Most large text documents are divided in chapters and need a Table of Contents. But making one manually is an annoyance and highly impractical. Change the text and you have tom update all your page numbers. It is impossible to do without error for long, But there is a solution. Let Word do the Table of Contents for you, automatically - including page numbers and chapter title updates. Learn how on this useful 5-minute tip. Make more professional looking documents with this trick.
PC TIP: Repair Outlook email archives – You open Outlook and get an worrying error message: your email / calendar / contacts file is corrupted and can't be opened. You've just lost everything on it!!! Well, not exactly. It is possible to recover the file, partially or even totally, usually with a small loss of the message that provoked the corruption. All with a free utility Microsoft (r) already included on Windows but forgot to tell.
MACRO: Internet Explorer Privacy Manager, in Excel (in Beta testing phase - for FREE)– Test for free the Beta version of our privacy macro. It's still unfinished and undergoing tests, but you can have a peek and decide if it will be of use to you. The macro can be described as:

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.

New Contents to be published during April 2005

The following contents is intended for publication¹ during April, in time for the May Newsletter:

TUTORIAL: Automate your tasks, make your own Microsoft® Office Macros – No need to be a programmer or learn to write code! Office applications have their own Macro saving tool allowing ANY user to save a Macro that will repeat tasks. Learn how to put this tool to good use and save countless hours of work. Amaze everybody with your new productivity!
PC TIP: Password protect your Microsoft® Office files – Lets face it. Most Office documents don't need to be protected. And password are allays an extra level of complexity. But have you ever desired to password protect an Office document (either Excel, Word, PowerPoint or other)?. It's easier than you think. Learn how, it's free! No more unwanted peeks into your files.
GENERAL: New Product: There will be a new product available next month. We will publish the details later.

¹ ^{This list is a forecast and doesn't guarantee
publication of the listed contents

2} ^{OfficeHelp.Biz}^reserves^{the right to}^change^{prices without notice.}

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.