Associates Telephone Seminars

Utilizing Macros in Microsoft Excel BenefitsWhen you find yourself repeating actions in Excel - whether it's a five-step sequence you use when formatting a certain cell type or the 30 steps you use when you sort, filter, and print multiple worksheets once a week, the possibility exists that you can automate these actions in the form of a macro. Thereafter, you can perform these sets of actions with a simple keystroke combination, a  more...

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...

How to Avoid Death by PowerPoint BenefitsEvery day, executives, managers, and rank and file employees sit through bullet-riddled presentations that are boring, uninspiring and worse, don't get the message across. Attend this live audio conference and learn how to use several techniques that will engage and excite your audience without using bullet point after bullet point. You will learn how visual metaphors, targeted animation  more...

Utilizing Graphs and Charts in Microsoft Excel BenefitsAny Excel user who needs quick methods to show numerical information in a visual way needs to know the basics of chart creation, how (and why) to use different chart types, and how to alter the look of a chart with layout, color and content changes. Depicting data in a chart may reveal a trend that was not so obvious in the numerical data, which often can be dry and boring. That elusive  more...

Upgrading to Microsoft Office 2010: What's New and Improved? BenefitsOffice 2010 has many new and improved features which can mean a longer learning curve for users upgrading from older versions. New Microsoft Office users may be overwhelmed by the number of features and options available and never take full advantage of the potential it offers for managing email, PowerPoint , Access , SharePoint workspace and Excel . Join us to learn the new and improved  more...

Refining Your Business Writing Skills BenefitsDo your written communications to clients, employees and stakeholders position your message appropriately? Are you getting responses to your business letters and emails that show you are being heard? Without question, your written communications influence the way internal and external audiences view you and your organization. In fact, in today's global marketplace, this may be the only  more...

Recent Developments in Employer Liability for 401(k) Investments BenefitsUnhappy employees, U.S. Department of Labor investigations, IRS investigations, massive class action lawsuits - an ever-expanding list of factors bombards sponsors of 401(k) plans, and places companies and their management potentially in the cross hairs. From Enron, Worldcom and Sarbanes-Oxley, to the more recent massive class actions filed against Fortune 500 companies regarding 401(k)  more...

Business Associate Agreements After the HITECH Act ...er before. The HITECH Act now directly obligates business associates to comply with the HIPAA Security Rule's administrative, physical and technical safeguard requirements, including developing and implementing comprehensive written security policies and procedures with respect to the protected health information that they handle. Failure by business associates to abide by such requirements can  more...

Advanced Microsoft Excel Formulas and Functions BenefitsEven if you are fairly comfortable with building formulas and functions in Excel , you might still be missing out by having overlooked some powerful functions or just not be aware of special capabilities, like array formulas. There's no question that Excel's 300+ functions give you tremendous capabilities to tackle a myriad of statistical, mathematical and financial challenges, not to  more...

Discover the Secrets of Microsoft(R) Excel Pivot Tables BenefitsAny Excel user who maintains database-like data invariably needs tools to manage and analyze the data beyond mere sorting and filtering. Excel 's pivot table feature gives you a quick and powerful way to create summary cross-totals combined with an enormous flexibility to restructure your results with simple dragging of fields. Whether you need the ability to create a quick look at the  more...

Criminal Liabilities Under HIPAA ... many HIPAA privacy and security requirements to business associates (law firms, consultants, accounting firms, etc.), tightened HIPAA privacy requirements and establishing new civil and criminal HIPAA penalties. Health plans, health care clearinghouses, health care providers and Medicare prescription drug card sponsors may be prosecuted criminally for HIPAA violations. With ID theft on the  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...

Implications of the Stimulus Package on HIPAA ...hich are already in effect. New requirements for business associates of HIPAA covered entities and requirements to notify individuals in the event of a breach are only two of the many areas affected in the new law, including new requirements for restricting and accounting of disclosures and increased enforcement activity. This teleconference will help you understand what you have to do and  more...

Fundamentals of Form W-2 Processing ...y for the payroll department is getting the pay checks to associates acutely and timely to employees. But a critical function for the payroll department is to pull all the payroll information together and produce a Form W-2 for all employees. This produces a great challenge to payroll departments to ensure that all elements of the W-2 are complete and accurate along with complying with federal  more...

Understanding and Troubleshooting Copyright Law BenefitsCopyright is one of the most complex, confusing and broadly applicable areas of law. Copyright protection vests in even the smallest amount of creativity, and with the proliferation of electronic media, your employees and clients have unprecedented access to these protected works. As a result, it is easier than ever for you, your clients or your company's employees to infringe the  more...

Using Failure Mode and Effects Analysis to Reduce Defects, Improve Quality and Make More Money nFailure modes and effects analysis is an increasingly popular tool that must be mastered by Lean Six Sigma professionals and can be used in every type of organization to reduce defects, improve quality and make more money! n nThis easy tool asks these simple questions: n- What can go wrong? n- Where can it go wrong? n- How bad will it be? n- Can we see it coming? n- Should we try to prevent  more...