Which Excel feature allows you to identify unlocked cells into which data can be entered

Mastering spreadsheet internal controls in MS Excel is a great way to make the most out of MS Excel. Unlocking these internal control features in MS Excel makes the program more efficient and powerful, and helps users derive more value out of its various applications.

Even though professionals in various areas, such as Accountants, CPA’s, CFO’s, Controllers, Excel users, Income Tax Preparers, Enrolled Agents, Financial Consultants, IT Professionals, auditors, human resource personnel, bookkeepers, marketers and government personnel, use MS Excel extensively in the course of their day-to-day work; they can still learn to improve and optimize the uses from MS Excel by learning more about it.

Learn the secrets of the power of MS Excel

This is what a webinar from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will offer at a highly interesting and educative webinar. This webinar will have David Ringstrom, an author and nationally recognized instructor who teaches scores of webinars each year, as speaker.

David’s Excel courses are based on over 25 years of consulting and teaching experience. He believes in the mantra: “either you work Excel, or it works you”. This is why he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower participants to use Excel more effectively.

It is this zeal the speaker carries into his teaching of MS Excel that will come into full play at this webinar. Interested in gaining from the wealth of experience that David brings into MS Excel? Then, just visit http://www.compliance4all.com/control/w_product/~product_id=501293LIVE?Wordpress-SEO to enroll.

Teaching from a simple standpoint

At this presentation, David Ringstrom will use a simple invoice form as a teaching aid to present various ways to control users’ actions within Excel spreadsheets and to protect worksheets and workbooks from unauthorized changes. What makes this presentation different is that the presenter will demonstrate every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016.

He will explain the differences in Excel 2013, 2010, or 2007 both during the presentation as well as in his detailed handouts. David will also give participants an Excel workbook that will include nearly all the examples he will be using during the webinar.

David will help participants with the following:

o  Discover how to use lookup formulas to find and access data automatically from lists

o  Apply Excel’s Table feature to future-proof elements of your spreadsheet.

o  Define how to use Excel’s Data Validation feature to restrict data entry to a list of permissible choices

o  Learn a custom shortcut for toggling the Locked status of a worksheet cell on or off

o  Understand how to preserve key formulas

o  Learn which Excel feature allows you to identify unlocked cells into which data can be entered

o  Learn a variety of ways to control users’ actions within Excel spreadsheets and to protect worksheets and workbooks from unauthorized changes.

David will cover the following areas at this webinar:

o  Using Conditional Formatting to identify unlocked cells into which data can be entered

o  Utilizing Data Validation to limit percentages entered in a cell to a specific range of values

o  Improving the integrity of spreadsheets with Excel’s VLOOKUP function

o  Toggling the Locked status of a worksheet cell on or off by way of a custom shortcut

o  Future-proofing VLOOKUP by using Excel’s Table feature versus referencing static ranges

o  Preserving key formulas using hide and protect features

o  Making it harder for a user to circumvent data validation and easy for you to identify when someone has attempted to do so.

Meeting equipment validation requirements from the FDA and EU

Putting in place a program for calibrating and maintaining test and measurement equipment is a regulatory requirement from both the FDA, under 21 CFR Part 210 and 211, and relevant EU regulations. Both these agencies have regulations that require this program from manufacturers.

The purpose of this equipment validation program is to ensure these among others:

o  The equipment is reliable and is capable of performing the use to which it is being put

o  It is safe

o  It ensures free flow of work

o  Keeps costs of preparing it down

o  Ensures that the company does not spend too much on premature replacements.

These are some of the ingredients of this program:

o  Intervals

o  Scheduling

o  Specific procedures

o  Limits of accuracy/precision, and

o  Remedial action when the equipment does not meet established requirements.

Main aspects of equipment validation

Equipment validation has to be done from these three perspectives:

o  Installation Qualification (IQ)

o  Operational Qualification (OQ)

o  Performance Qualification (PQ)

o  Change control & Requalification

Validation before and after use

Validation has to be done prior to use. An equipment must be validated to ensure that it the product being produced meets its specifications. In addition, there are ways of validating equipment that are already in use.

A thorough and proper understanding of how to plan and implement a program for the validation and maintenance of test and measurement equipment will be the learning a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will offer.

This webinar will have Jeff Kasoff, a senior Regulatory Affairs professional, who has more than 30 years in Quality and Regulatory management; as speaker. Jeff brings the rich experience of having implemented and overseen quality system operations and assured compliance, at all sizes of company, from startup to more than $100 million in revenue. To gain the benefit of insightful learning from this highly experienced Regulatory Affairs professional, please register for this webinar by visiting Calibration and Preventive Maintenance

All the aspects of calibrating and maintaining test and measurement equipment

At this webinar, Jeff will give participants an understanding of how to calibrate and maintain test and measurement equipment. He will explain all the elements that go into it, namely intervals, scheduling, specific procedures, limits of accuracy/precision, and remedial action in the event that the equipment does not meet established requirements. In addition, he will also offer an understanding of the various ways by which to validate equipment already in use.

Professionals holding positions in companies, whose work involves equipment/process development, such as QA management, Quality Engineering staff, R&D management, Engineering management, Production management, Manufacturing Engineering staff, Design engineers, Reliability engineers, Calibration technicians, and Maintenance personnel will find this session valuable.

Jeff will cover the following areas at this webinar:

o  Equipment Validation: Installation Qualification, Operation Qualification, and Performance Qualification

o  Preventive Maintenance Requirements

o  Calibration vs. Maintenance: When to use Which One?

o  Remedial Action for Out-of-Calibration Equipment

o  Use of Calibration Standards to Save Cost

o  Equipment Calibration Requirements: Scheduling, Use of External Services, and Documentation.

Why IEC 60825 certification cannot be substituted for 21CFR1040

With a few exceptions, it is necessary for manufacturers, system integrators and importers of lasers or laser containing products to implement best practices for compliance with FDA 21 CFR 1040. This is because The Center for Devices and Radiological Health (CDRH) requests documentation using the current version of their Form 3632 Guide for Preparing Product Reports for Lasers or Products Containing Lasers for laser self-certification submittals, which have to comply with 21 CFR 1040. Per Section 1010.2c, certification has to be based on a test that meets the requirements set out in this standard and has to be in accordance with Good Manufacturing Practices.

Since the CDRH does not approve form 3632 reports or the products being reported; it is incumbent upon the manufacturer, system integrator or importer to assume responsibility for certification. However, if the FDA detects gaps or deficiencies in the applicant’s quality control or testing program; the CDRH is empowered to take actions that are of a very harsh nature. It may:

o  Ask the manufacturer to halt introduction of the product into the US until the faults are corrected

o  Require the manufacturer to start a corrective action program for products that have already been released into the market

o  Impose fines of up to $300,000 for non-compliance with the requirements laid out in 21 CFR 1040.

What are the consequences of recalls?

When laser products that the FDA determines do not meet the regulatory requirements are recalled, it can have serious consequences for the business. It invites lawsuits from the user of such products. This can result in monetary losses that eat into the business’ profits. It can also damage the company’s reputation, which is something that is very difficult to overcome and compensate for.

So, the ideal course to follow for manufacturers of laser products is to be compliant in letter and spirit with the regulations laid out in 21 CFR 1040. The ways of achieving this and implementing best practices for compliance with FDA 21 CFR 1040 will be the teaching a webinar from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will be offering.

The speaker at this webinar is Tony Imm; a nationally recognized laser engineer with a background in medical device manufacturing, whose company, Laser Guardian LLC provides a wide range of laser safety and process support. To understand the ways by which to achieve compliance with FDA 21 CFR 1040 by implementing best practices; please register for this webinar by visiting Best Practices for Compliance with FDA 21CFR1040

Complete understanding of implementing best practices

Tony will give comprehensive understanding of the ways by which the test documentation system with the CDRH works. He will show how to generate form 3632 document, how to complete the form, what supporting data to attach with it and how, and then explain recommended methodologies to test and record the emission output and interlock performance of the laser systems. This session is extremely useful to those involved in working with laser products, such as Engineering Managers, Laser Engineers, Safety Manager, Safety Engineers, and personnel responsible for FDA communications.

Tony will cover the following areas at this webinar:

o  What is self-certification and when is it required

o  Methods for submitting a product report

o  Major sections of the product report

o  Why IEC 60825 certification cannot be substituted for 21CFR1040

o  What are best practices and why use them

o  Where to apply best practices and what they should encompass.

Webinar Calendar of Upcoming Courses – May to Jun 2017

webinar-training-online-education.jpgBelow is the event description content:

Compliance4All webinars are just what professionals in the regulatory

compliance areas need for scaling up in their careers. With a collection of

the most erudite experts on regulatory compliance being available at a click

in the comfort of your preferred location; regulatory compliance could not

get any simpler and effective!
Compliance4All’s experts help you unravel all the knowledge you need in all

the areas of regulatory compliance. They help professionals like you

implement the regulations and stay updated, so that regulatory compliance

causes no stress for you. Compliance4All’s experts offer their insightful

analysis into the issues that are of consequence to regulatory professionals

in their daily work. Their thoughts help you implement the best practices of

the industry into your work. They also offer updates on the latest regulatory

requirements arising out of a host of the laws and issues related to

regulatory compliance, such as Pharmaceuticals, Biologics, Healthcare, Food

and Beverages, Software, Embedded Technologies, Energy and Utility,

Payment Card Industry (PCI), and lots more.
Take a look at our upcoming webinars from Compliance4All, which will put

you on the road to learning about any area that is of importance to your

profession. You can plan your learning from Compliance4All by looking at

our events in the next few weeks. You can choose from a whole range of

topics. See which among these trainings suit you: FDA Regulation of

Medical Device Software, Conducting Successful Product Complaint

Investigations, CAPA, Failure Investigation and Root Cause Analysis, 1099

and W-9 Update, Laboratory-Developed Tests, avoiding an FDA 483,

Equipment Validation, and much more!

For more Calendar Webinars http://www.compliance4all.com/control/webinars_home

EPA’s new Revised Section 608 Refrigerant Management Regulations

In late 2016, the US Environmental Protection Agency (EPA) revised Section 608, which deals with refrigerant management regulations. A number of requirements under this section are set to change. They concern the handling requirements that are applicable to ozone depleting refrigerants, and fortify the existing regulations by incorporating a number of best practices to extend these to hydrofluorocarbons (HFCs).

The EPA has estimated that these revisions, when implemented, will cut down emissions from products such as refrigerators and air conditioners, which have a detrimental effect on the climate, to the tune of 7.3 million metric tons of carbon dioxide equivalent (MMTCO2eq) and 114 ozone-depletion weighted metric tons (ODP tons) annually.

The Rule in a nutshell

Set out with the intention of reducing the emissions from refrigerants of ozone-depleting substances; the essence of the new EPA rule can be summarized under the following:

–       The Refrigerant Management Program has now been enlarged to include substitute refrigerants such as HFCs. A few such substitute refrigerants were exempt earlier from Section 608

–       It sets a lower leak threshold for ozone-depleting implements such as refrigerators and air conditioners that contain 50 lbs. or more refrigerants. This is the new, lowered leak threshold slab:

o  30% for industrial process refrigeration (IPR) from 35%

o  20% for commercial refrigeration equipment from 35%

o  10% for comfort cooling equipment from 15%.

–       Additionally, the new revised Section 608 requires quarterly or annual maintenance leak inspections for equipment that exceed the threshold leak rate limit

–       It also requires operators and owners to report systems that exceed the limit of 50 lbs. or refrigerant leak by one and a quarter times in a year

–       It defines products whose sale is restricted because of the excess leak rate.

–       The new revised EPA Section 608 also requires technicians to document the refrigerant that they recover during disposal for systems that have a charge size varying from five to 50 lbs.

Gain clarity on the EPA’s new revised Section 608

All the ways of understanding and practically implementing the provisions of the EPA’s new revised Section 608 will be offered with clarity at a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance.

This webinar will have Keith Warwick, a professor at Yuba College in Marysville California and instructor at the University of Washington, who has significant experience teaching engineering, safety and related subjects, as speaker. To understand the nitty-gritty of the EPA’s revised Section 608 and ensure that you do not invite punitive actions from the agency, please register for this webinar by visiting EPA Section 608

Delving into all the aspects of the new revised Section 608

This webinar will discuss all the elements pertaining to the EPA’s new revised Section 608, such as technician certification, refrigerant sales restriction, service practices, recovery and recycling equipment, recordkeeping, repairing refrigerant leaks, appliance disposal, and refrigeration reclamation.

Keith will also explain how ozone depleting substances (ODS) are split into two groups under the Clean Air Act, class I ODS such as chlorofluorocarbons (CFS) and class II ODS such as hydro chlorofluorocarbons (HCFC).

The major gain of attending this webinar is that it will help the participants to understand the EPA’s new revised Section 608, which will help them to avoid violations, citations and fines. Violations of the EPA’s new revised Section 608 leads to citations which require addition of physical improvements, which can be expensive. The EPA can also shut down a facility for an extended period.

Keith will cover the following areas at this webinar:

o  General discussion of the Clean Air Act

o  How to utilize consultants

o  Technician certification

o  Refrigeration reclamation

o  Recovery and recycling equipment

o  Regulatory involvement with facility and process

o  Discussion of class 1 ODS

o  Discussion of Class 2 ODS.

Use OneNote to manage your meetings

Microsoft OneNote is a program that works as a digital notebook. It saves users the trouble of having to scramble for a piece of paper whenever they feel like scribbling some information or idea down. Moreover, it saves the user the trouble of having to preserve a piece of paper on which the info is jotted down.

Microsoft OneNote helps users to type, write or draw on the digital notebook while continuing to have the same feel as a regular paper and pen. It is designed to help people have access to note down ideas or important information with the ease of a notebook. Users can also search the web and clip pictures to the text to enhance the effect. Several other features are available to add effect to the text.

Another feature of the Microsoft OneNote program is that the documents can be shared across the www. It helps to communicate ideas, thoughts and occasions across devices. It is available for a number of devices ranging from Apple to Windows and Android and the web.

Explore the ins and outs of Microsoft OneNote

There is a lot to explore in this program. This is what a learning session from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will be offering at a webinar. The speaker at this webinar, Mike Thomas, has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. He has produced nearly 200 written and video-based Excel tutorials. It is this rich experience that will be in full display at this webinar.

To learn the nitty-gritty of all the functions that you can get Microsoft OneNote to perform for your benefit, just enroll for this webinar by visiting Best practice for creating a Notebook

Business Professionals, Business Owners, Researchers, Administration Support Staff, Educators, for that matter anyone who wants to learn how to get the best from OneNote to manage projects and their life, will gain from this session.

Putting the program to maximum use

Mike will explain how to use OneNote notes thoroughly for storing text, images, videos, embedded files and drawings and sketches. He will show how to optimize OneNote notebooks for sharing with colleagues and customers and using it for thorough collaboration at work. The ways by which OneNote can be used to manage projects, meetings, and life itself will be taught at this session.

Mike will cover the following areas at this webinar:

o  Best practice for creating a Notebook

o  Restructuring and rearranging a Notebook

o  Protecting your information

o  Using OneNote for Internet research

o  Collaborating with others / Sharing a Notebook

o  Drawing, sketching and hand-writing notes

o  Searching OneNote

o  Integrating OneNote with Outlook

o  Go Mobile: How to use OneNote on an iPad.

Cash management in ERP systems and Reconciling bank statements

Cash management is a major component in ERP systems such as Oracle. It is a module that offers information about the most critical component of the business, namely cash flow. Cash management processes and analyzes all of the business’ cash and bank transactions from a number of sources such as:

o  The payments made to a supplier as reflected in the invoices

o  The value of receipts got from the business’ sales invoices

o  Single or isolated payments not from any of these above categories

Another important role performed by the cash management module is that using it, the organization’s Finance personnel can analyze financial transactions of all kinds that happened during a selected period of time. Cash management in ERP also gives Finance the inputs that help them understand where the funds are coming in from, and how they need to be allocated and spent so that the company meets its payments-related obligations.

Functionality of Cash Management module

Usually, cash management modules in ERP systems are built to accommodate the following features:

o  Tracking Supplier Payment

o  Tracking the way in which sales invoice amounts receipts are made

o  Helping to forecast the cash flow

A learning session on cash management and bank statement set up and reconciliation

Do all these aspects of cash management sound confusing? It is to address these confusions and issues related to cash management that Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will be organizing a webinar.

Kevin Chenoweth, who has wide-ranging expertise in designing project plans for multi-million dollar Oracle R12 financial leading to under budget and on-schedule projects and has helped organizations complete full life-cycle implementations in the Oracle financials modules through effective leadership, will be the speaker at this webinar.

To hear Kevin offer his insights into cash management, which is a result of his having implemented Cash Management processes for both technology and manufacturing SMB and Fortune 500 companies such as Comcast and having addressed their particular challenges in streamlining their bank account structures and relationships to align them with their changing business structure and accounting systems; just enroll for this webinar by logging on to   http://www.compliance4all.com/control/w_product/~product_id=501331LIVE?Wordpress-SEO

The wealth of the speaker’s experience

During this course, Kevin will offer guidance and understanding about the fundamentals of Cash Management in ERP systems such as Oracle. Another important related activity, namely bank statement formats, will also be discussed, along with how to and when to apply them.

Kevin will discuss all the challenges associated with bank statement set up and reconciliation, namely how to handle various deposits in transit, outstanding checks, service charges, and non-sufficient fees. During this explanation, he will illustrate the experiences he had earlier in his career at organizations such as ComCast, where he helped prepare its merger with Time Warner with important works like streamlining its zero-balance accounts and regional banks.

Kevin will cover the following areas at this session:

o  Bank reconciliations for various types of transactions

o  Streamlining of accounts to match company strategy

o  Consolidation of accounts to match company strategy

o  Preparation of banking relationships for a merger

o  Zero Balance accounts and how to manage them

o  Understanding of cash flows in strategic initiatives

o  How cash flows interact with financial statements

http://www.managementstudyguide.com/cash-management-module-erp.htm