Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

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: Addendum

<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: Word

<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: Windows

<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: PowerPoint

<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: Excel

<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: Internet

<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: Excel

<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: Addendum

<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: Access

<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: Word

<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: Vista, Windows

<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: PowerPoint

<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: Addendum, Internet

<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: Outlook

<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

# posted by

Sample : 2/26/2010

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: Addendum

<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: Excel

<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: Access

<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: Access, Excel, Outlook, PowerPoint, Word

<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: Vista, Windows

<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: Windows

<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: PowerPoint

<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: Outlook

<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: Expression Web, FrontPage, HTML

<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: Excel

<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: Addendum

<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: Access

<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: Word

<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: Addendum

<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: Vista, Windows

<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: PowerPoint

<Doug Klippert@ 3:45 AM

Comments: Post a Comment