Consolidate quickly sums in Excel

See training on Trainer Lori channel!

If you need to sum totals from several worksheets, try consolidate which does all the calculations for you! 1) Use the same headings on each data worksheet 2) In a new sheet, click in A1 3) Click Data, Consolidate 4) Choose Sum to add the totals 5) Add each of the data sheets 6) Click OK Consolidate will organize and sum all the sheets!

Make Word merge show new record

 
Visit the Trainer Lori YouTube channel for free video tutorials!

When you are creating merged records in Word, sometimes the same record appears on every label for the page. Here’s how to ensure each new label gets a new record.

1) Under Mailings tab, insert merge field in the new label

2) Do it again for all the labels on the same page

3) On the second and subsequent labels, insert your cursor before the field merge code, then click Rules, Next Record

4) New records now appear on every label, not just every sheet!

https://www.youtube.com/user/TrainerLori

Delete Web History

 

Web history can clog resources and slow down searches. You can delete web history in Google and Internet Explorer.

In Google:

1) Enter a search topic to view Google tools

2) Click Web History

3) Select the ones to delete and click Remove Items

In Internet Explorer:

1) Select Tools, Delete Browsing History

2) Select what type of data to delete

3) Click Delete

See Trainer Lori on YouTube

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

Word 2010-Table of Contents

Do you know that headers allow you to instantly create table of contents in Word?
Word 2010-Table of Contents Tutorial

Presenting With Impact - Delivery

If you have to give a speech and don't know where to start, start here!

Presenting With Impact - 2 Presentation Delivery Tutorial

Fixing Excel borders that won't print

How frustrating to find that the borders that printed yesterday, won't print today.  Here are some possible fixes. Try them until it works!

 

Go to File, Print, Page Setup. On the Sheet tab under Print, check Gridlines and uncheck Draft quality.

Use Roundtripping: Save as HTML, then resave the file as Excel.

Save the file as  Excel 2003.

The border may be on the cell adjacent to the one you think it’s on. Try removing all borders and recreating them within the print area.

Double click the  printer to download a new printer driver.

TrainerLori Channel

Office 2010 - Exploring Options

Personalize your MS Office to be EXACTLY what you want!

Office 2010 - Exploring Options Tutorial

Excel 2010 - Basic PivotTables

Did you know Excel PivotTables are easier than you think!

Excel 2010 - Basic PivotTables Tutorial

Compress media to save space in PowerPoint!

1. Note your file size (File, Info, Properties)

2. If in Compatibility Mode, Convert

3. If there is video or audio, Compress Media to Low Quality

4. Click a picture to activate Picture Tools tab

5. Click Compress Pictures

6. Deselect Apply only to this picture. Select E-Mail (96 ppi). Click OK

7. Click Save
8. See how much you compressed!
 

 

TrainerLori Channel

Access - Action Queries

Learn to automatically append, delete, or update data in Access.

Access - Action Queries Tutorial

LinkedIn - Business Basics

Learn the powerful tools of LinkedIn to help build your professional network.
LinkedIn - Business Basics Tutorial

Make Windows 7 Interface Larger

If you don't want to use reading glasses to see the Windows 7 screen, watch this short tutorial on how to increase the size of fonts, icons and gadgets!

Windows 7 Interface Overview Tutorial

Time Management - Quadrants of Effectiveness

Do you live in crisis mode? Learn to manage your time.  Managing your time means managing your life!  Here are tips how!

 

Time Management - Quadrants of Effectiveness Tutorial