Date Released: 2005-11-15

Mr. Excel to Provide Content to Monthly Investintech Newsletter.

Investintech is pleased to announce that Bill Jelen (aka Mr. Excel), one of the World’s leading MS Excel consultants, has graciously agreed to provide insightful monthly MS Excel tips for the Investintech newsletter.

Bill is the author of book “Learn Excel from Mr. Excel” and is also the brains behind the leading MS Excel resource on the Internet - www.mrexcel.com. Mrexcel.com offers a vibrant interactive message board with literally thousands of pages of answers to MS Excel problems, easy and difficult. Bill also consults to international organizations large and small, providing solutions to Excel emergencies and helping make routine MS Excel tasks simpler.

We have used his resource on several occasions ourselves to answer our customers Excel ouput related questions. If you are having an Excel issue, we encourage you to check his resource out. We’re pretty sure he’ll have the answer you need.

Here is a sneak peek into his Excel Tip for the upcoming November Investintech Newsletter:

Fill a Formula Down a Column

You have 5321 rows of data in columns A through E. You've just entered a formula in cell F2 and need to copy that formula down to all of the rows with data. Select cell F2. Notice that the lower right corner of the cellpointer box contains a square dot. This dot is called the fill handle. Many people try to drag the fill handle to extend the formula, but this results in frustration when you go cruising past row 5321 at light-speed. Instead of dragging the fill handle, simply select cell F2 and double-click the fill handle. Provided that there is data in the column immediately to the left or right of the selected cell, Excel will copy the formula down until it encounters a blank cell in the adjoining column.

Bill Jelen is the author of Learn Excel from MrExcel and highly recommends Able2Extract to his readers at MrExcel.com.

If you would like to sign up for the Investintech Newlsetter and get Mr. Excel’s monthly tip, along with other helpful information about our PDF Creation and Conversion products, please Click Here to Sign Up.