| Date |
Subject |
| |
- 2005 -
|
| 06/29/05 |
PowerPoint: Subscripts and Superscripts |
| 07/06/05 |
MS Office: Screen Capture using the Windows PrintScrn |
| 07/13/05 |
Excel: How-to eliminate duplicate entries from a list |
| 07/20/05 |
PowerPoint/Excel: Update PowerPoint when linked Excel file changes |
| 07/27/05 |
Email: Queue email for future delivery |
| 08/03/05 |
Email: Send Txt Msg To Cell Phone/Receive Msg from Airlines, Banks, etc. |
| 08/10/05 |
MS Office: Add diacriticals, symbols and foreign characters |
| 08/17/05 |
Excel: Radar Plot - Executive Tool to measure Organizational Balance |
| 08/24/05 |
MS Office: Remove red-eye from your digital pictures |
| 08/31/05 |
MS Office: Keyboard Navigation - CTRL, ALT and Underlined Menu Letters |
| 09/07/05 |
PowerPoint: Test your presentation with the Six Step CA Checklist |
| 09/14/05 |
Product Review: Comcast VideoMail and Google Earth |
| 09/21/05 |
Excel PowerTip: Range Names Greatly Improve Formula Readability |
| 09/28/05 |
MS Office: The Equation Editor - A MS utility for creating complex equations |
| 10/05/05 |
PowerPoint: Create Web Like Navigation For Your PowerPoint Presentation |
| 10/12/05 |
MS Office: Character Map - add foreign characters, diacriticals, symbols, etc. |
| 10/19/05 |
Excel/PowerPoint: Add Variable Data in Excel to your Chart |
| 10/26/05 |
Excel: Auto-Fill and Format Painter - Good Looking Spreadsheets, Quickly |
| 11/02/05 |
Excel: The Management Tool, Using the 80/20 Rule (Pareto Principle) |
| 11/09/05 |
In Memory of my Step Father, Bill Painter |
| 11/16/05 |
PowerPoint: Identify image formats w/transparent background capability |
| 11/23/05 |
MS Office: Carry your Internet Explorer (IE) Favorites with you |
| 11/30/05 |
PowerPoint: Elegant Launch Method For PowerPoint |
| 12/07/05 |
PowerPoint: When Sharing PPTs - Embed Your Fonts |
| 12/14/05 |
Excel: Logarithmic Graphs for Engineering, Medical & Financial Applications |
| 12/21/05 |
MS Office: Faster method than SEARCH to find files |
| |
- 2006 - |
| 01/11/06 |
Excel: Dashboard - Executive Power Tool |
| 01/18/06 |
Excel: Sort Rows, not just Columns |
| 01/25/06 |
Excel: Creating A Forecast |
| 02/01/06 |
Word: Positioning An Image |
| 02/08/06 |
Excel: Convert a Long Row to a Column, and vice versa |
| 02/15/06 |
Excel: Create Pricing for One, to One Million Units |
| 02/22/06 |
Excel: Have your logo print on every page |
| 03/01/06 |
Excel: Price Erosion I - can the sales team make up the revenue in volume? |
| 03/08/06 |
Excel: Price Erosion II - can the sales team make up the profit in volume? |
| 03/22/06 |
Outlook: Email Hyperlink will automatically fill-in To and Subject fields |
| 04/05/06 |
Networking: Are You LinkedIn? |
| 04/19/06 |
Outlook: Email Autoresponder (SFA) |
| 05/03/06 |
PowerPoint: Create CD-ROM Handouts w/AutoRun & AutoStart |
| 05/17/06 |
Excel: Using the AutoFilter |
| 05/31/06 |
Excel:
Input Validation |
| 06/14/06 |
Outlook:
Print Envelopes / Share Contacts |
| 06/28/06 |
Excel:
Drop-Down Boxes offer web-like interface for Credit Card Numbers,
etc |
| 07/12/06 |
CxO, VP and Director Tools: Forecast / Dashboard |
| 07/26/06 |
MS Office: Use Document Properties to Find & Identify Files Fast |
| 08/09/06 |
Word: Create an email version of your company letterhead |
| 08/23/06 |
Excel: Regression Tips for Charts |
| 09/06/06 |
Excel/Word: Concatenate Text and Numbers from Excel and Link to Word |
| 09/20/06 |
PowerPoint: Part I - Adding an Audio or Video Clip |
| 10/04/06 |
PowerPoint: Part II - Adding an Audio or Video Clip |
| 10/18/06 |
PowerPoint: Part III - Adding an Audio or Video Clip |
| 11/01/06 |
Outlook/Eudora:
You've Got Mail |
| 11/15/06 |
Excel: Create Custom Colors in the Color Palette |
| 11/29/06 |
Excel: Break-Even Analysis for Start-Ups |
| 12/13/06 |
Excel: Worksheet Tabs - Color, Rename and Hide |
| |
- 2007 - |
| 01/10/07 |
Excel: How to Calculate FITs and MTBF |
| 01/24/07 |
Internet Explorer: Hdr/Ftr attributes for URL, Title,
Date, Page and # of Pages |
| 02/07/07 |
Internet Explorer: Save Web Page(s) for Viewing Later |
| 02/21/07 |
Product Review: StuffIt and CuteFTP |
| 03/07/07 |
One-Minute Rank - TechTIP 2006 eNewsletters |
| 03/21/07 |
PowerPoint & Word: Using the Cropping Tool |
| 04/04/07 |
Excel: Conditional Formatting - Ahhhhh |
| 04/18/07 |
PowerPoint: 2D FX - Emboss, Deboss, Bevel & Transparency |
| 05/02/07 |
Excel: Appearance Counts - Use Comments and Line Breaks in Cells |
| 05/16/07 |
Excel: Fix Breaks in Charts w/NA() & Format Multiple wks Simultaneously |
| 05/30/07 |
PowerPoint: Animating Charts |
| 06/13/07 |
Word: Table Tricks - Add Tabs and Excel-like Calculations |
| 07/04/07 |
Happy Fourth of July |
| 07/18/07 |
Excel: PowerTip for Advanced Filter, Part I: Find Unique Records |
| 08/01/07 |
Excel: PowerTip for Advanced Filter, Part II: Subtotal Records |
| 08/22/07 |
Email: Is It SPAM? How to avoid receiving SPAM, or having your emails flagged as SPAM |
| 09/05/07 |
Excel: Macro Part I: Create A Record Macro |
| 09/26/07 |
Excel: Macro Part II: Assign Macro To A Button |
| |
- 2008 -
|
| |
- 2009 -
|
| |
- 2010 -
|
| 02/03/10 |
Get More Information From Waterfall Charts |
| 03/03/10 |
Your Salary, Inflation and the Consumer Price Index (CPI) |
| 04/07/10 |
Time-To-Money :: AKA - Funnel, Pipeline, Conduit, and Straw |
| 05/05/10 |
A Scalpel Doesn't Make You A Brain Surgeon |
| 06/02/10 |
ScoreCard Your Customer |
| 07/07/10 |
Sales & Marketing: Cooperation or Conflict? |
| 08/04/10 |
Buyer-Seller ABC's and Guanxi |
| 09/01/10 |
Are You Selling In A Vacuum? |
| 10/06/10 |
Rolls-Royce Ad's? |
| 11/03/10 |
Sales Quota's - Adapting to Change |
| 12/01/10 |
What Others See - When You're on the Internet |
| |
- 2011 -
|
| 01/05/11 |
Incentive Compensation Models / Charts |
| 02/02/11 |
The Bottom Line - Revenue vs Expense |
| 03/02/11 |
Social Networking Tsunami / Tool Tips |
| 04/06/11 |
Contract Negotiations - Beyond Just Price |
| 05/04/11 |
Forecast Accuracy-Oxymoron? |
| 06/01/11 |
Sales & Marketing: The Bento Box Model |
| 07/06/11 |
QR Code Primer |
| 08/03/11 |
TechTIP eNewsletter Celebrates Six Years |
| 09/07/11 |
Caveat Venditor: Selling in the year 3100 B.C. (nihil novi sub sole) |
| 10/05/11 |
Vilfredo Pareto (1848-1923) :: Italian Economist |
| 11/02/11 |
Where To Relax? |
| 12/07/11 |
Three Pillars - Responsibility, Accountability, and Authority |
| |
- 2012 -
|
| 01/04/12 |
Beyond Tier I Accounts |
| 02/01/12 |
Sales Forecast - Identifying Variance |
