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

Outlook 2010 - Email Views

So many emails! So few views! See how to look at your inbox differently to manage it better!

Outlook 2010 - Email Views Tutorial

Pin programs to access quickly in Windows 7

If you are still searching for programs you use regularly in Windows 7,  here are two options for pinning them for quick access.

 

Option 1

1) Search for the program

2) Right click on the icon in Start Menu

3) Choose to Pin to Start Menu

4) Next time you click the Start button, the pinned program will appear on the list!

 

Option 2

1) Open the program

2) Right click on the icon

3) Choose to pin the program to the taskbar

4) The program will always be on the taskbar even when closed!

TrainerLori Channel

Outlook 2010 - Creating Rules

Learn the trick that Bill Gates created to help manage his inbox!

Outlook 2010 - Creating Rules Tutorial

Excel 2010 - Basics of Functions

Learn to master the IF function which gives you two or more options in your Excel formula!
Excel 2010 - Basics of Functions Tutorial

PowerPoint 2010 - Set Up Show

If you present using PowerPoint, learn to control how it looks through Set Up Show. See how here!
 PowerPoint 2010 - Set Up Show Tutorial

Outlook: Move all non-work email to one folder!

If you find that your corporate email is getting lost in a sea of offers and promotions, move them all with rules.

 

Be sure to create a folder for the official mail before you start this process!

1) Select File, Info, Manage Rules & Alerts

2) Click New Rule…

3) Click Apply rule on messages I receive

4) Skip the conditions section

5) Verify this rule will be applied on every email

6) Identify the specified folder

7) Exempt your corporate email addresses

 TrainerLori Channel

Windows 7 - Paint Overview

Take the tree "out of your head" in that otherwise great vacation photo! Learn how using Paint!
Windows 7 - Paint Overview Tutorial

Excel 2010 - Charting Tips

Learn to combine a line and column chart in one powerful image. This tutorial shows you how.

Excel 2010 - Charting Tips Tutorial

Outlook 2010 - Quick Steps

If you need to send the same email on a regular basis, learn to use Quick Step to do it!

Outlook 2010 - Quick Steps Tutorial

Office 2010 - Fill Magic

Learn to copy any picture or texture and use it to fill text!
Office 2010 - Fill Magic Tutorial

Word 2010 Mail Merge

Did you know you can use Word to manage your emailing!? See how here!
Word 2010 Mail Merge Tutorial

Snagit - Introduction

Learn the SnagIt tool to see how to capture pictures and video from your screen.

Snagit - Introduction Tutorial

Outlook 2010: 3 Smart Automation Tools

If you need to use the same info, hyperlinks or pix in your emails, insert it with one click!
Outlook 2010: 3 Smart Automation Tools Tutorial

Compare Excel Columns Quickly!

If you need to compare two columns for exact data in Excel, there are several ways to do it, but this is FAST!

1) Select the columns (Ctrl + A in the data will select all of it).

2) Ctrl + G opens Go To, then click Special, OK.

3) Select Row differences, then OK.

4) All the non-identical values will be selected!

Another option is to create a new column with the formula =A2=B2 (assuming your data to compare is in A and B.  Then using the AutoFill handle, double-click it to copy the formula to the end of the data.  That will return TRUE if the data is the same, or FALSE if it is different.