Executive Training Resources
 Computer and People Skills Training

                         
Certified Instructors
Local & Affordable 
  

  Computer Tips & Tricks

QuickBooks - Gain quicker access to customized fields. To get the most value out of your customized fields, add columns to relevant reports or create new reports to quickly access the information. A simple display: Display the Employee Phone List. Click the Customize button, uncheck the phone number field, checkmark the birthday field that now appears in the list, and then click OK. Title the report “ Employee Birthdays” and then memorize it for future use!

Word - Selecting text is one of the most common actions performed in Word. Here are some helpful hints to select your test with ease....
To Select:                                                         Do This:
A Word                                                             Double click the word
A Sentence                                                       Press and hold CTRL + click anywhere in sentence
A Paragraph                                                   Triple click the paragraph
Entire Document                                            Ctrl + A

Outlook - If you receive a message in Outlook but don’t have time to respond to it immediately, you can easily add it to your calendar and schedule a block of time when you will be able to reply.
To turn an e-mail message into an item on your calendar: Drag the message from your Inbox to the Calendar Icon,  Outlook Bar or your Calendar folder. This will create a new appointment item. Enter the date and time you want to reply and specify any additional options you want. Click Save and Close. Outlook will automatically notify you when it is time to respond to that e-mail.

Access - To create a split database from scratch: Create two separate database files. Put tables in the file that will be the back-end database and everything else in the front-end database file.  Open the front-end file and go to the Tables section. Create links to the back-end file by right-clicking anywhere in the Table area and selecting Link Tables from the shortcut menu. Navigate to the back-end database and select the tables you want to link!

Excel - Worksheets can get pretty big. Unfortunately, your screen can’t get big enough to accommodate all your rows and columns. If you have ever spent time scrolling in search of cell A1, you’re in desperate need of some keyboard shortcuts! The following keys will make navigating your worksheets easier:

Home Key: Press the Home key to move to the cell in column A in the current row. Press Ctrl + Home to move to A1    no matter where your cursor is located in the document.

End Key: Ctrl + End will move you to the last cell with data in a worksheet.

Go To dialog box: Press F5 to open the Go To dialog box. It takes you straight to the cell you are looking for!

Moving around in your worksheet: Try using your Tab key to maneuver around in Excel instead of Enter. Shift Tab will move you back to the previous space ( This also work in QuickBooks, Word, Access, etc...)

  Workplace Topic

                         Perform with Ethics and Integrity

You know there are some serious problems out there in the business world. It’s absolutely imperative that you and your organization do not get caught up in them. The stakes are unbelievably high; the tolerance for inappropriate behavior, anywhere, is rapidly becoming ZERO; the need to ensure people do “ the right thing” is universal. Ethics is a huge and complex subject. But truth be told, the number one (and probably most important) key to always doing what’s right is actually quite simple: Think before you act. That means checking decisions and planned activities to ensure “rightness” before implementing them.

Use the questions below as your litmus test. Answering “no” or “I don’t know” to one or more of these should be your clue that: You need a different approach, or you probably need counsel and advice from your boss, or someone else in a position of authority.  

                                                      The Ethical Action Test
1. Is it legal?
2. Does it comply with our rules and guidelines?
3. Is it in sync with our organizational values?
4. Will I be comfortable and guilt-free if I do it?
5. Does it match our stated commitments and guarantees?
6. Would I do it to my family or friends?
7. Would I be perfectly okay with someone doing it to me?
8. Would the most ethical person I know do it? 

 

May 2006

Monday

Tuesday

Wednesday

Thursday

Friday

1

Access Intro

&

Introduction to Computers

2

Excel Intro

&

Word Intro 

 

3
PhotoShop
Advanced

&

Microsoft
Project 03

4

FrontPage
Intro

&

Microsoft
Project 03

5

QuickBooks
Intro

&
PhotoShop
Web Design

8

PowerPoint

Intro

&

PageMaker

9

Acrobat Writer 

&

Excel & Word for Beginners

10

Org Plus

&

Word
Extreme

11

Crystal
Reports

Intro
&

Word 
Extreme

12

QuickBooks Intermediate

&

Digital

Photography

15

Excel
Intermediate

&
Mail Merge
(4 hrs)

16

Access  
Intermediate

&

Intro to the Internet

17
Word
Intermediate

&

Visio Intro

18   

PowerPoint

Intermediate

&

PC Maintenance 
& Security

19
QuickBooks Advanced
&
Illustrator

22

Excel
Advanced

&

PowerPoint Intermediate 

23

Outlook

 

&

HTML Intro  

24

ExcelFunctions

&

Crystal 
Reports

Advanced

25

Access Advanced

&

Conflict Management   

26

QuarkXpress

&

QuickBooks
Payroll

29

 

Closed

For

Memorial Day!

 

30

Access
Extreme

&

PowerPoint Advanced

31

FrontPage 

Advanced

&

 PowerPoint

Extreme 

 

 


 

  Meet Out Staff

Name: Janet Stiffler

Position: CEO and QuickBooks Instructor                  

Speciality: QuickBooks Pro Advisor and Business Management

Family: Wonderful husband and 2 teenage daughters. We also
have a puppy dog and 3 indoor cats


Hobbies & Intrests: I love to read and go hunting with my husband

Hometown: Chesapeake Bay, Maryland

Loves: Taking a nap on a cold, rainy day

Dislikes: Lima Beans

Dreams of: Building a log cabin on 5 acres once our girls are grown and on their own

Looks forward to: Going camping for the 1st time!

 

          New Extreme Classes!
                      Now Available for Advanced Users

  • Excel Advanced Charts
  • Access Extreme
  • Excel Advanced Functions        
  • PhotoShop Extreme
  • PhotoShop Web
  • PowerPoint Extreme
  • Word Extreme

 

Technical Humor:
Customer: I have problems printing in red...
Tech Support: Do you have a color printer?
Customer:
Aaaah...............thank you.

 

Need to brush up on your computer skills?
Schedule a class now - You'll be glad you did!