Associates Telephone Seminars - Training Resources

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

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

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

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

Advanced Microsoft Excel Formulas and Functions: Master Your Usage of Excel's More Powerful 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...

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

Excel Formulas and Functions De-Mystified: Manage Your Excel Worksheets With Power and Confidence as You Master Formulas and Fun 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 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...

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

401(k) Plan Costs Including Recent Update on Supreme Court Rule LaRue v. DeWolff, Boberg & Associates Inc. nUnhappy 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) plan  more...