|
Host your Web site with PureHost! |
 Monday, November 30, 2009 – Permalink – Find the WordAnd ReplaceWord has one of the most complete and malleable Find/Replace systems of any application. Here is a 26 page report on how to use it from Editorium.com. While your there, sign up for the free newsletter. Advanced Find and Replace for Microsoft Word "One of Word's most powerful features, especially for editing, is Find and Replace using wildcards and character codes. This free tutorial (a Word document) will take you step by step through what you need to know. If you don't download anything else here, be sure to get this--and work your way through it. It's well worth the effort." Editorium.com/Freebies [Edited entry from 11/29/2006] See all Topics Labels: Word <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Sunday, November 29, 2009 – Permalink – New Conditional FormattingMuch more capabilitiesPre-2007 Excel was limited to only 3 conditions. The new Office is more generous and versatile. Here are some of the features:
2007+ Conditional Formatting [Edited entry from 11/28/2006] See all Topics Labels: Excel <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Saturday, November 28, 2009 – Permalink – 3-D BreakoutNo special glasses requiredYou are not limited to a flat PowerPoint slide. You can add a 3-D look to your shows. Bart Jones at OnPPT.com provides some basic suggestions. Also see this series by Glen Millar.
Also: PPTMagic.com 3D Transitions [Edited entry from 11/25/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Friday, November 27, 2009 – Permalink – Get ToastedIt's a recommended practice"Let's face facts. The whole low-carb craze is playing itself out. The USDA recommends that every day we eat 6 to 11 servings of bread, cereal, rice, pasta, and other foods containing grains, especially whole grains. Bread is not the enemy of a healthy body, if you select the right bread. 300 Ways To Enjoy Toast By Mr Breakfast Also: Roller Toaster [Edited entry from 11/24/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:42 AM
Comments:
Post a Comment
Thursday, November 26, 2009 – Permalink – Send PicturesEmail PhotosIf you have a photo on your computer, from a digital camera or something that has been scanned to produce a JPG, GIF, or PNG file. Here are two choices for doing that: There is a little more to it. Here is a link to a great newsletter that comes in handy again and again: Office-Watch.com [Edited entry from 11/22/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Wednesday, November 25, 2009 – Permalink – Spell Check OnSpell check offYou can run Spelling and Grammar checking in Word by clicking on the ABC icon on the Standard toolbar (it's on the Review ribbon in Word 2007), going to Tools> Spelling and Grammar, or just hitting the F7 key. As you go through the document, you may find areas that you would like to correct. You don't have to close the Spell checker, just click into the document, make the changes and click Resume in the Spell checker dialog box. You can also flip focus to the document with Ctrl+Tab. Then go back to checking with Resume. [Edited entry from 11/28/2006] See all Topics Labels: Word <Doug Klippert@ 3:57 AM
Comments:
Post a Comment
Tuesday, November 24, 2009 – Permalink – Formatting OverviewLooking goodThe judicious use of formatting can make data easier to understand as well as pleasant to see. Scott Lowe put together a series of articles on how to format data in Excel. The Articles are on TechRepublic.com Anatomy of Excel formatting: Part 1
[Edited entry from 11/20/2006] See all Topics Labels: Excel <Doug Klippert@ 3:37 AM
Comments:
Post a Comment
Monday, November 23, 2009 – Permalink – Psst-Cheap GasDrive to Save"GasBuddy.com is the portal site to more than 170 web sites that help consumers find cheap gas prices. All web sites are operated by the non-profit organization known as GasBuddy Organization Inc. Also: Gas Price Watch.com Autos.MSN.com [Edited entry from 11/19/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:31 AM
Comments:
Post a Comment
Sunday, November 22, 2009 – Permalink – More Free TemplatesThree dozen moreSometimes it takes someone else's example of a PowerPoint show to stir your own imagination. Graphicsland is offering a collection of 36 templates for PowerPoint. The templates are saved as .pot files & are compatible with all versions of PowerPoint. The collection is free of charge & is available now for downloading. Free Templates [Edited entry from 11/27/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Saturday, November 21, 2009 – Permalink – History is Something to Play WithGames for kids (and you)History can be boring when the only reward is a scribbled "Acceptable" on a test paper. But what if part of the game is to build a trebuchet to fling the teacher? "Welcome to the SchoolHistory.co.uk downloadable resources centre. This has been updated to allow quick, easy access to our resources kindly contributed by other teachers. There are now over 1,400 pages of resources available." Interactive History Games  Also see Build a Trebuchet in your Backyard [Edited entry from 11/16/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:20 AM
Comments:
Post a Comment
Friday, November 20, 2009 – Permalink – Download All Outlook PicturesThe Good and the EvilBy default, Outlook 2003 blocks all HTML content that is referenced by an external location. Many junk e-mail senders put an image URL in the e-mail message. The image URL notifies the junk e-mail senders' Web server when you read or preview the e-mail message. This type of image URL is also known as a "Web beacon." An example of a Web beacon image URL is: Also, you receive the following InfoBar message that indicates that the HTML content has been blocked: Click here to download pictures. To help protect your privacy, Outlook prevented automatic download of some pictures in this message. With all that warning, if you still want to do it:
 [Edited entry from 11/15/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Thursday, November 19, 2009 – Permalink – Control Access Text AlignmentDistribute Text Evenly Within ControlsWhen you add form or report controls, the Text Align property defaults to General setting: characters align to the left while numbers and dates align to the right. When you set up controls to act as headings or titles, you can achieve interesting visual results by changing the Text Align setting to Distribute (This is called Justify in Word). This setting distributes characters within the control evenly to span its entire width. If you apply this setting to a textbox control, the alignment switches to Left alignment when you click inside the control to allow for easy data entry.
[Edited entry from 11/14/2006] See all Topics Labels: Access <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Wednesday, November 18, 2009 – Permalink – Type with One HandDoes 85 WPM impress you?
"Computer Keyboard Shortcuts for one hand typists. Resources for vocational, occupational, rehabilitation therapists, and their clients, who have lost full, or partial use of one hand, with a special emphasis on learning to type with a standard keyboard."  "This video clip is of me, Lilly Walters. Note how I use my less able hand to do the SHIFT key. I am typing on a normal keyboard. I really do up to 85 words per minute - with enough caffeine and sleep. The keyboard shown here is a NORMAL keyboard you will find in any office, school or home. No alternative keyboard layouts. Just what all of my peers use. By the way, I type faster than most of my peers! All because I learned to type with one hand." [Edited entry from 11/13/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Tuesday, November 17, 2009 – Permalink – New in 2003/2007Fresh lookWhen Office 2003 was released, the only application that showed obvious changes from the earlier version was Outlook. Slipstick.com does a good job describing the changes and providing useful links. Also Office System 2007 Here is the Microsoft Office 2003 Editions Product Guide Here is Microsoft Office Outlook 2007 product overview 2010 adds the Ribbon. There is an apocryphal story that when Outlook was first considered, it was a PDA, kind of an electronic date book. One Microsoft manager, supposedly, questioned adding an e-mail reader, since any one who wanted to do that, could just do it on the Internet. Another story was that Microsoft was a little slow recognizing the Internet, because their managers were too old. They were in their late 20's and when they went to school the net had not progressed that far from the Well in San Francisco. When the young graduates entered the company, they were used to Internet access from their dorm rooms. MS woke up and swung the ship around almost overnight. [Edited entry from 11/12/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:37 AM
Comments:
Post a Comment
Monday, November 16, 2009 – Permalink – Office Bling BlingFor your real desktopC.A.Daniels & Company offers some decadent, fun, office bric-a-brac.  Hippo stapler  Hare Brush and Mirror  Hippo Clock/Paperweight  Trout Razor BoingBoing.net refers to the El Casco company for more desk bling. Also: Too much Bling "A couple of months ago I bought a 17" LCD monitor (PolyView V17E). However, when I first powered it on, the thing that struck me was just how bright the blue power LED was! This power LED is just next to the power switch, immediately below the screen itself. The LED was bright enough to be very distracting, to the extent where it was just too bright to be able to look at the bottom part of the monitor without needing sunglasses. [Edited entry from 11/11/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
Sunday, November 15, 2009 – Permalink – Color NewsA multidiscipline subjectHere is a study about how color effects a reader's choice of concentration. It was intended for newspaper publishers, but the same knowledge can be used in Web design, PowerPoint, or any other reporting application. Word and Excel will also benefit. Color, Contrast, and Dimension in News Design ColorProject The Poynter Institute is a school for journalists, future journalists, and teachers of journalists. Poynter.org [Edited entry from 11/8/2006] See all Topics Labels: Access, Addendum, Excel, Expression Web, FrontPage, Outlook, PowerPoint, Word <Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Saturday, November 14, 2009 – Permalink – When Will You Die?Let the government help you find outStadium High school in Tacoma, WA (WWW.CelebrateStadium.com) recently celebrated 100 years.  There have been 38,797 graduates since 1906 and 24,176 could still be alive. This report presents period life tables for the United States based on age-specific death rates in 2003. Life expectancy at birth, selected years 1900-2003 United States Life Tables - PDF [Edited entry from 11/7/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:23 AM
Comments:
Post a Comment
Friday, November 13, 2009 – Permalink – Link to Office Documents from AccessClick to Word, PowerPoint, ExcelYou can create hyperlinks in Access that jump to other Office documents. The process of specifying the document and the bookmark you want to jump to can be cumbersome. There's an easy way to specify where in a Word, Excel or PowerPoint document that a hyperlink should jump to, without even having to open the Insert Hyperlink dialog box.
[Edited entry from 11/7/2006] See all Topics Labels: Access <Doug Klippert@ 3:40 AM
Comments:
Post a Comment
Thursday, November 12, 2009 – Permalink – Switch ControlsStartup flagsMicrosoft supplies switches or flags that can be used following a Command-Line start of an application After the Executable allow a space and the enter the Switch. The Microsoft Outlook Help file contains an entry that lists command-line switches, which you can use to start Outlook in a specific mode or with a specific form. Search for "Switches". Here's a good one:
 Command-Line Switches HowTo-Outlook [Edited entry from 11/6/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Wednesday, November 11, 2009 – Permalink – Cheap CertificationBargain dealBecoming certified can be expensive and time consuming. Here's a way to be certified as an HTML Developer, or ASP Developer.
W3 SchoolsEven if you don't take the test, the tutorials are free![Edited entry from 11/3/2006] See all Topics Labels: Expression Web, FrontPage <Doug Klippert@ 3:41 AM
Comments:
Post a Comment
Tuesday, November 10, 2009 – Permalink – Movie MechanicsHow to make it workHere are four ways to do it: Method 1: Insert a movie from a file To insert a movie into a PowerPoint presentation, use the Movie from File option on the Insert menu. If the presentation is located anywhere in the file path at which the movie file is located, PowerPoint stores the movie file as a relative path in the presentation. If the presentation is not located at the path at which the movie file is stored, PowerPoint stores the movie file as an absolute path in the presentation Method 2: Insert a movie file as an object When you insert a movie as an object, PowerPoint is not involved in the process. The process occurs in Microsoft Windows Media Player. Windows Media Player has a set of APIs that PowerPoint 2003 uses primarily for movie playback. Windows Media Player keeps its own set of codecs. And, it uses the Windows registry file types to determine which format and codec to use. Windows Media Player looks for a codec signature in the file and then matches the codec that it finds. If Windows Media Player cannot find an appropriate codec, it searches the Web for a valid codec. Method 3: Use the Wmp.ppa add-in By default, when you use the Wmp.ppa add-in to insert a movie file into a PowerPoint presentation, PowerPoint stores the movie file as an absolute path in the presentation. If the movie file is not in the absolute path, the movie does not play. The add-in also contains an option that you can use to copy the movie file into the same folder as the presentation. When you use this option, PowerPoint stores the movie file as a relative path in the presentation. When you play the movie file in the presentation, PowerPoint looks for the presentation in the folder that is defined when the presentation is created. If the movie file is not in that folder, the movie will not play. Method 4: Insert the movie as a package You can insert a movie file as a package in a PowerPoint presentation. To do this, follow these steps: You'll find all the details at: Support.microsoft.com Insert a Movie in PowerPoint PP 2007+ [Edited entry from 11/1/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:12 AM
Comments:
Great article! Videos can really spice up a presentation. Have you checked out the Office community on Facebook yet? Just head to http://www.facebook.com/office
Post a Comment
Cheers, Andy MSFT Office Outreach Team
Monday, November 09, 2009 – Permalink – Wipe it CleanWorks, but dangerous"Cipher.exe is a command-line tool. Microsoft has developed an improved version of the Cipher.exe tool that provides the ability to permanently overwrite (or "wipe") all of the deleted data on a hard disk. Support.microsoft.com: Cipher.exe Security Tool Using cipher.exe File Shredder Permanently delete data from your hard drive [Edited entry from 10/31/2006] See all Topics <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
Sunday, November 08, 2009 – Permalink – No Read ReceiptsShut them downEmail that includes a Read Receipt request can be a bother. You could click no when Outlook asks to send the reply, or you can set up a more permanent solution.
(In 2007+ click the Office button and go to Options>Mail)  [Edited entry from 10/30/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:45 AM
Comments:
Post a Comment
Saturday, November 07, 2009 – Permalink – Go Back 23 HoursReally save useful time"Therefore, let us keep the fall ritual as it is. However, one Sunday each Spring, let us set our clocks not one hour forward, but TWENTY-THREE HOURS BACKWARD. Stop Daylight Saving Time Daylight Saving Time About Daylight Saving Time Wikipedia Daylight Saving Time Saving Time and Energy Daylight Savings Google News As a result of the U.S. passing the Energy Policy Act of 2005, Daylight Saving Time in the U.S. will change starting in 2007. DST will begin on the second Sunday of March and end the first Sunday of November. [Edited entry from 10/29/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:13 AM
Comments:
Post a Comment
Friday, November 06, 2009 – Permalink – Journalor notWhen you are poking around in Outlook, you may click on the Journal icon. A dialog box will appear asking if you want to turn Journal on:  Resist the temptation. Every Word/Excel/PowerPoint and Access file will be placed on a time line. Every e-mail sent to a Contact will be indexed. This will slow down your machine. It is a massive overkill. If you are involved in a project, you can use Journal to track specific documents. Here is a Microsoft Knowledge Base article on how to Disable Journaling for All Users. Here are some Journal Issues. If you still want to use Journal, here are some references from Slipstick.com. [Edited entry from 10/28/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:42 AM
Comments:
Post a Comment
Thursday, November 05, 2009 – Permalink – Change Code to CommentsFast solutionWhen you're testing procedures, you can temporarily convert a block of VBA code to comments that will be ignored during a trial run. Doing so manually by inserting an apostrophe before each line of code can be a real chore. To simplify this task,
[Edited entry from 10/27/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:39 AM
Comments:
Post a Comment
Wednesday, November 04, 2009 – Permalink – Paste is SpecialVersatile functionsIf the data you brought into Excel comes through as text rather than numbers, Paste Special can fix it.
What's So Special About "Paste Special"? Excel Paste Special function Pasting Using Paste Special [Edited entry from 10/27/2006] See all Topics Labels: Excel <Doug Klippert@ 3:04 AM
Comments:
Post a Comment
Tuesday, November 03, 2009 – Permalink – Pen TrixBe cool in the officeYou've seen people twirl pens in their hands; rolling around their fingers. Here's how to do it. What is Pentrix? Pentrix is the new and improved version of Pentix - The Art of Pen Spinning web site. Pentix has been around since January, 2000 and has grown in popularity among pen spinners ever since. The mission of Pentrix is to teach people how to spin their pens. PenTrix.com There's also Glowsticking:  GlowSticking.com [Edited entry from 10/23/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
Monday, November 02, 2009 – Permalink – Emperer of Scent, TheBy Chandler BurrISBN 0-375-50797-3 Random House 2002 About the Author Has contributed to The Atlantic, New York Times Magazine, and the Washington Post among others. Book Description A Story of Perfume, Obsession, and the Last Mystery of the Senses. Luca Turin proposes a new theory of smell. Vision is perceived by light vibrations; Sound as well. Turin proposes that the same is true of Smell. The science gets a little deep, but the human story is compelling. Whether he is right or not has not been universally decided. The fights between branchs of science are like civet fights. Quote One scientist, Richard Doty, says "You may have noticed that if you breath through your nose, you tend to breathe through only one side of it for a while, then for a while through the other. . . When you smell information on the right side, you send it to the left side of the brain and vice versa, and you find a statistically significant increase in verbal scores when you breathe through the left side of your nose." October, 2004 "The Nobel Prize in Physiology or Medicine this year goes to two Americans who have puzzled out the sense of smell. Richard Axel and Linda Buck will split $1.4 million for discovering how chemicals in the air trigger thousands of recognizably different odors." National Public Radio Also: Olfaction "Doty's comment is incorrect. Actually, it might be from Chandler Burr's book, that was unclear. The olfactory receptor sites do not switch recognition to the opposite brain hemisphere. What is breathed in through the right nostril goes directly to the right side of the brain, the left to the left." Anonymous [Edited entry from 10/19/2006] See all Topics Labels: Books <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Sunday, November 01, 2009 – Permalink – Paper ArtFold it all up Caterpillar on a leaf PDF Origami.com Here are a couple of sites that provide templates and instruction about Origami; paper folding: Animated lesson OrigamiHeaven.com David Mitchell is internationally known for his ground-breaking origami designs and publications. He is a particular specialist in the field of modular origami but is also a prolific inventor of one-piece paperfolds, novelties, flexagons, puzzles, visual paradoxes and magical effects. This site sells paper and provides templates: Paper and More [Edited entry from 10/19/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:49 AM
Comments:
Post a Comment
|
