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



  Saturday, March 13, 2010 – Permalink –

This blog has moved


This blog is now located at http://unofficialofficestuff.blogspot.com/.
You will be automatically redirected in 30 seconds, or you may click here.

For feed subscribers, please update your feed subscriptions to
http://unofficialofficestuff.blogspot.com/feeds/posts/default.

<Doug Klippert@ 9:22 AM

Comments: Post a Comment


  Sunday, March 07, 2010 – Permalink –

Certification

Get your paper


"Discover the only worldwide, performance-based certification program that validates the skills needed to get the most out of Microsoft Office and Windows Vista. Whether you want to stand out in the job market, improve your performance, or better prepare your students to enter the workforce, the Microsoft Business Certification (MBC) program can help you attain the valuable expertise you need—and businesses rely on—to succeed."
Microsoft Business Certification






See all Topics

Labels:


<Doug Klippert@ 3:20 AM

Comments: Post a Comment


  Saturday, March 06, 2010 – Permalink –

Hidden Data

Secrets revealed

Ed Bott has a discussion on Metadata. That information, such as names and notes, which is hidden in Word documents.

EdBott.com




See all Topics

Labels:


<Doug Klippert@ 3:06 AM

Comments: Post a Comment


  Friday, March 05, 2010 – Permalink –

Free Design Tools

Simple and free

Mauricio Duque has collected a list of 45 no cost design programs.
"Some of them are pretty decent alternatives, not only for those who are not willing to spend the big bucks, but also for those who need some specific tasks done, like resizing a batch of picture without needing to run the almighty Photoshop."

Snap2Objects.com






See all Topics

Labels:


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Thursday, March 04, 2010 – Permalink –

Layout Control

Unique designs

How a slide is laid out can be captured as a custom template.
You are not restricted to the schems that come out of the box.

Custom Layout






See all Topics

Labels:


<Doug Klippert@ 3:56 AM

Comments: Post a Comment


  Wednesday, March 03, 2010 – Permalink –

Mail Excel

VBA + sample

Excel Guru Ron de Bruin has put together the VBA code needed to send Excel via email.
He has also included the sample workbooks for those that are not VBA literate.

Also:
". . . a new add-in named RDBMail for Excel/Outlook 2007-2010
http://www.rondebruin.nl/mail/add-in.htm

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."



Code to send mail from Excel






See all Topics

Labels:


<Doug Klippert@ 3:39 AM

Comments: Post a Comment


  Tuesday, March 02, 2010 – Permalink –

Hosting Info

Who dat provider?

Find out which provider a site is using.
Find out which internet providers are most reliable.
Find out which operating system is being used by which provider.
Find out . . .

Netcraft.com






See all Topics

Labels:


<Doug Klippert@ 3:05 AM

Comments: Post a Comment


  Monday, March 01, 2010 – Permalink –

Video Tutorials

What you see


"MIStupid.com is The Online Knowledge Magazine that publishes information that everyone should know, wants to know, or forgot.
MIStupid.com was created in 2001 by Greg Renza with the desire to eradicate the world's stupidity."
A few of the lessons include:
  • Concatenating Cells
  • Conditional Formatting
  • Subtotals
  • Data Sorting
  • Formulas and Named Cells
  • Create Graphs and Charts
MIStupid.com




See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment


  Sunday, February 28, 2010 – Permalink –

Productivity Guides

Free suggestions


Microsoft provides 22+ guides to productivity in the office.

"Microsoft IT created Work Smart productivity guides (previously Everyday Productivity Education (EPE) guides) to bridge the gap between technology and users. Work Smart guides provide employees with scenario-based, best-use productivity aids on Microsoft products and technologies. As more Work Smart guides are published, Microsoft IT expects to see more consistent, productive, and cost-effective use of products and technologies across the company."

IT Showcase






See all Topics

Labels:


<Doug Klippert@ 3:57 AM

Comments: Post a Comment


  Saturday, February 27, 2010 – Permalink –

Database Genesis

Gotta start somewhere


Microsoft has a tutorial on how to create a database.

Office.Microsoft.com






See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment


  Friday, February 26, 2010 – Permalink –

Word Features

New or reacquaint

2007 came up with a number of new and impoved features. Most are the same in 2010.
Here's a description of some built in tools.

Beyond the Ribbon





See all Topics

Labels:


<Doug Klippert@ 3:29 AM

Comments: Post a Comment


  Thursday, February 25, 2010 – Permalink –

Convert Graphic Styles

Straight forward

Often you will have pictures in one format and want to explore using it in a different manner.
Built into Office 2003/7/10 is a mini app called Microsoft Office Picture Manager.

1. Go to Start > All Programs > Microsoft Office > Microsoft Office Tools > Microsoft Office Picture Manager
2. Browse to the images you want to convert and select them
3. Go to File > Export
4. Under Export with this file format, click the dropdown and select one of the formats (TIFF, PNG, JPG, BMP. . .)


Converting WMF's






See all Topics

Labels: ,


<Doug Klippert@ 3:18 AM

Comments: Post a Comment


  Wednesday, February 24, 2010 – Permalink –

One-Slide Timer

Easy tip


You can use this before a show, or when you take a break.

PowerPoint: A Codeless One-Slide Timer






See all Topics

Labels:


<Doug Klippert@ 3:35 AM

Comments: Post a Comment


  Tuesday, February 23, 2010 – Permalink –

PDF Form Fill

Free tool


Have you ever been stymied by this PDF warning?



You can enter data, but you can't save the file with the new information.
Nuance has a free answer:

"Fill and save PDF forms - Most other PDF viewers do not enable you to fill and save PDF forms without support from a premium product.
Nuance PDF Reader provides frequently used annotation tools, letting you highlight, cross-out, and underline text."

Nuance PDF Reader






See all Topics

Labels: ,


<Doug Klippert@ 3:17 AM

Comments: Post a Comment


  Monday, February 22, 2010 – Permalink –

Stuck in the Outbox

Steps to try

Some suggestions about how to empty your outbox and speed your greatest thoughts on their way.

How to troubleshoot messages stuck in your Outbox


Outlook Troubleshooting Tips






See all Topics

Labels:


<Doug Klippert@ 3:58 AM

Comments:
Good!
Nice post, i didn't know that. i hope you update your site regularly to re visit of your visitors.

Sample forms

 
Post a Comment


  Sunday, February 21, 2010 – Permalink –

Google Searches II

Tips


Here's a link to a PDF file that shows how to maximize Google searches.

Parameters Cheat Sheet






See all Topics

Labels:


<Doug Klippert@ 3:27 AM

Comments: Post a Comment


  Saturday, February 20, 2010 – Permalink –

Selection Address

What's the count

". . . know what range is selected at any given time. You can look at the Name Box, but that only show the active cell."

Display number of Rows and Columns






See all Topics

Labels:


<Doug Klippert@ 3:58 AM

Comments: Post a Comment


  Friday, February 19, 2010 – Permalink –

Navigate Navigation Pane

Ahoy


Here's the Microsoft tutorial:

Meet the Navigation Pane

Also:
"We have heard a few of you have missed the ALT D shortcut to open an object in design. As you know, ALT in ribbon apps now allows you to access ribbon shortcuts. Next time you want to open an object in design view, try Control Enter."
Navigation pane tip




See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment


  Thursday, February 18, 2010 – Permalink –

Custom QAT

Access additions


Applications put most of the most-used commands on the Home tab's Ribbon, not everything is there. You may want to add Close, Close All, or Print commands, for example.

In the upper Left corner is the Quick Access Tool bar.

To update the QAT:
Click the down-pointing arrow to the right of the QAT.
Choose any common commands (New, Close, Print, etc.) by checking the option.






See all Topics

Labels: , , , ,


<Doug Klippert@ 3:28 AM

Comments: Post a Comment


  Wednesday, February 17, 2010 – Permalink –

Temp Files

Where they live and breathe


Ed Bott discusses temp files; care, feeding, and cleaning.


EdBott.com








See all Topics

Labels: ,


<Doug Klippert@ 3:39 AM

Comments: Post a Comment


  Tuesday, February 16, 2010 – Permalink –

Flip Text

This text is right side up


uʍop ǝpısdn sı sıɥʇ

This site accepts your perfect prose and turns it around.
(with unicode)

RevFad.com







See all Topics

Labels:


<Doug Klippert@ 3:51 AM

Comments: Post a Comment


  Monday, February 15, 2010 – Permalink –

Performance and Exhibition

Techniques

PowerPoint can be one element, but there are other considerations when delivering information.
  • Presentation
  • Creation
  • Delivery
  • Venue
  • Technology
  • Products
Presentations.com



See all Topics

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Sunday, February 14, 2010 – Permalink –

Display Order

What’s on top

Outlook allows you to rearrange how information is displayed in your email list.



(Outlook 2010)

HowToGeek.com







See all Topics

Labels:


<Doug Klippert@ 3:42 AM

Comments: Post a Comment


  Saturday, February 13, 2010 – Permalink –

Quotes and Apostrophes

HTML codes


A left double quote is &ldquo;
A right double quote is &rdquo ;
A left single quote is &lsquo ;
A right single quote is &rsquo ;


OfZenandComputing.com






See all Topics

Labels: , ,


<Doug Klippert@ 3:04 AM

Comments: Post a Comment


  Friday, February 12, 2010 – Permalink –

Custom Toolbars

You’re not restricted


You can create your own toolbars. Here's some code that helps:



Toolbars for Fun and Profit






See all Topics

Labels:


<Doug Klippert@ 3:07 AM

Comments: Post a Comment


  Thursday, February 11, 2010 – Permalink –

Historical Documents

Remember good old paper?


"Footnote helps you find and share historic documents. We are able to bring you many never-before-seen historic documents through our unique partnerships with The National Archives, the Library of Congress and other institutions.

Our patented digitization process is helping bring other collections to life on the web everyday.

But Footnote is more than just a dusty, digital archive online. We provide you the tools to share your historical passions and connect with others."


Footnote.com






See all Topics

Labels:


<Doug Klippert@ 3:45 AM

Comments: Post a Comment


  Wednesday, February 10, 2010 – Permalink –

Access Communities

It takes a village


Here are some links the Access groups. Someone has probably asked your question before.
Access Communities



See all Topics

Labels:


<Doug Klippert@ 3:49 AM

Comments: Post a Comment


  Tuesday, February 09, 2010 – Permalink –

Merge Formatting Extended

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