Bookmark and Share

Enter your email address:

Delivered by FeedBurner


Home Page










Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Tuesday, February 09, 2010 – Permalink –

Merge Formatting

Manipulation

When you merge data into Word, it takes on the formatting of the target document.
This tip allows you the dictate the appearance of merged data.


VitalNews.com






See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment

  Monday, February 08, 2010 – Permalink –

Schlub

a stupid, worthless, or unattractive person

"(Jerry is) an all-American schlub . . . He has turned these degradations into an animated Web site appropriately named ItsJerryTime.com, on which he battles a cast of tormentors that includes the Meal Moth, his landlord and an alleged telephone conspiracy perpetrated by a duo of old ladies" Wall Street Journal

ItsJerryTime.com






See all Topics

Labels:


<Doug Klippert@ 3:28 AM

Comments: Post a Comment

  Sunday, February 07, 2010 – Permalink –

Onscreen Keyboard

Tap or Click?


If you would like to have a keyboard on your screen that can be activated with your mouse you're in luck

Type osk in Start Run








See all Topics

Labels: ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment

  Saturday, February 06, 2010 – Permalink –

Home for PPT Ideas

A covey of notions



"PowerPoint Heaven is a PowerPoint entertainment portal for PowerPoint animations, games, artworks, showcases, animation templates and tutorials. The focus of this site is to maximize the use of Microsoft PowerPoint and go beyond its capability. Our goal is to show users that PowerPoint is not simply a presentation tool, but is also capable on leveraging into other areas such as creating games, artworks and animations."

PPTHeaven







See all Topics

Labels:


<Doug Klippert@ 3:45 AM

Comments: Post a Comment

  Friday, February 05, 2010 – Permalink –

Order on the Right

Context Menu

Eric Legault shares the VBA code that can be used when "Organizing Your E-mail Using Custom Item Context Menus in Outlook 2007".

May appear to be daunting, but if you have had some exposure to VBA, it's not that bad.

OfficeZealot







See all Topics

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment

  Thursday, February 04, 2010 – Permalink –

Command Reference

2003-2007-2010

Those of you that are just now making the switch to the Ribbon world, will find this valuable.

ComputerWorld.com






See all Topics

Labels: , , ,


<Doug Klippert@ 3:09 AM

Comments: Post a Comment

  Wednesday, February 03, 2010 – Permalink –

My One and Only Thrill

Melody Gardot


B001NESPHC
Verve April 28, 2009

Gentle. Almost from another time.


"The story of vocalist Melody Gardot is as remarkable as any who perseveres against abject adversity. Born in New Jersey in 1985, she took up piano and played as a youngster on the nightclub scene of Philadelphia, influenced by jazz, folk, rock and pop musics. At age 19 she was a fashion student at the Community College of Philadelphia. But, on a fateful day, while riding her bicycle, the driver of a Jeep made an illegal turn, hurdling into Gardot and leaving her in the street for dead. Hospitalized for months with multiple head injuries and pelvic fractures, her love for music was the best therapy she could receive.
Her music could be described as a cross between Laura Nyro, Joni Mitchell, Eva Cassidy, and Shania Twain, but goes deeper than mere pop convention. ~ Michael G. Nastos, All Music Guide"








See all Topics

Labels: ,


<Doug Klippert@ 3:44 AM

Comments: Post a Comment

  Tuesday, February 02, 2010 – Permalink –

Office Training

Suggestions

TechRepublic lists a number of areas that you might explore when training is needed for a new Office version.

Here are a few:

  • LINKS TO TIP SHEETS AND ARTICLES
    "Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company's main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it's okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."
  • ONLINE TRAINING
  • E-LEARNING
  • WEBCASTS
  • VIRTUAL TRAINING
  • MULTILINGUAL SCREENTIPS AND TRANSLATIONS
  • COMMAND REFERENCE GUIDES
  • OFFICE ONLINE AT WORK
10 ways to train your users on Office 2007 for free




See all Topics

Labels: , , , ,


<Doug Klippert@ 3:51 AM

Comments: Post a Comment

  Monday, February 01, 2010 – Permalink –

Tips for Word and Excel

Also some Windows hints


This site has useful information about:

  • Word
  • Word VBA
  • Excel
  • Excel VBA

    and
  • Windows
Tribbs.co.uk




See all Topics

Labels: ,


<Doug Klippert@ 3:29 AM

Comments: Post a Comment

  Sunday, January 31, 2010 – Permalink –

Context Clutter

Registry mop


When you Right-click the desktop, a “Context” menu appears. Some programs like to sneak in and add shortcuts to their very important applications.
If your context menu has been cluttered up, here are some instructions and tips to clean it up.


HowToGeek.com







See all Topics

Labels: ,


<Doug Klippert@ 3:16 AM

Comments: Post a Comment

  Saturday, January 30, 2010 – Permalink –

Classroom PP

A few tips


Here is a tutorial on ways to use PowerPoint in the classroom.
They also talk about how to use the 2007-2010 ribbon.

Actden.com







See all Topics

Labels:


<Doug Klippert@ 3:45 AM

Comments: Post a Comment

  Friday, January 29, 2010 – Permalink –

Stop Reply To All

Macro magic

Scott Hanselman (who is ". . . an old fat guy with a Black Belt that used to fit") has a tutorial on how to disable "Reply to All".

How To Easily Disable Reply To All And Forward In Outlook






See all Topics

Labels:


<Doug Klippert@ 3:01 AM

Comments: Post a Comment

  Thursday, January 28, 2010 – Permalink –

Fast Interchange

7 day URL


Go to http://cl1p.net and then:

Enter a URL that starts with http://cl1p.net.
example:http://cl1p.net/assuming/

Paste in anything you want.
Some text, links, etc. Click 'Save' when done.

On any other computer open a browser to the same URL.
You will find the information you entered in step 2.


Do more with CL1P.net. Just open any URL that starts with http://cl1p.net and you can...
  • Create a notebook
  • Have a conversation
  • Create a community
Cl1p.net



See all Topics

Labels: ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment

  Wednesday, January 27, 2010 – Permalink –

Color Scales

Conditional colors

Here is some information on Conditional color scales in Office 2010.

Microsoft Excel 2010 Blog 1

Microsoft Excel 2010 Blog 2

Microsoft Excel 2010 Blog 3







See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment

  Tuesday, January 26, 2010 – Permalink –

Where's the Template

Find and/change storage spots



Describes the different template categories and the locations of templates in 2007 Office programs. Also describes the registry settings that control where to find your custom templates.

Support.Microsoft.com






See all Topics

Labels: , , ,


<Doug Klippert@ 3:44 AM

Comments: Post a Comment

  Monday, January 25, 2010 – Permalink –

Character Codes

HTML and ALT+


Here's another table with the codes needed to insert characters that do not appear on the keyboard:

Keyboard Shortcuts





See all Topics

Labels: , , ,


<Doug Klippert@ 3:45 AM

Comments: Post a Comment

  Sunday, January 24, 2010 – Permalink –

Clean PC

Wash and dry

"Your computer could fry if you don't keep it clean," says Jonathon Millman, chief technology officer for Hooplah Interactive.
Dust clogs the vents behind your computer, which causes your CPU to heat up—and heat is the biggest cause of component failure in computers. Regular cleaning could save you costly maintenance fees down the road.
Here are some suggestions for Winter/Spring/Summer/Fall cleaning:
Microsoft.com/athome




See all Topics

Labels: ,


<Doug Klippert@ 3:20 AM

Comments: Post a Comment

  Saturday, January 23, 2010 – Permalink –

Presentation Help

Start with the end in mind


"Before you even open up PowerPoint, sit down and really think about the day of your presentation. What is the real purpose of your talk? Why is it that you were ask to speak? What does the audience expect? In your opinion, what are the most important parts of your topic for the audience to take away from your, say, 50-minute presentation?


Remember, even if you've been asked to share information, rarely is the mere transfer of information a satisfactory objective from the point of view of the audience. After all, the audience could always just read your book (or article, handout, etc.) if information transfer were the only purpose of the meeting, seminar, or formal presentation."

Garr Reynolds has more tips on presentations, delivery, and slide design:


GarrReynolds.com






See all Topics

Labels:


<Doug Klippert@ 3:48 AM

Comments: Post a Comment

  Friday, January 22, 2010 – Permalink –

Outlook Tips

Suggestions

Outlook-Tips.net was put together by Diane Poremsky. While it covers Outlook 2003, the advice is still good.

Outlook-Tips.net





See all Topics

Labels:


<Doug Klippert@ 3:48 AM

Comments: Post a Comment

  Thursday, January 21, 2010 – Permalink –

CSS Coding

Put by the keyboard

Cascading Style Sheets (CSS) is a simple way to define styles (e.g. fonts, colors, spacing) on Web pages.
Of course there is coding involved. Here is a printable cheat sheet you can keep close at hand.

LeslieFranke.com






See all Topics

Labels: , ,


<Doug Klippert@ 3:34 AM

Comments: Post a Comment

  Wednesday, January 20, 2010 – Permalink –

Help ID's

VBA code

When you build a macro, you can call up information from the Excel Help file.
Ron DeBruin has the information needed through 2007.

Right clicking the Helpfile and choosing Properties will show the HP####### number in 2010.

Help Context IDs for Excel






See all Topics

Labels:


<Doug Klippert@ 3:58 AM

Comments: Post a Comment

  Tuesday, January 19, 2010 – Permalink –

Dryer Sheet Uses

Not just for machines



Use Dryer Sheets to:
  1. Freshen smelly shoes.
  2. Remove static from clothing, hair, TV screens, and computer monitors.
  3. Clean pet hair from the floor or furniture.
  4. Replace a sachet.
  5. Loosen caked-on food from a pan.
  6. Tackle suitcase and gym-bag odors.
  7. Prevent old books from smelling musty when in storage.
  8. Wipe up sawdust after working in the garage.
  9. Prevent thread from tangling when sewing.
  10. Dust venetian blinds.
RealSimple.com

DoItYourself.com

Curbly.com


See all Topics

Labels:


<Doug Klippert@ 3:31 AM

Comments: Post a Comment

  Monday, January 18, 2010 – Permalink –

Access Transition Tutorials

Available in PDF


This collection relates to the transition to 2007, but most are also appropriate for 2010.

"The main intent of these tutorials is to guide frequent users of Microsoft Access through the transition of earlier versions to the new 2007 edition. Throughout the different tutorials . . . topics from program specifications through features added, dropped, or unchanged as well as demonstrating implementations of subjects discussed."



  • Microsoft Access 2007 in the box (Office editions and what's new)

  • Microsoft Access Head-to-Head (Access 2003 vs. Access 2007)

  • Microsoft Access Side-by-Side (Access 2003 vs. Access 2007 continued)

  • Microsoft Access 2007 PDF and XPS support

  • Microsoft Access 2007 Ribbon/Office menu customization

  • Microsoft Access 2007 Navigation Pane customization

  • Microsoft Access 2007 Working with the Attachment DataType

  • Microsoft Access 2007 Working with the Rich Text Feature

  • Microsoft Access 2007 Collect Data Through Emails

Access-Freak.com See all Topics

Labels:


<Doug Klippert@ 3:38 AM

Comments: Post a Comment

  Sunday, January 17, 2010 – Permalink –

Merge Word to PDF

Not just MailMerge anymore

Sure, you can create a merged letter and have 30 pages of individualized information.
What now? How do you create separately named documents to, maybe, send as attachments?
Another task might be to convert those 30 docs to PDF. Oh, the hours wasted!

Graham Mayor, a retired newsgroup junkie, offers a solution.
It's a macro that will convert the merged output as individually named doc(x), and/or PDF files.
I've used it, and now wonder what I can do with the time I'm saving.






GMayor.com

Merge with Attachments






See all Topics

Labels:


<Doug Klippert@ 3:06 AM

Comments: Post a Comment

  Saturday, January 16, 2010 – Permalink –

Slide Show Flash

PPT to SWF

"ANVSOFT Flash Slide Show Maker is a Flash album creator that will help you build animated photo slideshows with SWF file as the output format."

DailyFreeware.net
Photoaxe.com






See all Topics

Labels:


<Doug Klippert@ 3:30 AM

Comments: Post a Comment

  Friday, January 15, 2010 – Permalink –

Name That File

Rules, more rules


There are still some restrictions on what a file can be named. Here are a couple of links that give more details:

VLaurie.com

MSDN.Microsoft.com






See all Topics

Labels: ,


<Doug Klippert@ 3:39 AM

Comments: Post a Comment

  Thursday, January 14, 2010 – Permalink –

Customize Your Calendar

Do it your way

. . . you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between. You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like. Use different color schemes, and show more or less detail in your calendar.

Office.Microsoft.com






See all Topics

Labels:


<Doug Klippert@ 3:19 AM

Comments: Post a Comment

  Wednesday, January 13, 2010 – Permalink –

Text Files to Excel

A hard way to do an easy job

Text files can be imported or just pasted into Excel. If you want to learn more about SQL statements and non-code coding, look at this blog:


"Excel doesn't have an easy way to append multiple text files into one worksheet through the user interface. From time to time I hear customers asking how to do this in an easy way. Do you have to use Access or VB code to solve this problem? No. There's a way to do it in Excel by using a simple SQL statement in the connection string."


MSDN Excel Blog





See all Topics

Labels:


<Doug Klippert@ 4:51 AM

Comments: Post a Comment

  Tuesday, January 12, 2010 – Permalink –

Scroll Text

Automated GIF



WigFilp.com





See all Topics

Labels: , , ,


<Doug Klippert@ 3:49 AM

Comments: Post a Comment

  Monday, January 11, 2010 – Permalink –

Merge Access with Word

Database integration



"You can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."
Office.Microsoft.com





See all Topics

Labels: ,


<Doug Klippert@ 3:40 AM

Comments: Post a Comment

  Sunday, January 10, 2010 – Permalink –

Hard Drive Innards

Hidden workings


Early on computers did not always have "Hard drives". The TRS-80 worked off a portable tape recorder.
If you want to see how they work today, look at:
HowStuffWorks.com

There are also a couple of videos that explore the entrails.


Break.com-Inside a Hard Drive

and
How a Hard Drive Works






See all Topics

Labels:


<Doug Klippert@ 3:59 AM

Comments: Post a Comment