VIDEO: How to Email a Single Excel Worksheet in a Workbook (with video demo)

If you’ve needed to email a single worksheet out of a workbook, here’s a quicker way to do it instead of saving a copy and deleting what you don’t want to send. This tip works the same in every version of Excel I’ve used. (I’ve recorded a video demo below.)

  1. RIGHT-click on the tab of the worksheet you want to email (if you want to send more than one worksheet, hold down the Ctrl key and click each one).
  2. Click Move or Copy
  3. Change the To book drop-down to (new book), then tick the Create a copy box, OK.
 The desired worksheet(s) will now be in a separate workbook. Save (or not) and send via email.
To finish work quicker, you have to learn which button to click! I schedule regular training and will also come to you in person and on the Web.

Video Demo

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

 Personal Productivity Expert

(Video) How to Export a PowerPoint Presentation to Video

If you add animation to one or more slides, or timed transitions between them, you can save the presentation as a high resolution video that is sized for the big screen. This video shows you how to export a slide that’s already created, not how to create the slide and add animations (I’ll create a different video for that).

Note: I recorded this video in PowerPoint 2013, and although the output provides the option for 1080p resolution, native PowerPoint would only output to 720p. UPDATE: I’ve found an Add-In from a PowerPoint expert that outputs to 1080p. http://skp.mvps.org/videotools.htm

 

Let me know what you think about this video. How can I improve my videos?

PEACE

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: Shortcut to Increase-Decrease Font Size in Word, PowerPoint, Outlook

I’m pretty sure I use this shortcut every day. When I want to increase or decrease text to a certain size that I’m not sure of, I don’t go back and forth to the ribbon or use any command that requires me to choose a size.

Here’s my favorite shortcut that I use in Word, PowerPoint, and Outlook. It’s not the one you may have been using.

 

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

PEACE.

 

Video: How to Sign a PDF Without Printing It: Create a Custom Stamp with Your Signature in Adobe Acrobat and Foxit Phantom PDF

You don’t have to print a document just to sign it. When I receive a contract from a client, it’s usually a PDF. I created a Custom Stamp in Adobe Acrobat that’s an image of my actual signature. With a couple of clicks, I pop it onto the document and email it right back.

I’ve explained the entire process in the video below. Take a few minutes to set this up, and start saving time, paper, and ink.

  1. Write your signature on white paper.
  2. Scan (or photograph in good lighting) the signature, and save in the .PNG format (for best quality). Crop as needed.
  3. BONUS: Insert the image into PowerPoint (or Word), crop more if needed, make the background transparent, and save the new transparent image.
  4. Create the Custom Stamp in Adobe Acrobat.
  5. BONUS: Use an Adobe Acrobat competitor, Foxit Phantom PDF, to do this (the app I currently use).

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

PEACE.

 

Video: How to Add a Video (and Other Media) to Your Linkedin Profile

If you haven’t added video or other media to your Linkedin profile to showcase your service or product, what are you waiting for? It’s quick and easy (I recorded from a free Linkedin account before the anticipated update, and this still works).

 

Here’s how to insert a video from YouTube, an article from a Website, and a file.

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

PEACE.

 

Video: Organize the Chrome Browser With Folders and Shortcuts

I organize everything around me, including the junk drawer in my kitchen. No one who knows me is surprised to see how I also organized my browser bookmarks.

Using the same principles of organizing that you’d use for anything else (putting like things together using broad categories, then subcategories), you can put the sites you visit often at your fingertips and in a logical order.

In this video, I’ll demo how to display the Chrome Browser Bar and how to add, rename, and organize browser shortcuts.

Suggestion: Don’t just add links to your Bookmark Bar. Think about how they can be grouped and organized. This is the reason I started the video talking about the Bookmarks Manager.

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.