Category Archives: Word-Excel-PowerPoint

VIDEO: How to Type International Characters in Office Software Using AutoCorrect to Do It Automatically

You can create text with accented characters once and after that, your Microsoft Office software will change it automatically using AutoCorrect (I tried this in Word, Excel, PowerPoint, Outlook, and OneNote).

In this video, I changed the English “e” to an accented one. (Microsoft has a list of what to type to get other characters at the link below the video.)

Check out this link to more shortcuts for typing various international characters.

PEACE.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Subscribe to Peggy Duncan on YouTubeAbout SUITE TUESDAY: How-to video series produced How-to video series produced by personal productivity expert, Peggy Duncan. Real quick video tutorials of tech tips that will help you finish work quicker so you can go home. Explained in plain English with no fluff. Click to SUBSCRIBE to my YouTube channel. Free to share. #SuiteTuesday

About the Author: Peggy Duncan is an award-winning, international personal productivity expert, conference speaker, consultant, and coach. She uses her skills as a professional organizer, project manager, and computer trainer to help busy professionals spend less time working but get more done.

Do you need training: seminar, workshop, Webinar, coaching, consulting? Click here to visit my Website.

Full, pre-recorded lessons are on my membership Website DigitalBreakthroughs.com

Video: Create Your Own Keyboard Shortcut: Print Current Page in Word With a Macro

When I work in a multiple page document, I often want to print only the current page I’m working on. One way to finish work quicker is to create your own keyboard shortcut when one doesn’t already exist.

To create a keyboard shortcut, you can either find the computer code someone has posted and figure out what to do with it, or you can create your own shortcut by recording your own macro. But don’t worry about the code. All that’s in the background, and you won’t even have to see it.

In the video below, I’m using Word 2013. However, recording a macro has worked the same in all versions of Word I’ve ever used.

 

Hope this helps. Feel free to comment and share.

PEACE.

 

Video: How to Collect and Use Multiple Items from Office Clipboard

You can save up to 24 items in your Microsoft Office Clipboard. Cut and copy items from various sources, including the Internet, and they’ll all be there until you turn off your computer. You’ll find them using the Dialog Box Launcher.

No more freaking out when you copy something on top of something else, thinking you’ve lost it. This quick video will save the day. Help others in your network by sharing this video.

Suite Tuesday. I hope you'll click Like, Share, and Comment on this video

 

 

 

Hope this helps. Feel free to comment and share. #SuiteTuesday

PEACE.

 

Video: Put Commands at Your Fingertips with the Quick Access Toolbar QAT

There’s a little bar at the top of your screen in the Office software. Chances are that you’ve never paid it any attention. I use it all day.

The Quick Access Toolbar (QAT) allows you to add shortcuts to commands you use often. This real quick video shows you how to customize it with commands that are there by default as well as any you choose from the ribbon.

Hope this helps. Feel free to comment and share. #SuiteTuesday

PEACE.

 

One Space Goes After Period, Not Two. Here’s How to Fix Your Document and Break the Habit (video)

Since the advent of computers and word processing software, one space goes after a period, not two.

Why? The simplest explanation is that in typesetting, software makes room for a wide letter such as W. (The Courier font is an exception. This is a monospace font (or non-proportional), which is a typewriter-like, fixed-width font, and each letter occupies the same amount of space. Other computer fonts are variable-width (or proportional), and the software adjusts the spacing automatically.

One space has been the norm since mid 20th Century. “The Complete Manual on Typography (2003) states that “The typewriter tradition of separating sentences with two word spaces after a period has no place in typesetting” and the single space is “standard typographic practice.” This is especially important in publishing and press releases you send to the media.

 

Here’s a quick video to show you how your Office software will find all instances of two spaces after a period and replace them with one space. Fixed before you can blink.

 

Note. When I was in publishing and had to fix documents from other people, I recorded a macro and created a toolbar button (and a keyboard shortcut) that fixed everything with one click. I’ll record a future video to show you how to do this.

Break the Habit

To break the habit of adding two spaces after the period, every time you do two spaces, stop right then. Delete the last few words, and try again, focusing on doing one space. It’ll soon become the norm for you.

PEACE.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

About SUITE TUESDAY: How-to video series produced by Peggy Duncan. Real quick video tutorials of tech tips that will help you finish work quicker so you can go home. Click to FOLLOW me here on LinkedIn Pulse. Explained in plain English without any fluff. Free to share.

More tips from Peggy Duncan on LinkedIn Pulse. Click here.

About the Author: Peggy Duncan is an award-winning, international personal productivity expert, conference speaker, consultant, and coach. She uses her skills as a professional organizer, project manager, and computer trainer to help busy professionals spend less time working but get more done.

Do you need training: seminar, workshop, Webinar, coaching, consulting? Click here

Full, pre-recorded lessons are on my membership Website DigitalBreakthroughs.com

How to Select, Collect, and Insert Multiple Items from the Office Clipboard

When you Ctrl+X to cut text or Ctrl+C to copy, you might think that you’ve lost the text once you cut or copy more text.

Actually, everything you’ve cut or copied is still on the Clipboard until you shut the computer down. Here’s how to view and use everything.

10 Shortcuts to Selecting Text in Microsoft Word (with video)

Here are 10 shortcuts I use almost every day when I need to select text in Word. As far as I can remember, these tips work the same in all versions.

There are more shortcuts to selecting text, but I rarely use them. Just wanted to share the most common ones.

Please share with your network.

PEACE.

Webinar: Mail Merge Customized Emails, Mailing Labels, Forms, and More

Learn how to use Word’s mail merge commands to personalize and customize mailing labels, email messages, and more!

Just in time for those holiday greetings!

Save time! Stop typing personalized correspondence one at a time. 

Did you know you can:

  • Create personalized email messages and include an attachment?
  • Separate documents or PDFs for each recipient during a single merge?
  • Filter your database and create mailing labels for select recipients?
  • Create a template once and use it as many times as you want?
  • Produce a directory of contacts you can print or format as a PDF?

Whether you’re using an Excel spreadsheet, a Word table, or Outlook contacts, I will show you step by step how to set up, filter, and perform a mail merge.

Click here for details on this Mail Merge Webinar!

Please share.

PEACE.

Print Your Postage and Schedule Pickups to Save Time Shipping

DYMO Label Writer 450 Twin Turbo label printer, 71 Labels Per Minute, Black/Silver (1752266)It’s so easy and convenient to ship letters and packages these days. I print my USPS postage using my Dymo LabelWriter. Then I schedule the pickup online at USPS.com. The letter carrier knocks on my door for the package the next day.

Need shipping labels? You can use this Dymo unit to print them. I also created my own shipping labels in Microsoft Word. Here is a video to show you how.

 

 

You can spend a little time now and set all this up and save so many hours later.

PEACE.

What Do You Know That Can Be Packaged and Sold?

You know a lot about something…might even be an expert. Have you considered packaging your knowledge in small bites and selling it? Booklets might be one of your answers.

When I don’t have enough info for a whole book, I create little booklets. I just sent Finding Your Way on a PC with Windows 8 to press this week. I’m a professional speaker and have to have physical books/booklets to sell when I speak. I’ll also format for Kindle. My printed booklets are from 10-40 pages, various sizes, and packed full of no fluff content.

Here are a couple sample pages. I use Word for everything…it’s a powerful desktop publishing program. I can do everything myself so I always have the latest version of my stuff.

I use Word Styles for ease of formatting. The page size is changed to fit whatever size I want, plus .25 more for the trim. My Windows 8 booklet is sized at 3.75 x 8.75 with a finished size of 3.5 x 8.5.

Microsoft has always done a lousy job showing people just how powerful their software is in the real world. Table of contents, mirror margins, cross references, index…Word can do it all and keep up as page numbers change.

I create my booklet covers in PowerPoint. You’ll have to use special software, ImageExport, to bump up the dpi when you save as a picture (I have a video on YouTube about it and how to use it ImageExport (Part 1 of 3): Create High Resolution Graphics and Slides in PowerPoint?).

For printing, I use Smartpress.com. I love the prices, quality, the efficiency of their Website (no phone calls needed), fast work, paper choices, and they keep you posted every step of the way. I create high res PDF of inside pages and high res .jpg of covers, upload separate files, and they take it from there.? I always order an online proof.

So don’t let the fact that you don’t have enough information on a topic to write a book. Create a booklet instead.

Note: I might create an online course on using Word to create booklets. Join my private email list to stay connected.

PEACE.