Presenting With Impact

Have to give a speech? This shows you how to organize your content for impact!
Presenting With Impact Training

Excel Advanced Filtering

If you've ever wanted to copy filtered Excel data and got all data instead, we'll show you how to master it!

Excel Advanced Filtering

Social Media - Action Plan

How can you manage Facebook and Twitter and LinkedIn as a small business? Gain insights here!

Social Media - Action Plan

Quick Tips to Reduce Email

Automatically delete a 1,000 unneeded emails in Outlook at once!

Learn how in this quick tutorial.

Quick Tips to Reduce Email Tutorial

Insert reusable text fast!

If you need to use the same information (sentences, paragraphs, links or images) over and over, don't simply copy and paste, master the tool Quick Parts!

 

1. In Outlook (this also works in Word), create an email with the information you want to duplicate, then select it.

 

2. Click Insert, Quick Parts

 

3. Scroll down and click Save Selection to Quick Part Gallery…

 

4. Name the new building block something easy to remember

 

5. To reuse the info in a new email, type the name and hit ENTER when the flag shows!

 

The complete information appears automagically!

 

Excel 2010 - Basics of Formulas

Have you ever created an Excel formula and got exactly half the total you expected?! We will show you why!

Excel 2010 - Basics of Formulas Tutorial

Office 2010 - The Ribbon

New PC? You need the Ribbon every day. Learn to tame it here!

Office 2010 - The Ribbon

Office 2010 - Hyperlinks

Hover over a word in any Office 2010 document and have your short message appear! Learn how in this brief tutorial!

Office 2010 - Hyperlinks tutorial

Excel - Security

Learn the 8 ways to keep your Excel data safe in this video tutorial. Excel - Security

PowerPoint 2010 - Picture Tools

Can't email a large PowerPoint file?
Learn how to compress the pictures to make it more manageable.
PowerPoint 2010 - Picture Tools

Create Follow Up Flag in Outlook

If you want to send an email about an event plus a calendar reminder, you can do both at once! You choose if it's for the recipient or you or both!

 

1. Go to Home, Follow Up, Flag for Recipients

2. Click Flag for Me or  Flag for Recipients and set the event times

3.  Check Reminder  to set the date and time for the alert to popup



Remove names from tracked changes in Word

If you want to track changes in a document, but don't want anyone to see who made the tracked changes or when they were made, you can!

On the Review tab, ensure Track Changes is ON.

 

1. Go to File, Info, Check for issues

2. Click Inspect Document, Inspect

After the Inspector finishes, you will see several 'Remove All' buttons.

3. Click Remove All for Document Properties and Personal Information to retain tracked changes, but remove the author's name and date

Trainer Lori channel of FREE training!

Access - Database Design

See the 7-steps of building an Access database from planning to reports in this concise tutorial!   Access - Database Design Tutorial

Trainer Lori Channel on YouTube

Assertive Communication Skills

Learn to say the RIGHT thing at the RIGHT time!

Assertive Communication Skills Training

Trainer Lori

Word 2010 (& Outlook) - Writing Tools

When pasting information from the web you might have more paragraph breaks than you expect. Learn how to remove them fast!
Word 2010 (& Outlook) - Writing Tools Tutorials

Send Outlook emails on YOUR schedule

Want to choose when to send and receive emails instead of automatically? You can!

1. Go to File, Options in Outlook

2. Choose Advanced

3. Under Send and receive, deselect Send immediately when connected

4. Click the Send/Receive button

5. Deselect the Schedule an automatic send/receive every __ minutes

6. Click OK to save the settings.

To send and receive when you choose, go to the Send/Receive tab and click Send/Receive All Folders.

Trainer Lori channel of FREE training!

Find Unsaved Files (Within 3 Days of Closing)

Horror!  The file you've been working on all day crashes. You forgot to save.  Where is it? Can it be recovered when AutoRecovery doesn't open?  Yes!

1. No matter the program, find it under File, Options, Save

2. Copy the file location

3. Open Windows Explorer

4. Paste the file location (Search by date, if needed)

5. Open the file (in File, manage the versions, if needed)

 

Trainer Lori channel of FREE training!