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
Monday, March 4, 2013
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.
Friday, March 1, 2013
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)
Thursday, February 28, 2013
Access 2010 - Database Objects
Should you import from
Excel or link to Access? We will show you how in this concise tutorial. Access 2010 - Database Objects tutorial
Tuesday, February 26, 2013
Excel - Subtotals And Consolidations
I was shocked when I
found out Excel can do the math for me without formulas! Here's how! Excel - Subtotals and Consolidations Tutorial
Monday, February 25, 2013
Word 2010 - Paragraph Options
If you spend time in Word 2010, you need to master paragraphs!
Learn all your options and how to change the defaults.
Word 2010 - Paragraph Options Training
Word 2010 - Paragraph Options Training
Limit Data in an Excel List
Want to limit the
choices in a cell (or column)? Data validation does that (and so much more!)
1. Create the list in the worksheet, sort according to your use (you can hide it later, if you want)
2. Click the cell to format
3. Choose Data Validation
4. From Allow: choose List
5. From Source: choose the list location
6. The cell now has a drop down of options based on your list
7. If you want, copy the formatted cell down the column.
Trainer Lori channel of FREE training!
1. Create the list in the worksheet, sort according to your use (you can hide it later, if you want)
2. Click the cell to format
3. Choose Data Validation
4. From Allow: choose List
5. From Source: choose the list location
6. The cell now has a drop down of options based on your list
7. If you want, copy the formatted cell down the column.
Trainer Lori channel of FREE training!
Subscribe to:
Posts (Atom)