Record audio narrations in PowerPoint

Visit the Trainer Lori YouTube channel for free video tutorials!
When creating training, instead of recording a web-based meeting with lackluster audio, distracting pauses, tiny screen shots and a hard-to-use format, record it in PowerPoint!

　

1) Use a good quality noise-canceling headset or external microphone
 

2) Slide Show, Record Slide Show, Start Recording…

3) Select both options and click Start Recording

 

4) The elapsed time and pause button appears

5) When finished, right click the sound icon to Trim Audio

6) Trim off pauses and unneeded audio

　

You can save the completed deck as a video for even easier sharing!

Merge names for email in Excel

If need to take a list of names in Excel and turn them into email addresses for Outlook (active directory), here are two options!

 

Option 1 - First and last names are in two separate columns starting in A1:

1) Insert a new column to the right and use Concatenate

2) In the formula bar type =A1&" "&B1 (note the space between the double quotes)

3) Double click AutoFill handle (in the cell's bottom right corner) to...

4) ...copy the formula down to the bottom of the data

5) Copy and paste the column of formula as Value (right click and choose the option with 123)

Option 2 - First and last names are in column F, separated with a comma:

1) Insert a new column to the right and use multiple functions

2) In the formula bar type:

=RIGHT(F1,LEN(F1)-LEN(LEFT(F1,FIND(",",F1)-1))-2) & " " & LEFT(F1,FIND(",",F1)-1)

(this will also work if there is a middle initial)
3) Double click AutoFill handle to...

4) ...copy the formula down to the bottom of the data

5) Copy and paste the column of formula as Value (right click and choose the option with 123)

Trainer Lori's channel on YouTube

 

Embed YouTube video link in PowerPoint

If need to show a YouTube video in your PowerPoint presentation, here are the steps.

You must have internet access to play it back!

 

1) Go to YouTube and select the video and then Share

 

2) Select Embed and check Use old embed code

3) Copy the code then open the PowerPoint presentation

4) Click Insert, Video, Video from Web Site…

5) Paste the code in the box and click Insert

Embed YouTube in PowerPoint tutorial

Create a duplicate shared file in OneNote

If you need to create a new shared notebook based on one that's not shared, here's a quick fix without having to recreate the entire notebook or other sharing options that may not work!

 

1) Create a new notebook in the shared location

 

2) Right click on the Section tab to copy

3) Choose the new notebook and where to place the copied section

4) Copy each section the same way!

 

TrainerLori Channel

Prep for page numbers in PowerPoint

Creating page numbers in PowerPoint is as easy as clicking Insert, Slide Number, right?! Not if you didn't do the prep steps first!

1) Click Slide Master and the first slide to verify slide number place holder is on

If the place holder does NOT appear, click Master Layout and check Slide Number and copy to each slide master

2) Click Insert, Slide Number to insert a slide number in the master

3) Click Insert, Slide Number to insert a slide number in the master and Exit master view

Now you can click Insert, Slide Numbers and actually have them appear!

 

Visit the TrainerLori channel!

Access 2010 Basic Queries

Access queries are the workhorse of the database! Learn how to master them in this concise tutorial!

Access 2010 Basic Queries Tutorial

Excel 2010-Database Features

Instantly transpose your row headers into column headers in Excel!


Excel 2010-Database Features Tutorial