2007 Telephone Seminars

Utilizing Formulas in Microsoft Excel BenefitsAnyone using Excel invariably needs to create and understand how to use formulas and functions. For some Excel users, it is the centerpiece of what they do on a daily basis. Many Excel formulas involve simple mathematical constructions using addition, subtraction, multiplication and division, but sometimes you need more complex formulas to reach an answer. Excel has more than 300 built-in  more...

Excel Power Tips and Shortcuts BenefitsNeed an Excel productivity boost? You can now learn simple tricks and many shortcuts that will make you instantly more proficient using Excel ! Most Excel users are underutilizing this software. Start using the full power of Excel , and learn cool Excel tips and tricks that will make you the 'go-to' person in your office! Master more than 100 tips to make you a Power User! This live audio  more...

AIA Contracts: The Owner-General Contractor Agreement ... able to discuss key provisions and revisions to the A101-2007 and A201-2007 AIA documents. - You will be able to define the AIA A101-2007 and A201-2007 documents. - You will be able to explain AIA forms and how they allocate risk. - You will be able to review general contracting tips. This audio conference is designed for attorneys, presidents, vice presidents, owners, project managers,  more...

Utilizing Graphs and Charts in Microsoft Excel ...ures. This audio conference will be presented in version 2007. This audio conference will be displayed for attendees via GoToWebinar's interactive component, for which Lorman will provide access and installation instructions in advance. GOTOWEBINAR is a registered trademark of Citrix Online, LLC and this event is not sponsored by or affiliated with Citrix Online. This audio conference is  more...

New Features and Functions in Updating to Excel 2007 ...itsAny Excel user who is making the transition into Excel 2007 needs to get up to speed and needs help in locating familiar features that have been redesigned or relocated. Version 2007 is the biggest change in Excel's history and without a road map to its new features, you will waste a lot of time and be inefficient - you need this teleconference! We will give you indispensable tips for  more...

Oil SPCC Update: How do the Ongoing Changes Affect You? ...ining and clarification efforts associated with the 2006, 2007, 2008 and 2009 changes, changing the effective date over and over again. With most of EPA's changes complete, this teleconference will address the big changes presented by the numerous Federal Register announcements. Learning Objectives - You will be able to recognize SPCC plan elements. - You will be able to discuss inspection of  more...

Loan Workout Complications: Second Lien Issues ... loans were issued between 2003 and the second quarter of 2007. A significant portion of these second lien loans were issued to borrowers who are now in, or facing, restructuring and/or bankruptcy proceedings. This teleconference will examine the strengths and potential pitfalls of first lien/second lien intercreditor agreements in such a restructuring/bankruptcy framework. Specific attention  more...

Design Professionals' Exposure for Design Errors and Omissions ...l. Learning Objectives - You will be able to discuss the 2007 provisions of the AIA agreements. - You will be able to identify the area of greatest risk. - You will be able to review exceptions to the ELD. - You will be able to describe how insurance and contractual protections can be used to minimize the exposure of the design professional. Engineers, architects, attorneys, construction and  more...

Discover the Secrets of Microsoft(R) Excel Pivot Tables ...will demonstrate the use of pivot tables in Excel version 2007 (with occasional references to the 2003 version) and will include GoToWebinar interactive component. MICROSOFT is a registered trademark of Microsoft Corporation and this event is not sponsored by or affiliated with Microsoft Corporation. EXCEL is a registered trademark of Microsoft Corporation and this event is not sponsored by  more...

Microsoft Outlook 2007 Tips and Tricks BenefitsOutlook is a powerful, feature-filled personal information manager but many users are overwhelmed by the features and options available and never take full advantage of the potential it offers for managing email, calendar and contacts. They don't discover the time-saving shortcuts Outlook provides or utilize the many options included in Outlook. This teleconference offers a quick course in  more...

ConsensusDOCS Contract Fundamentals ...2007, the Associated General Contractors of American and the Construction Owners of America folded their AGC contract documents program into a new organization and issued a new series of contracts called the ConsensusDOCS. These forms, some revised and some entirely new, were issued at nearly the same time as the American Institute of Architects' 2007 revision of the AIA contract documents and  more...

Uniform Customs and Practice for Documentary Credits Update ...2007, the rules governing letters of credit, the Uniform Customs and Practice for Documentary Credits, changed for the first time in over 12 years. The objective of this change is to clarify the rules, reduce discrepancies and disputes, and encourage renewed usage of letters of credit. Significant revisions include a change in the amount of time banks are allowed to examine documents, revised  more...

Understanding the New Penalties for Tax Preparers ...have been made to the preparer penalty of IRC §6694 since 2007. The standard of care needed to avoid the penalty has been raised, the penalty is greater and the reach of the penalty is broader. In addition, there are various other penalties and rules of conduct you must be aware of and new guidance has been issued in several of these areas in the past year. It is imperative that you understand  more...

Liability Issues for Design Professionals ...es is even more complex now because of the release of the 2007 AIA documents. Register for this teleconference and get detailed information on AIA documents' effect on design professionals and the changes to those documents on the important issues affecting design professionals. Don't miss this critical opportunity for design professionals whether in large, medium or small firms. n nLearning  more...

AIA and ConsensusDOCS Contract Documents: Comparison and Contrast ...truction contract documents have both recently issued the 2007 editions of their respective families of contract forms. The long established family of documents published by the American Institute of Architects has been substantially revised. The new family on the block, the ConsensusDOCS, represents an effort by a broad industry coalition of construction industry interests (owner, contractor,  more...