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 memorize it! )

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 and click anywhere in the 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 onto the Calendar icon the Outlook Bar or onto 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 ( These 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. And 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?

 

 Class Schedule

April Schedule 

Monday   Tuesday   Wednesday Thursday    Friday  

 

 Meet Our Staff

Name: Janet Stiffler
Position: CEO
Specialty: QuickBooks
Hometown: Chesapeake Bay, Maryland
Family: Husband, 2 teenage daughters, 3 cats, and a puppy dog.
Dislikes: Lima Beans
Loves: Taking a nap on a cold, rainy day
Looks forward to:  Going camping with my husband for the first time
Dreams Of:  Bu
ilding a log cabin in the mountains once our girls are off on their own

 


 Go to the EXTREME!!

New Extreme Classes!  Now available for advanced users. Contact us for more details!

  • Access Extreme

  • Excel Advanced Charts

  • Excel Advanced Functions

  • PhotoShop Extreme

  • PhotoShop Web

  • PowerPoint Extreme

  • Word Extreme

  • Mail Merge

We appreciate and welcome your comments!


Executive Training Resources
Idaho Innovation Center
2300 N Yellowstone Highway, Suites 103, 105, 209 & 210
 
Idaho Falls, Idaho 83401
208.525.8813  etr@etrdirect.com