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

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

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

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!

 

 

Excel 2010 - Conditional Formatting

Make duplicates automagically change color in Excel! http://ow.ly/hLb1V

Office 2010 - Customizing the QAT

Learn to customize that little toolbar with the funny name, QAT (Quick Access Toolbar) that resides at the top of your Office programs.
Office 2010 - Customizing the QAT Tutorial

Power Search on Google

Do you search on Google and get 45 million hits, but still can’t find what you’re looking for? You are not alone! Registration is now open for my newest live webinar for ASAP on Power Search: Underused Google Features!  Sign up for Power Search Webinar

Access 2010 - Linking and Importing

This is the easiest way to create an Access database. See how! http://ow.ly/hLaCV

Excel - Custom Formatting

What is the difference between # and 0 in Excel custom formatting? We show you!
http://ow.ly/hys4T

Access 2010 - Relationship Settings

Access 2010 - Relationship Settings: I know it's Valentine's Day today.  See how to fix relationships! In Access, anyway!

 Access 2010 - Relationship Settings

New Google Search webinar!

I'm excited about all the tips and tricks I discovered while preparing for the new ASAP webinar!

For example, did you know you can do math in the Google search box!? No need for a calculator!

Also, you can limit sales sites in your search!

Power Search: Underused Google Features

Word 2010 - Text Effects

Word 2010 - Text Effects: Imagine making your text appear to be hovering over the page! See how here! http://ow.ly/hyrYL
Word -Text Effects

Excel - Advanced Functions

Excel - Advanced Functions: What are arrays in Excel and why are they so powerful? See here! Excel - Advanced Functions Training

Excel - Top Keyboard shortcuts

Trainer Lori shared a link Excel - Top Keyboard shortcuts: "If you've ever lost use of your mouse, you know how important keyboard shortcuts are! See how to use Excel's top shortcuts here! Excel - Top Keyboard shortcuts

Outlook lets you look into the future!

Look into the future! Use Room finder in Outlook to find the best time for meetings. Outlook 2010: Meeting & Appointment Basics

Picture Manager fixes dark pix

Snap a pix in the club and it's too dark! See how to fix it instantly in Picture Manager.
Picture Manager: Overview training

Disk Cleanup frees up hard disk space

Are temp files and downloaded program files you don’t need any more clogging up your memory and system resources?  Here’s how to find Disk Cleanup:

All Programs, Accessories, System Tools, Disk Cleanup

Choose the drive to clean (C: is your computer) Scroll down to see which ones are the memory hogs and then check the files to delete!

See the Trainer Lori Channel for more tips and training!