Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












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



  Sunday, February 19, 2012 – Permalink –

Stop Online Help

Use local Help


When Office 2003 first came out, one of the new features was that the help files were "live."

Rather than using stale information installed years before, the application connected with Redmond for the newest and best solutions.

This can be a problem depending on how you connect to the Internet. If you're using a dial up service, or speeds slow to a crawl. Here is a way to use local information.
  1. Bring up the Help Task Pane (The F1 key will do this.)

  2. At the bottom of the "See also" box there is a hyperlink: "Office Online Settings"

  3. Click this link; you will get the Service Options dialog box

  4. Uncheck the option: "Search online content when connected"
Office will now use the help files on the local hard drive. It is much faster! (Editing will affect all Office applications) In office 2007, left click on the "Connected to Office Online" and choose local If you need to disable its use through a Group Policy, or in the Registry, see: Microsoft Support: How to disable Microsoft Office Online featured links in Office Be aware that if you do turn it off, you might miss some of the Office online feature, like tutorials and downloads. Office Online: Get More Out of the Microsoft Office System


See all Topics

Labels: , , ,


<Doug Klippert@ 6:51 AM

Comments: Post a Comment


  Tuesday, February 14, 2012 – Permalink –

Typography for the Rest of Us

Real world fonts


Choosing a type face can be fun, but also overwhelming.

You want to convey the message without obscuring the thoughts in an avalanche of weird shapes.

Cameron Moll has a web site/Blog called Authentic Boredom; his "platitudinous web home."

Recently he explored:

The non-typographer's guide to practical typeface selection
"I honestly believe typeface selection is one of the most transparent ways of detecting good - and bad - design. You can tell plenty about a designer merely by the typefaces he/she chooses. So you'd be wise to start with trusted faces, and you'd be even wiser to know something about the history of each typeface."


Also see:
Who was that font I saw you with last night?



See all Topics

Labels: ,


<Doug Klippert@ 8:29 AM

Comments: Post a Comment


  Monday, February 06, 2012 – Permalink –

Animations

Tutorial about Cool PowerPoint Animations




"This tutorial is more of a demonstration of what cool custom animation effects can be achieved just by using the standard PowerPoint 2002 / XP / 2003 / 2007 wipes."

  • Exhibition stand graphics to attract visitors
  • Conference openers (especially good with music)
  • Conference breakout screens
  • Divider or section headers in presentations
  • General presentation ideas
And many more. PowerPoint Animation A to Z
This is a new version. If you tried the earlier one you owe it to yourself to look at the new one.
(One hint, open the PPS file in PowerPoint. When you see an interesting trick, hit the Esc button. View the Custom animation pane to see how it was done.)
From AwesomeBackgrounds.com

See all Topics

Labels: , , , ,


<Doug Klippert@ 3:52 AM

Comments: Post a Comment


  Thursday, February 02, 2012 – Permalink –

Screen Beans and PowerPoint

A Bit Better



"A Bit Better Corporation is a small consulting firm helping companies communicate and create products with maximum impact. Partners Cathleen Belleville and Dennis Austin bring over 46 years of high-technology experience.

A Bit Better Corporation is also the creator and publisher of Screen Beans clip art collections"


(Cathleen Belleville managed product planning for the Graphics unit at Microsoft.
Dennis Austin designed the original PowerPoint 1.0 at Forethought, Inc. before Microsoft bought it.
)
BitBetter.com:
PowerPoint FAQ
Here are a few of the questions answered:
  • Is there a limit to the number of guides you can have?
  • How do I create additional pre-set color fills?
  • Can the WMF format be converted to GIF?
  • What resolution should I scan an image at in order for it to present well in PowerPoint?
  • Any way to run two different slide shows at once on two different monitors?
  • Any way to make Right Mouse go backwards in slide show?
  • Any way to print a catalog of slides with titles and file names?
  • Any tools for recovering corrupt .PPT files?
  • Why is my file still big, even after deleting things?
Some of the information is a little dated, but still usable.


The company also has collections of Screen Beans for sale:



 



See all Topics

Labels: , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Thursday, January 26, 2012 – Permalink –

Broadcast PowerPoint

Shows on the Internet



"There are many different ways you can deliver a presentation. You can make an on-screen presentation using a laptop or desktop computers and a multimedia projector, you can use an overhead with transparencies, you can generate paper printouts and use a flip chart, or even present using 35mm slides.

But, with the amazing growth of the World Wide Web, more and more people are opting to copy their presentations to the Internet. PowerPoint has built in facilities that allow you to convert your PowerPoint presentations to a series of web pages that can be published to the Internet or an Intranet then viewed by anyone with a Web browser!"
YouTubeBroadcast PowerPoint Presentations


Microsoft Office Assistance:
PowerPoint 2003 Add-in: Presentation Broadcast

"The presentation broadcast add-in, which synchronizes the audio and video delivery in Microsoft Office PowerPoint 2003 and earlier presentations and enables you to deliver presentations to participants in different locations, is not available in Microsoft Office PowerPoint 2007. Instead, Microsoft Office Live Meeting can help you collaborate online and share presentations with individuals or large groups in different locations. All that you need to use Live Meeting is a computer and an Internet connection. "

Presentation Broadcasting documentation
Broadcast PowerPoint presentations to small groups


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Wednesday, January 18, 2012 – Permalink –

Fade In/Fade Out

How to create the effect



"It is relatively simple and can be done quickly. The only part that slows you down is setting the colors. The Fade in technique is explained below. You can apply the same and reverse the color scheme to attain the Fade out effect."

Create multiple copies of an object. You can Copy the object and then use Ctrl+V to Paste it multiple times.

Change the color or shade each time the object is pasted, or using the Tab key, go through the objects and format each with a different degree of color.

Next select all the objects. Drag the mouse around the collection of objects.

With the objects selected, use the Align or Distribute option on the Drawing toolbar to Align Middle . You may also have to use Align Center .

The objects will be perfectly aligned, one on top of the other.

With the objects still selected set the animation to Appear 0 seconds After Previous event. You may have to change the timing to 0.1 seconds.

MVPS.org:

Fade In/Fade Out effect

Download a sample here


See all Topics

Labels: , , ,


<Doug Klippert@ 3:35 AM

Comments: Post a Comment


  Saturday, January 14, 2012 – Permalink –

Selecting Hidden Objects

Where's the doggy?


Constructing a presentation can involve multiple images or shapes on one slide. Objects are piled on top of each other in the order that they are created.

You can move items forward or back by using Draw>Order on the Drawing toolbar. (Drawing Tools> Format in 2007). However, how can you select an object if it is buried under other graphics?

PowerPoint allows you to cycle through every object on the slide by selecting one object and then using the Tab key to cycle through all of the objects on the slide. Objects can be graphics or text boxes; Shift+Tab cycles backwards through the objects.

Click on any visible object; press the Tab key until you see the selection boxes that indicate which object is selected.
Here's a Flash tutorial by Sonia Coleman.
(It opens in a pop up window, so you may have to tweak your Google/MSN anti-popper toolbar)
Selecting Objects

Here's a static version:
Selecting Objects


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:44 AM

Comments: Post a Comment


  Thursday, January 05, 2012 – Permalink –

Brainy Betty

Templates, Graphics and more



"Very simply, you can download anything on this site for personal or business or educational use. You can share these downloads with others as long as you give it to them and not "sell" it to them.

Tell others where you got the downloads.

Brainy Betty

What you can expect to find on this site:
  • Hundreds of free PowerPoint templates
  • Certificate templates
  • Free Flash PowerPoint Slides
  • 3D Graphics
  • Dingbats
  • Buttons and lines
  • An awesome icon collection
  • Free Flash and Swish
  • Sound clips

See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:07 AM

Comments: Post a Comment


  Tuesday, December 27, 2011 – Permalink –

Organize Presentation

Think backwards


Speaker's Notes
By Bob Denny

Organizing content requires the ability to think backward

"From the back end forward

Pretend you have all your content in front of you. Anyone can arrange the points in order of importance or chronologically. But I recommend starting with this question: What does your presentation need to accomplish? Most answers will fit into one of these categories:
  • Awareness — introducing or educating an audience on a topic.
  • Attitude — promoting a change or reinforcing your subject.
  • Action — persuading an audience to act.
With an objective in mind, you can decide what content to include and what information to leave out. By working backward — from the big picture to the small details — you'll save time and produce a more powerful presentation."

See all Topics

Labels: , , ,


<Doug Klippert@ 3:40 AM

Comments: Post a Comment


  Friday, December 23, 2011 – Permalink –

Live Notes Slide

Keep a record


How to create a "Live Notes" page in your presentation

"Frequently there is a need to capture information in a PowerPoint presentation. For example, when making a presentation before an audience, there might be a need to capture comments and questions as the presentation proceeds. You might also have a need to capture answers to a quiz or survey, or to record game responses.

You can download a small (12KB) presentation by clicking on notetaker.zip that demonstrates the method. Unzip the file (notetaker.pps) and click on it to see it in Slide Show mode.

Please note that this method requires the use of an Active-X control and therefore only works when run from PowerPoint. It will not work in the Viewer."


It does work in 2007.
See more tutorials and PowerPoint downloads at Sonia Coleman's web site, Digital Studio.




See all Topics

Labels: , , ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment


  Thursday, December 08, 2011 – Permalink –

Scheduler

Start on time


Your PowerPoint show can be set up to start at a particular time, repeat a chosen number of times and, then, turn itself off automatically.

Tushar Mehta has put together a step-by-step instruction sheet.

He combines the Windows Task Scheduler with PowerPoint's Slide Show Set Up.

This could be set up to run in a "kiosk" setting. Perhaps at a trade show or seminar.

Multiple shows could be set up to run one after another or at different times of the day.

PowerPoint Auto Scheduler Tutorial

Also take a look at VisualCron -> http://www.visualcron.com for a standalone task scheduler


See all Topics

Labels: , , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Monday, December 05, 2011 – Permalink –

Tufte

A contrary opinion



Is there anyone who has not seen a PowerPoint presentation?
In class, in business, at seminars, at any gathering of two or more people the blue screen of PowerPoint will appear.


Edward Tufte has written a number of books, including:

Beautiful Evidence,
Visual Explanations,
Envisioning Information,
The Visual Display of Quantitative Information,
and
Data Analysis for Politics and Policy.

He is Professor Emeritus at Yale University, where he taught courses in statistical evidence, information design, and interface design.

If you are ever within 300 miles of a city presenting Tufte's one day course: "Presenting Data and Information", GO!

Tufte has written that:

PowerPoint Is Evil
Power Corrupts.
PowerPoint Corrupts Absolutely


"Particularly disturbing is the adoption of the PowerPoint cognitive style in our schools. Rather than learning to write a report using sentences, children are being taught how to formulate client pitches and infomercials.

Elementary school PowerPoint exercises (as seen in teacher guides and in student work posted on the Internet) typically consist of 10 to 20 words and a piece of clip art on each slide in a presentation of three to six slides -a total of perhaps 80 words (15 seconds of silent reading) for a week of work.

Students would be better off if the schools simply closed down on those days and everyone went to the Exploratorium or wrote an illustrated essay explaining something. "


Yea, but....




Comments:
Hi Doug -

I agree, Tufte is a smart man, and people should go see his talk. I saw him last year in Boston, and the price of admission included three of his books.

He risks throwing the baby out with the bathwater. Sure, using many of the defaults in PowerPoint (or Excel or Word) will produce a less effective document. It is up to the user to adjust his/her use of such tools to avoid the narrow-mindedness that indiscriminate use of the tools can impart.

PowerPoint's a decent tool, one I use frequently in conjunction with Excel and Word in the solutions I create. I didn't know you'd written a PowerPoint book. It looks like it's geared toward UI use of Ppt. Do you know of any sources dealing with programming of PowerPoint?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/

I've seen Tufte twice.
I think he serves a purpose by exposing a viewpoint far to one side, so that others can say "I wouldn't go that far, but ..."
There's not much on PP VBA.

There are some references on RDPSLIDES.com
and Shyam Pillai's site.



See all Topics

Labels: , , ,


<Doug Klippert@ 3:27 AM

Comments: Post a Comment


  Saturday, December 03, 2011 – Permalink –

Hide the Slide

You don't need to show everything!



If you create a PowerPoint show that includes all of the information about the subject, the show will be much too long and tedious for most audiences.

Go to Slide Sorter view. Hold down the Ctrl key and select slides that contain extra or supplementary information.
Right-click the selection and choose "Hide Slide."

None of the selected slides will be shown during the show, but if a question comes up that needs more detail, the hidden slide can be retrieved by typing its number on the number key pad and hitting Enter.

You can right-click on a slide and choose "Go to Slide." The hidden slides are indicated by parentheses.

BTW:
In the Print dialog box, you can choose to "Print Hidden Slides."


See all Topics

Labels: , ,


<Doug Klippert@ 3:32 AM

Comments: Post a Comment


  Monday, November 28, 2011 – Permalink –

Embed a show

Stick it in Word



You might like to distribute a short PowerPoint slide show, and include some extra material.

Open Word and PowerPoint.
Arrange the windows so that both applications can be seen.
(Right-click an empty area of the Task bar and choose "Tile Windows Vertically."

Type your introductory text in the Word document.

Switch to PowerPoint and open the PowerPoint file.

In Slide Sorter View, hold down the Ctrl key and select the slides you want to include.

Drag the selected group of slides onto the Word document.

You will only see the first slide in the document, but if you double-click on the image, the PowerPoint show will run.

It will also work in Excel.

(This, of course assumes that the target machine has PowerPoint or PowerPoint Viewer installed)

See all Topics

Labels: , ,


<Doug Klippert@ 3:56 AM

Comments: Post a Comment


  Saturday, November 26, 2011 – Permalink –

Forms and Slides

PowerPoint in Access


This download provides an Access database and a PowerPoint slide show.

"Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications.

This article looks at two ways of interaction between Access and PowerPoint.

The first sample illustrates how to create a PowerPoint presentation from the data in an Access table using Automation.

The second sample shows how to display and manipulate an existing PowerPoint presentation inside of an Access form, also using Automation."

Here is an MSDN article:
Working with PowerPoint Presentations from Access Using Automation

If you have some knowledge of VBA, you can probably figure it out from the code on the Access Form.



Office 2003 Sample:
Working with PowerPoint 2003 Presentations from Access 2003 Using Automation



See all Topics

Labels: , , , ,


<Doug Klippert@ 3:18 AM

Comments: Post a Comment


  Monday, October 31, 2011 – Permalink –

Click to Trigger

Make it so



A trigger is an object on your PowerPoint slide - a picture, a shape, a button, or even a paragraph or text box. When you click on it an action is initiated. The action might be a sound, a movie, an animation, or text becoming visible on the slide.

Microsoft Office Online has a tutorial:
Use triggers to create an interactive slide show in PowerPoint

"Here's a Power User column for teachers. Want to involve your students more in a presentation? Set up "triggers" for them to click as they go through the show. Triggers (related to animations) let you add surprise to your slides while inviting your viewer to take part and have fun."

Indezine.com:
Trigger Animations

All 'Bout Computers:
Trigger Happy Animations in PowerPoint


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:12 AM

Comments: Post a Comment


  Sunday, October 23, 2011 – Permalink –

'Tis the Template

Free Holiday templates


This can be considered a jumping off point for many holiday themed templates.
Here are some sources for holiday backgrounds and clipart for PowerPoint. These sites also have material for the rest of the year.

All 'Bout Computers:
Holiday AutoShapes in PowerPoint
by Kathy Jacobs
Template Ready:
Christmas FREE PowerPoint Template

Microsoft office:
Holiday templates

Powered Templates

Brainy Betty:
Christmas and Holiday Themed Templates

Sonia Coleman:
Free PowerPoint Templates


See all Topics

Labels:


<Doug Klippert@ 3:03 AM

Comments: Post a Comment


  Wednesday, October 19, 2011 – Permalink –

How Google Works

Fact and not



The magic that makes Google tick
  • Over four billion Web pages, each an average of 10KB, all fully indexed
  • Up to 2,000 PCs in a cluster
  • Over 30 clusters
  • 104 interface languages including Klingon and Tagalog
  • One petabyte of data in a cluster - so much that hard disk error rates of 10-15 begin to be a real issue
  • Sustained transfer rates of 2Gbps in a cluster
  • An expectation that two machines will fail every day in each of the larger clusters
  • No complete system failure since February 2000
Stanford University: The Anatomy of a Large-Scale Hypertextual Web Search Engine  

Sergey Brin and Lawrence Page Google.com: How Google Works
 
How Stuff/Google Works

The Economist: Case History
 
Or
 

It's all done with pigeons



See all Topics

Labels: ,


<Doug Klippert@ 3:43 AM

Comments: Post a Comment


  Wednesday, October 12, 2011 – Permalink –

Educational Slide Shows

Suggestions


Purdue University has a collection of PowerPoint shows on a number of topics.

  • Writing Skills
  • Research and Documentation St yles
  • Grammar and Mechanics
  • Business/ Professional Writing
  • Agricultural Economics/Cooperative Extension
If you have eve had to prepare a paper with MLA/APA standards these shows may come in handy:

Cross-referencing: Using MLA Format
This presentation teaches your students the purposes of MLA documentation, as well as methods for using parenthetical citations and a Works Cited page. This presentation is an important addition for the beginning of a research unit in a humanities course or any assignment that requires MLA documentation. (Writer and Designer: Jennifer Liethen Kunka)
Documenting Sources: Using APA Format
This presentation reviews the purposes of APA documentation, as well as methods for effectively using parenthetical citations and a reference page. This presentation is ideal for the begin ning of a research unit in a science course or any assignment that requires APA documentation. (Writer and Designer: Jennifer Liethen Kunka).
Purdue University

See all Topics

Labels: , ,


<Doug Klippert@ 3:26 AM

Comments: Post a Comment


  Monday, October 10, 2011 – Permalink –

Default Save

Choose your own location



When you choose to save most Office files, the Save dialog box defaults to the Documents or My Documents folder.

(The following directions work in 2007-10, but you need to click on the Office button in the upper left corner of the Window)

Word
you can change the default location by going to Tools>Options. On the "File Locations" tab you can modify the storage location.
Excel
Tools>Options. On the "General" tab change the default location.
PowerPoint
uses Tools>Options and the "Save" tab.
Access
Tools>Options and the "General" tab for Databases and Projects
Publisher
Tools>Options "General".
Outlook
will make you take an underground tour into the Registry to change the location to save e-mail attachments.
FrontPage/Expression Web
appears to require the same sort of spelunking.


Change the folder where e-mail messages and attachments are saved

Also:
D.C. Everest school district Weston, WI:
Office Default Paths

If you don't want to change the default, but would like to be able to quickly go to an alternate site, open the Save or Save Attachment dialog box. On the left side of the box is the Places Navigation bar. If you click the Desktop icon, that location will be used to save the file.

You can add spots to the bar. Browse to the specific folder. Highlight the folder and click the down arrow beside the Tools option. Select "Add to My Places."

The file or e-mail attachment can then be saved where you want.




See all Topics

Labels: , , ,


<Doug Klippert@ 3:28 AM

Comments: Post a Comment


  Friday, October 07, 2011 – Permalink –

Beyond Bullet Points

By Cliff Atkinson


ISBN 0-7356-2052-0
Microsoft Press 2005


About the Author
Cliff Atkinson is a leading authority on how to improve communications across organizations using Microsoft PowerPoint. He is a popular keynote speaker, a writer, and an independent management consultant whose clients include companies ranking in the top five of the Fortune 500. He is president of Sociable Media in Los Angeles.

Cliff teaches at UCLA Extension, is a senior contributor for the MarketingProfs newsletter, and writes the Beyond Bullets weblog, at BeyondBullets.com.
Also see SociableMedia.com

Book Description
PowerPoint owns the presentation world. We've been cocooned by a blue gradient screen with six or more bullet points feeding information.
Or so we've been lulled to believe.
(see Edward Tufte's dissection of the Columbia PowerPoint disaster)

Cliff Atkinson takes a well researched, but almost heretical stand that a presentation is a story and that too much data plastered on the screen, dulls the audience's soul and actually reduces comprehension and retention.

Beyond Bullets walks the reader through the story process and provides tools to structure presentations to have the maximum impact.

The "PowerPoint" part of the process is easy to follow, even for a novice. The story telling sections will help improve the most experienced speaker's show.

Quote

"But what might not be evident in the simplicity of this slide is what happens when the audience experiences it along with your verbal explanation. Because the slide design is simple, the audience can quickly scan the headline and visual and understand the idea. Then their attention turns to the place you want it. — to you, the words you're saying, and the way the information relates to them. Instead of making everything explicit and obvious on the slides, you can leave the slides open to interpretation so the audience is dependent on you, and you on them.

What (the experts are) saying, basically, is that slides filled with bullet points create obstacles between presenters and audiences. You might want to be natural and relaxed when you present, but people say that bullet points make the atmosphere formal and stiff. You might aim to be clear and concise, but people often walk away from these presentations feeling confused and unclear. And you might intend to display the best of your critical thinking on a screen, but people say that bullet points "dumb down" the important discourse that needs to happen for our society to function well.

Somewhere in our collective presentation experience, we're not connecting the dots between presenters and audiences by using the conventional bullet points approach. This issue is of rising concern not only to individuals and audiences - even the major players of large organizations are taking notice of the problem. It seems that in every location where people meet, from small meeting rooms to board rooms to conference halls, people want a change."

Here's the latest edition:






See all Topics

Labels: , , ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment


  Sunday, October 02, 2011 – Permalink –

No Bullets?

Heresy!


Cliff Atkinson's book, "Beyond Bullets", came out in 2005. A new version has just been released.

Shellie Tucker, of Office.Microsoft.com, tried out the suggestions in a real world situation:

"It was a gamble. And it gave us pause. Could we give a PowerPoint presentation and use NO BULLET POINTS? Could we divorce ourselves from the tried and true - and deadly boring? We decided to try."

No bullets




See all Topics

Labels: , , , ,


<Doug Klippert@ 3:21 AM

Comments: Post a Comment


  Friday, September 23, 2011 – Permalink –

Move that thing

Noise and motion


Microsoft has another of its easy to understand tutorials that deals with making objects move on the screen and also make sounds.


  • Animate text or objects

  • Add sound effects to an animation or hyperlink

  • Use sample animations in your presentation
There is also a link to a tutorial about adding sound effects to a presentation. Animation

See all Topics

Labels: , , ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment


  Friday, September 16, 2011 – Permalink –

Legacy Files from 2007

Go back


Read this article closely. If you work in a situation where you need to work with legacy (pre-2007) files, it may be handy.

If you do most of your work in 2007, I wouldn't bother.


"When you use Windows Explorer or the desktop to create a new 2007 Microsoft Office file, a new Office file is created in an XML file format (.dox or .xlsx). For example, this behavior occurs when you right-click the desktop, you point to New, and then you click Microsoft Office Word Document. By default, files that you create in the 2007 Office system are in XML file formats.

This article is about how to create legacy Office files, such as .doc files, .xls files, .ppt files, or .mdb files in the 2007 Office system. You can create legacy Office files without opening any Office applications. To do this, you must modify some settings. The modified settings will apply to all the users who log on to the computer."


See all Topics

Labels:


<Doug Klippert@ 3:46 AM

Comments: Post a Comment


  Tuesday, September 13, 2011 – Permalink –

VBA, Named Arguments

An easier read


Use named arguments for cleaner VBA code.


Most likely, you use positional arguments when working with VBA functions. For instance, to create a message box, you probably use a statement that adheres to the following syntax:

MsgBox(prompt[, buttons] [, title] [, helpfile, context])


When you work the MsgBox function this way, the order of the arguments can't be changed.

Therefore, if you want to skip an optional argument that's between two arguments you're defining, you need to include a blank argument, such as:
MsgBox "Hello World!", , "My Message Box"


Named arguments allow you to create more descriptive code and define arguments in any order you wish. To use named arguments, simply type the argument name, followed by :=, and then the argument value.

For instance, the previous statement can be rewritten as:

MsgBox Title:="My Message Box", _
Prompt:="Hello World!"


(To find out a function's named arguments, select the function in your code and press [F1].)



See all Topics

Labels:


<Doug Klippert@ 3:57 AM

Comments: Post a Comment


  Monday, September 05, 2011 – Permalink –

PPT Font Size

How big should you go?


In the old days of slide shows, presenters would hold their slides out at arm's length. If they could still see the text, then it would be OK when projected.

Dave Paradi has researched the question and offers a PDF document that compares screen size, fonts, and seating distance.

For instance:


"For example, if you're using a 60 inch screen and have 32 point text on your slides, the furthest someone should be is 57 feet from the screen."


Font Size

Dave Paradi's PowerPoint Tip




See all Topics

Labels: , ,


<Doug Klippert@ 3:33 AM

Comments: Post a Comment


  Thursday, August 18, 2011 – Permalink –

Slideshow Accesability

Hearing and vision enhanced


Dave Paradi has an article about how to design PowerPoint shows for those with limited hearing or vision.

With PowerPoint presentations becoming more of a standard way to communicate information of all types, we need to keep in mind that our first responsibility is to our audience. We need to use the ideas above to make sure that we make our presentation accessible for everyone.

Making Accessible Slides




See all Topics

Labels: ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment


  Sunday, August 14, 2011 – Permalink –

Replace Fonts

A type change



PowerPoint has a feature that allows you to replace any of the fonts being used in a presentation
You may want to do this to change the look of a show, or because the type face is not available on another machine and not embeddable.
Go to Format>Replace Fonts.

Choose one of the fonts you are currently using and its replacement.

Look over your presentation before saving it. Sometimes a different font will change the spacing on a slide. You may have to reformat a few slides

RDP Slides.com:
Troubleshoot font problems


Informit.com:
Working with Text in PowerPoint





See all Topics

Labels: , , ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment


  Sunday, July 31, 2011 – Permalink –

PowerPoint Pundits

Connect with other PowerPoint users


Microsoft has put together a list of locations, forums, blogs, etc. that cover PowerPoint.

You'll probably find that your question has been answered at one of these spots.

Office.Microsoft.com



See all Topics

Labels: , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Tuesday, July 26, 2011 – Permalink –

Viewer

Portable PowerPoint



If you have to show your presentation on a machine that does not have PowerPoint installed, you can use " Package for CD. "

Before 2003 it was named "Pack and Go."

Go to File> Package for CD ...
The Dialog box will walk you through the process and offer to include the PowerPoint Viewer.

PowerPoint Viewer

The problem with the earlier versions of PowerPoint, through 2002, was that the viewer only handled the features available in PowerPoint 97.


The PowerPoint 2003 Viewer lets you view full-featured presentations created in PowerPoint 97 and later versions.

Here is the download location for the PowerPoint 2003 Viewer:

Microsoft 2003 PowerPoint Viewer



Here's the PowerPoint 2007 viewer:
PP 2007 Viewer

Microsoft:
What happened to Pack and Go?

How to package and copy a presentation to a CD in PowerPoint 2003

Leave a good impression; distribute a business presentation on CD

"Want to truly impress your customers with a multimedia presentation about your business? You can easily make your Microsoft Office PowerPoint 2003 presentations more portable by burning them onto a CD. By including the new free PowerPoint 2003 presentation viewer on the CD, presentations can be distributed to and viewed by audiences who do not use Microsoft Office."

PP Tools:
Downloads and descriptions for other versions


See all Topics

Labels: , , ,


<Doug Klippert@ 3:05 AM

Comments: Post a Comment


  Thursday, July 14, 2011 – Permalink –

Office VBA Tricks

Video + Free code


"Learn tips and use sample code for several Office applications. These tips can help you to be more productive and can also be a starting point for developing your own tools, utilities and techniques."

  • Update Word Document Statistics in the Title Bar
  • Create Outlook Rules Programmatically
  • Delete Repeated Text Throughout a Word Document
  • Run Macros Based on the Value of One or More Excel Spreadsheet Cells
  • Disable Related Controls on a PowerPoint Slide After a User Clicks an Input Control
  • Display Reminder Information When a User Opens an Office Document
  • Synchronize an Access Main Form to a Subform and Vice Versa
  • Log Worksheet Changes to an XML File
  • Merge Body Text from Multiple Outlook E-mail Messages to a Word Document
  • Use the Office Assistant as an Alternative to Displaying and Retrieving User Input
Ten Tips for Office VBA Developers

VBA Tips & Tricks

Getting Started with VBA in Office 2010


(VBA is VBA and is, in most cases, usable in all versions of Office)
 


See all Topics

Labels: ,


<Doug Klippert@ 3:50 AM

Comments: Post a Comment