Monthly Archives: March 2017

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: Use PowerPoint to Design YouTube End Screen Template (Lots of PowerPoint Tips Inside)

Use PowerPoint to Create YouTube End Screen TemplateI use PowerPoint for just about everything I need graphic-wise. I go way beyond just slides. YouTube introduced End Screens in 2016, and YouTubers can add these thumbnails to the last 5-20 seconds of their videos. They can be set up to point to your other videos, other channels, subscription link, your Website, and more.

I created my End Screen template because the thumbnails would set on top of my tips video and hide some of the information. This slide-turned-video leaves space for the video links that YouTube adds.

PowerPoint Tips You’ll Learn

Watch this video whether you have a YouTube channel or not because you’ll learn lots of PowerPoint tips. Here are some of them:

  • Resize a slide.
  • Format slide background with gradient fill.
  • Frame a slide with a rectangle shape.
  • Align objects horizontally and vertically.
  • Create more guides and also how to remove them.
  • Animate objects to appear automatically at the right time.
  • Use the Shape Tool to totally transform a shape.
  • Rotate objects.
  • Select multiple objects with your mouse.
  • And probably more that I forgot. Just watch!

Here’s My Video

And here’s my video on how I used PowerPoint to create my End Screen template (related videos are below also).

Leave a comment, Like, Share. Thank you. Feel free to leave a link to yours (if you use PowerPoint) in a comment. Would love to see it.

Related Videos

I also mentioned two some other videos related to this, and here are the links.

Export a PowerPoint Slide as a Video (I recorded this one).

How to Record Narration to PowerPoint 2010 (watch regardless of your version). I don’t use PowerPoint for narration, but if I did, I’d use his tips. YouTube channel is MCHS Des Moines

How to Use YouTube End Screen Editor for Your Videos, from Derral Eves (absolute YouTube expert…for real!)

PEACE.

 

 

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