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