Certified Instructors Professional, Local, & Affordable Please check your browser settings if you are unable to view this newsletter   Computer Tips and Tricks Excel -  When creating a formula, try clicking on the cells instead of typing cell addresses.  Your formulas will be much more accurate the "first time." Windows -  Need a DOS window?  Click the Start button, choose "Run," type CMD, and hit the ENTER key. Internet Explorer -  In the address bar, try entering a company name (with no spaces) and hitting CTRL-ENTER on your keyboard.  This combination adds "http://www." and ".com" to the name, saving you quite a few keystrokes. QuickBooks - When entering your Vendors into QuickBooks do not use the Account # Field. Instead, drop down a line or two in the address field and type your account # there. This way your account # always prints on the check but leaves your Memo field to document what you purchased or a Memo you may want to list.       Class Schedule Finally ready to upgrade to Microsoft Office 2007? Well, you are not alone.  After being released over a year ago, companies are starting to embrace the new changes, discovering that 2007 is fancier, snazzier and easier to use!  Sign up for a class today and see for yourself. July 2008 Monday Tuesday Wednesday Thursday Friday Saturday June 30 Living Online  1 Photoshop Introduction 2 Basic Keyboarding 3 Mail Merge  4 5   FrontPage Introduction Word Introduction Access Introduction Photoshop Elements Independence Day! Computer Fundamentals Illustrator Introduction  Expression Web Introduction (Day 1) Expression Web Introduction (Day 2) Access 2007 Introduction    7 Computer QuickStart  9-12pm $29 8 PowerPoint Introduction 9 Resume & Interview Skills 10 Outlook Introduction 11 QuickBooks Introduction 12   Excel Introduction HTML Introduction Office 2007: New Features  Excel 2007 Introduction  Visio Introduction Access Communication Building Skills Access Intermediate Crystal Reports Introduction Photoshop Advanced  InDesign Introduction    14 Word Intermediate 15 Photoshop for the Web  16 Visual Basic for Access (Day 1) 17 Visual Basic for Access (Day 2) 18 QuickBooks Intermediate 19 Computer QuickStart 9am-12pm $29 Access 2007 Intermediate Excel Intermediate  PC Maintenance & Security Outlook Advanced Illustrator Advanced PowerPoint HTML Intermediate OrgPlus! Excel 2007 Intermediate  Flash Advanced  Publisher Computer QuickStart 1pm-4pm $29 21 Excel Advanced Project (Day 1) 22 Word Advanced 23 InDesign Adv Project (Day 2) 24 Excel Extreme: Charting  Project (Day 3) 25 QuickBooks Advanced 26   Expression Web Intermediate Visio Advanced Word 2007 Introduction  PowerPoint Advanced Digital Photography Excel PowerPoint Intermediate Access  Advanced  Excel Building Macros  Crystal Reports Advanced Access 2007 Advanced   28 FrontPage Advanced 29 PowerPoint Extreme 30 Access Extreme   31 Search Engine Optimization  August 1 QuickBooks Payroll August 2 PowerPoint 2007 Introduction Excel Extreme: Functions  Cultivating a Winning Attitude Business & Technical Writing Computer Fundamentals Word Photoshop Artistic Effects Cascading Style Sheets  AutoCAD (Day 1)  AutoCAD (Day2)  AutoCAD (Day 3)    August 2008 Monday Tuesday Wednesday Thursday Friday Saturday 4 Photoshop Elements 5 Expression Web Intro (Day 1) 6 Expression Web Intro (Day 2) 7 PowerPoint Introduction 8 Intro to Word & Excel 9 PowerPoint 2007 Introduction Access Introduction  Word Introduction  Word 2007 Introduction  Excel Introduction  QuickBooks Introduction Word  Project (Day 1)   Computer Fundamentals Project (Day 2)  Project (Day 3)  Illustrator Introduction    11 Access 2007 Introduction  12 Outlook Introduction  13 Excel Intermediate  14 InDesign Introduction  15 Conflict Management  16 Excel Word Intermediate  PowerPoint Intermediate  Photoshop Introduction  Access Intermediate  QuickBooks Intermediate Computer Quick Start  9am-12pm   $29 Office 2007: New Features  All About the Internet  HTML Introduction  PC Maintenance & Security  Excel 2007 Introduction  Computer Quick Start 1pm-4pm   $29 18 VBA for Excel  19 Photoshop Advanced  20 InDesign Advanced  21 Word Advanced  22 PowerPoint 2007 Intermediate   23 Access 2007 Intermediate  HTML Intermediate  Word 2007 Intermediate  Visio Introduction  QuickBooks Advanced PowerPoint  Excel Advanced  Excel 2007 Intermediate  Access Advanced  Excel Extreme: Charting  OrgPlus!    25 Publisher  26 Visual Basic 2005 (Day 1) 27 Visual Basic 2005 (Day 2)   28 Visual Basic 2005 (Day 3)   29 Excel 2007 Advanced 30 PowerPoint Advanced Access 2007 Advanced PowerPoint 2007 Advanced  Access Extreme QuickBooks Payroll  Access Word 2007 Advanced HTML Advanced  Excel Extreme: Functions  Cascading Style Sheets  Computer Quick Start  1pm-4pm   $29    Click here to see our Rexburg Class Schedule  Click here to see our Pocatello Class Schedule  Click here to see our Jackson Class Schedule Looking for a class not on our schedule? Click here to Contact us and we will be happy to get it on the schedule for you!   Workplace Topic                               Helpful Computer Tips for your Friends We all do dumb things now and then, and computer users are no exception. Inadvertently pressing the wrong key combination or innocently clicking OK in the wrong dialog box can change important settings that alter a computers behavior or even crash the system. Many new users are often fearful that one wrong move might break the computer forever. Luckily, short of taking a sledge hammer to the box, the consequences are not usually quite that dire. Even so, users often do create problems for their computers. Here is a description of common missteps you can share with your users and friends  to help them steer clear of preventable problems:  Remember these are DO NOTS. #1: Plug into the wall without surge protection #2: Surf the Internet without a firewall #3: Neglect to run or update antivirus and anti-spyware programs #4: Install and uninstall lots of programs, especially betas #5: Ignore the need for a backup and recovery plan #6: Open all attachments #7: Click on everything #8: Share and share alike #9: Pick the wrong passwords #10: Keep disks full and fragmented See the entire article by visiting our Business Articles page at: http://www.etrdirect.com/Articles.html   Technical Humor Sure, cruising in a few minutes late on a Monday might be the office norm. But ask Finance Staffers what the holdup was, and you might get more than you bargained for. The latest survey from CareerBuilder says more than one-in-ten workers (13%) admit to arriving late to work at least once a week. Another 24% say they are late at least once a month. Most admit to the more common causes: 10% said getting children ready for school or day care slowed them down 27% blame traffic or the weather, and 11% said they just fell asleep again (kudos to the honest) But the real kicker is 20% of employees admit to making up fake excuses to explain their tardiness. How fake? Here is the list of the top ten most unusual excuses for tardiness: I had to take my cat to the dentist. I could not find the right tie, so I had to wait for stores to open so I could buy one. I saw that you were not in the office, so I went looking for you. My son/daughter tried to flush our ferret/lizard/cockatoo down the toilet, and I needed to tend to the animal. I dreamed that I was fired, so I did not want to get out of bed. I stopped for a bagel sandwich, the store was robbed and the police kept everyone there for questioning. I ran over a goat. A bee flew in my car and attacked me, so I had to pull over. I made it all the way to the office before I realized I was still in my pajamas. I wet my pants and went home to change.      Have you Used Microsoft Office 2007 Yet? Below is the all-new user interface for Microsoft Word 2007. Excel and PowerPoint have a very similar look. Aside from the changed appearance, the new version has some pretty cool features that do not take long to realize you cannot live without them.  See the calendar for class dates.  New features include: - Ribbon - Live preview - Quick  access  bar - New file formats - Styles   - Themes - Dialog box launcher - Office button - Mini toolbar - SmartArt - Contextual tabs - Compatibility mode - PDF features - New views - Developer tab                                      Come Take a Class in Our New Rexburg Office! Our NEW OFFICE is now open in REXBURG! Call 656.0555 for class information.  Click here to see our class schedule for our REXBURG  location. Our NEW OFFICE is also open in POCATELLO!  Call 233.1428 for class information.  Click here to see our class schedule for our POCATELLO  location.