Learn how to build professional, eye-catching form-driven applications and spreadsheets

MS Excel, a wonder program, has umpteen uses for a number of professionals, students, and a host of other users. We have known for long that it can be used to carry out a number of functions that are varied and interesting. However, adding design elements to MS Excel goes a long way in enhancing its aesthetic appeal, as also the effectiveness.

Booking forms, sales order forms, invoices, loan agreement forms and surveys are just some of the endless kinds of forms that can be created using Excel. These can be made a lot more attractive and likeable by just adding a touch of features such as color, cell protection and some drop-down lists and simple validation.

A few simple steps at design

Just a few splashes here and there into these forms, and you will be amazed at the extent to which these bland forms can transform themselves into user-friendly ones that will make data entry simple and error free for everyone concerned, be it the user, her colleagues, or her clients. Small techniques such as this will eliminate the hassle of having to go through the long-winded, repetitive and frustrating experience of entering and editing data into a table in Excel.

This is just one of the many tricks that will be taught at a webinar on adding design elements into MS Excel to make it more illustrative, attractive and useful. At this webinar, the Expert, Mike Thomas, the globally acclaimed guru of MS Office, who has spent over a quarter of a century as a subject matter expert in a swathe of subjects relating to MS Office and Mac, will be the speaker.

Loads of experience

The experience and wisdom that Mike has gained over these years, during which he has been Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors, will be in full flow at this highly interactive webinar session. Want to know how to optimize the use of design elements into MS Excel to make it more palatable and likeable? Just log on to http://www.compliance4all.com/control/w_product/~product_id=501316LIVE?Wordpress-SEO to enroll and relive the fun of learning about MS Excel.

Adding design elements into MS Excel to save costs and time

The main benefit that people across a spectrum of professions and activities, such as Business Professionals, Business Owners, Researchers, Administration Support Staff Educators, or for that matter anyone who wants to learn how to get the best from MS Excel to manage projects and their life, will gain from this webinar is that they can save the invaluable resources of time and money by learning to enhance the use of forms in MS Excel.

This session is highly useful to smaller organizations that are constrained with limited budgets and will think twice when needed to buy expensive dedicated software to manage the inputting and storage of information. This of course, does not preclude bigger companies from this learning.

Using other MS Excel features to create forms

The speaker will enable participants to follow real-world examples to learn how to build professional, eye-catching form-driven applications and spreadsheets. Since there is no option for creating a form; Mike Thomas will teach participants how to use a number of other built-in MS Excel features to create forms and then subsequently make them attractive with its design.

Mike will cover the following areas at this webinar:

o  Naming cells-to make formulas easier to understand

o  Drop-down menus and checkboxes-to make data entry easy

o  Data validation and protection-to reduce the risk of data-entry errors

o  Formatting-to make your forms inviting to use

o  Formulas and functions as VLOOKUP

o  Simple automation.

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.

Challenges to analyzing financial statements

Analysis of financial statements, or Financial Statement Analysis or FSA, as the discipline is called, is the application of one’s analytical ability into understanding the financial statements of a company. This analysis is made to get insights into how the company has been performing financially over a defined period of time. Based on this understanding, financial analysts make forecasts of how the company is expected to perform in the future, based on certain parameters.

Financial experts get down to understanding the way in which one of the company’s most vital ingredients, finance, is performing. FSAs are the most truthful indication of not just how the company has been performing, but also how its performance is going to lead the company in the future. Being an important tool in analyzing the financial health of the company; FSAs reflect the financial state of the company. These statements help the management decide on the company’s future decision-making relating to investment.

Viewed by many stakeholders

Financial statements are critical statements from a company. They are viewed and analyzed by a number of internal and external sources. While the company’s board of directors, management, and employees belong to the group of people who analyze FSA’s internally; customers, shareholders, banks, lending institutions, the general public and the government are some of the external analysts of FSAs.

Financial experts analyze FSAs in two important manners: Horizontal and Vertical. At their barest, horizontal analysis represents the history of the company’s financial performance over a varied period of time, while vertical analysis is made of a fixed period of time.

Types of Financial Statement Analysis 

Ratio analysis

Ratio analysis is one of the important techniques of Financial Statement Analysis. It is the analysis of how the company has performed in core areas of its business.

DuPont analysis

Another important analysis tool of Financial Statement Analysis is what is called DuPont analysis. It extends the ratio analysis method by taking note of the areas of strengths and weaknesses in the company’s financial statements. It breaks up the aspects of the company’s financial statements into the sources, such as equity, investments or others, from which the company is earning its revenues.

Challenges in Financial Statement Analysis

Financial Statement Analysis comes with its challenges. Financial Statement Analysis works in a vacuum. There is no theory or point of reference to which the Financial Statement Analysis is made. It is based purely on each situation, and is thus vulnerable to extreme volatility in the analysis. The fact that a company’s Financial Statement Analysis is positive in a certain situation under certain factors is no indication of how it would be in the future, in different situations. There are too many large variables involved in Financial Statement Analysis.

When a company is operating a number of businesses; it is difficult to evaluate the performance of each of the businesses, especially if the businesses are diverse. There are no fixed parameters to judge the performance of each of them.

Also, when accounting practices change; the whole character of Financial Statement Analysis undergoes a metamorphosis. This makes it necessary to completely redraw the practice of Financial Statement Analysis.

Financial Statement Analysis is not always accurate in analyzing the strengths or weaknesses of many of the company’s intangible resources.

Get to understand the ways in which Financial Statement Analysis works

A complete understanding of Financial Statement Analysis, with a clear definition of the challenges involved in this practice, will be given at a webinar that is being organized by Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance. At this webinar, Kevin Chenoweth, who has expertise in designing project plans for multi-million dollar Oracle R12 financial leading to under budget and on-schedule projects, will be the speaker.

To get insights into the challenges involved in Financial Statement Analysis; please enroll for this webinar by visiting Financial Statements & Valuation

Kevin Chenoweth will cover both the telecommunication and technology industries at this session, and will show how company operations can be improved. He will also offer recommendations on trend and ratio analysis as applicable to diversified industries. He will also help participants evaluate sales trends and develop ways to increase sales.

He will deconstruct financial statements and help identify key drivers of organic and inorganic growth. This session is of high value to those involved in Financial Statement Analysis, such as Accounting Staff, Finance Staff, IT Staff, Sales & Development Staff, Business Directors, Auditors, Company/Business Owners, and Finance Managers.

The following areas will be covered at this webinar:

o  DuPont Analysis

o  Cash to Cash Cycle

o  Real Options for Decision Making

o  Understanding organic and inorganic growth

o  Ratio and Trend Analysis

o  Quantitative and Qualitative Analysis.

The art of writing effective audit observations

Audits are a means of evaluating operations and other functions of an organization. ISO 19011:2011 Guidelines for Auditing Management Systems describes audits as a process used for gathering the evidence of verifiable documents and map their suitability, alignment and fulfilment with the company’s policies and procedures.

An audit is an important tool that helps organizations to analyze opportunities, implement best practices, and assess all the important factors in a business, such as risks, ethics, controls and quality. Conveying these to the management is the primary aim of an audit.

An audit is indispensable for mitigating risks and ensuring governance. An audit can be either:

o  Internal, where an organization’s employees in charge of audits in an organization in charge of audits carry out audits, or

o  External, where an external, independent auditing professional examines and evaluates the company’s functions objectively.

Each of these two types of audits is important. Either of these may be required, or both may be required, depending on the kind of business and practices an organization has.

Broadly, these are the types of audits:

Financial audits: Financial audits, as the name suggests, are related to how an organization keeps financial controls in place and report them to the authorities. Financial audits are summed up in financial statements, which spell out the extent to and the ways by which financial aspects of organizations tally.

Operational audits: These are the audit or assessment and evaluation of how an organization actually carries out its business. Being of this nature; operational audits are concerned primarily with business processes. The aim of operational audits is to suggest ways by which organizations can improve their operations to optimize their businesses and increase ROI.

Compliance audits: These are carried out to ensure the compliance with regulatory requirements in an organization. A number of these regulations need to be complied with depending on the nature and location of business.

Information Systems: Since no organization can stay aloof from automation and since information systems are required for almost all functions in an organization; it needs to systematically and thoroughly review its information systems from time to time. An effective information systems audit takes not only existing, but also emerging technologies into consideration and suggests ways by which to improve its network and firewall its data security.

Integrated Audits: Suggestive of its name; an integrated audit is one that assesses, monitors and controls all the kinds of audits –Financial, Operational, Compliance, and information systems risks. Auditing professionals locate these integrated audits on a business process or cycle or part of it.

Understanding and carrying out operational audits

Operational audits, being among the important kinds of audits, are governed by their own set of standards. They have their own set of standards that need to be complied with. These are set out by The Institute of Internal Auditors (IIA). And, like other types of audits, operational audits require a high degree of knowledge, diligence and skill.

The ways and means of carrying out operational audits can be complex and requires adherence to a number of standards and best practices. Auditors need to be thorough in their understanding of how to do these in an optimized fashion and ensure results for the organization.

Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will be providing this insight at a highly educative webinar. Jonnie T. Keith, who has over 40 years of audit experience and has served as the Chief Audit Executive for the Metropolitan Atlanta Rapid Transit Authority (MARTA) for the past 10 years, will be the speaker at this webinar.

To enroll for this session and to gain from the expertise Jonnie brings into auditing, please visit http://www.compliance4all.com/control/w_product/~product_id=501309LIVE?Linkedin-SEO

A complete roundup of operational audits and the ways of writing audit observations effectively

At this webinar, Jonnie will explain the intricacies of an operational audit. Jonnie will explain the importance and ways of writing these audit observations effectively and compellingly. He will explain the concept and all the important aspects that go into operational audits, such as management responsibilities and the key IIA standards that go into audits and the areas of their purview, such as the following:

2010 – Planning

2201 – Planning Considerations

2220 – Engagement Scope

2240 – Engagement Work Program

2300 – Performing the Engagement

2400 – Communicating Results

2500 – Monitoring Progress

http://asq.org/learn-about-quality/auditing/

https://finance.columbia.edu/content/types-audits

http://www.accountingtools.com/operational-audit

https://na.theiia.org/about-us/about-ia/Pages/About-the-Profession.aspx

Understanding the ways of conducting shrink investigations

Shrink investigation is essentially about examining the causes of shrink (loss) in retail businesses. Although retail is one of the fastest growing areas of business, the possibility of shrink is very high in this area. It is also an overlooked area, because of which many shrinks that could otherwise have been prevented, do not get prevented.

Controlling losses is as important as making profits. In fact, it even precedes profit making. A shrink investigation is a means to understanding where the losses lie and what causes them. This should help them to formulate policies and procedures that help them do this. Mapping audit practices to established procedures is important in helping to identify the source of loss. A shrink investigation is ideal for serving these purposes.

A major means for controlling retail losses

A shrink investigation is very important when one considers the fact that a third of all retailers suffer losses that are both unidentified and uncontrolled. Most retailers fail to realize that carrying out a shrink investigation requires a sense of direction and purpose, periodicity, prolificacy, and proactivity.

A webinar from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will help you expand your thinking and set you on new horizons of shrink investigation. This webinar will be presided over by the highly experienced and acclaimed expert on law enforcement, criminal investigation, loss prevention and fraud examination, John E. Grimes III.

To benefit from John’s wide-ranging and solid experience, register for this webinar by visiting http://www.compliance4all.com/control/w_product/~product_id=501274LIVE?Wordpress-SEO

In this session that personnel connected with the retail industry, such as Small Retail Business Owners, Managers, Auditors, Loss Prevention Professionals and Fraud Examiners will find very useful, John will impart a clear idea of all the elements of a shrink investigation.

Learning on all the aspects of shrink investigations

Attendance at this webinar will equip participants with a crystal clear understanding of the process needed for conducting a shrink investigation. These include covert observation of the store; a review of policies and procedures; a review of practices that are in contrast to established best practice procedures; a review of point of sale data including refunds and voids; taking frequent inventories; delivery audits; and paperwork review.

During the course of this 90-minute session, John will cover the following areas:

·        What causes Shrink (Losses) in a Retail Environment

·        The importance of having overarching Policies and workable Procedures to control shrink.

·        Understanding the steps to perform a Shrink Investigation when the source of losses is not identified through normal business operations procedures and practices. This webinar will discuss the steps, which include:

o  Covert observation

o  Undercover shoppers.

o  Review of policies and procedures

o  A review of point of sale data

o  Store meeting

o  Employee Interviews

o  Surprise Delivery Audits

o  Paperwork review

http://blog.lpinnovations.com/Loss-Prevention-Leadership/bid/76560/4-Key-Fundamentals-to-Positively-Impact-Your-Shrink-Loss

Procurement and Contract Fraud is usually off -the books- and difficult to detect and investigate

In this interconnected, interdependent global world, the need for contracting procurement of any goods or services is strong and indispensable. However, the benefits of this feature notwithstanding, there are several loopholes in the procurement and contracting activity. Outsourcing and contracting, by their very nature, are vulnerable to fraud. Fraud can happen at any stage of the procurement and contract process.

Common sources of procurement and contract frauds

A very common reason for procurement and contract frauds is when vendors and contractors collude with employees that are in charge of purchasing and administrating contracts. Another source of these procurement and contract frauds is the employee on whose request goods or services are purchased. Yet other procurement and contract frauds happen when solicited contractors work hand in glove with the bidding contractors. The Association of Certified Fraud Examiners (ACFE) estimates that as much as five percent of a business’ revenue is lost to procurement and contract frauds.

Since most of these procurement and contract frauds are based on off-the-books records, they go unnoticed for a good part, despite the fact that governments the world over have deployed scores of auditors and investigators with complete oversight of detecting and controlling procurement and contract frauds.

Plugging the loopholes

The many gaps in the contacting and procuring process need to be plugged if procurement and contract frauds have to be prevented. In addition, once these procurement and contract frauds happen, there need to be a few mechanisms to ensure that the procurement and contract frauds investigation is done thoroughly. Only this ensures that procurement and contract frauds do not go on to cause the kind of damage they normally do.

The first step to detecting, preventing and getting procurement and contract frauds right is to gain an understanding of the nature of the fraud. This understanding is the basis to gaining insights on how to deal with procurement and contract frauds. Many small and medium scale businesses suffer from procurement and contract frauds because are ill-equipped to deal with procurement and contract frauds, lacking as they do the knowledge needed to understand the nature of this activity.

A valuable learning session on procurement and contract frauds

A webinar from Compliance4All, a leading provider of professional trainings for all the areas of regulatory compliance, will impart lessons on how to understand deal with procurement and contract frauds. John E. Grimes III, who has over 45 years of law enforcement, criminal investigation, loss prevention, fraud examination experience, and teaching, will be the speaker at this session. In order to gain knowledge of the way in which the system of procurement and contract works and to understand how to prevent frauds, please register for this webinar by logging on to http://www.compliance4all.com/control/w_product/~product_id=501272LIVE?Wordpress-SEO Since the foundation to detecting and preventing procurement and contract frauds is a proper understanding of the various procurement and contract fraud hazards and schemes that are responsible for these frauds; John will start with giving offering knowledge of this aspect. He will explain which steps in the procurement chain procurement and contract frauds are most likely to occur.

Best practices for dealing with procurement and contract frauds

John will offer an understanding and awareness of the procurement fraud hazards that businesses or organizations that purchase materials are vulnerable to. He will also equip them with strategies that are aimed at detecting and preventing procurement and contract frauds, which will prevent them from sustaining huge losses. Also offered at this learning session is a set of proven best practices in investigative strategies that helps look into allegations of procurement and contract frauds.

At this highly valuable learning session on procurement and contract frauds, John will cover the following areas:

  • Basic Steps in the Procurement Process
  • Procurement Policies and Procedures
  • Conflict of Interest Policy
  • The various Procurement and Contract Fraud Hazards and what step in the procurement chain they occur.
  • Fraud Hazards in the Requirement Step
  • Conflict of Interest
  • Bribery, Kickbacks
  • Fraud Hazards in the Section Step
  • Bid Manipulation
  • Sole Source Awards
  • Fraud Hazards in the Post Award Step
  • Change Order Fraud
  • Phantom Employees and Equipment
  • Failure to meet Contract Specifications
  • Product Substitution
  • Fraud Hazards in the Payment Step
  • False, Inflated, or duplicate invoices
  • Three Cases Studies involving Conflict of Interest, Bribery, and Kickbacks.
  • Preventing and Detecting Procurement and Contract Fraud
  • Preliminary Steps
  • Pre-Award
  • Post Award
  • Conducting Procurement and Contract Fraud Investigations
  • Remedies

http://www.fraudconference.com/uploadedfiles/fraud_conference/content/course-materials/presentations/22nd/ppt/5a_paul_zikmund.pdf

https://www.cips.org/Documents/Knowledge/Chapter_12_Guile%20Procurement%20Fraud.pdf

http://www.acfe.com/topic.aspx?id=2722

What to expect during GMP Inspection

Regulatory agencies such as the FDA conduct inspections for product-related Good Manufacturing Practice (GMP) in the course of assessing an application for marketing approval. The basic purpose of product-related GMP inspections is to check for compliance with the GMP guidelines set out in the International Conference on Harmonization (ICH) and national and local GMP regulations. GMP is the slightest standard that a manufacturer has to mandatorily meet in its production processes. The aim of implementing GMP is to ensure that products

o  Are of consistently high quality

o  Are appropriate to their intended use, and

o  Meet the requirements of the marketing application or product specification.

Many factors trigger a product-related GMP inspection

The reasons for which these product-related GMP inspections can be triggered are quite similar to those that trigger an OSHA inspection. It can be due to any of these:

o  A whistleblower

o  In the course of inspecting other products in the facility

o  By regulatory agencies other than the one that is meant to carry out the inspection

o  When the regulatory agency comes to know of or suspects a breach.

Thorough preparation is the key to success at a product-related GMP inspection

There are several aspects to a product-related GMP inspection that needs to be borne in mind. They could happen simultaneously, or they may happen after an announcement to this effect.

Given the complexity of the nature of a product-related GMP inspection; it is essential to understand the intricacies of this exercise. A failure at a product-related GMP inspection is sure the cost the organization a lot in terms of money and effort.

It is because of the critical importance of success at a product-related GMP inspection that an organization needs to be thorough in its preparation for such an inspection. Organizations that go through product-related GMP inspections need to be ready for a product-related GMP inspection from a number of important perspectives.

Training on how to prepare for a product-related GMP inspection

This is the training a webinar from Compliance4All, a very well-known provider of professional trainings in all the areas of regulatory compliance, will be offering.

The speaker at this webinar is Peggy J. Berry, the President and CEO at Synergy Consulting, where she provides consulting services to companies in all aspects of drug development. Understanding how to be prepared for a product-related GMP inspection from Peggy is easy. All that is needed is to visit http://www.compliance4all.com/control/w_product/~product_id=501225LIVE?Linkedin-SEO to enroll.

The aim of this webinar from Compliance4All is to offer practical tips and advice for ensuring that all inspections are conducted in the most effective and efficient way possible. The core components of ensuring these include:

o  Ongoing readiness for inspections

o  Rehearsals and preparation for successful facility inspections, and

o  Knowing how to respond to findings by regulatory agencies.

Peggy will offer in-depth insights into these aspects of product-related GMP inspection.

Handling inspections can be a tough job

Regulatory agency inspections are not the easiest of people to handle and manage during a product-related GMP inspection. They can be very fussy and tough. Organizations that have no idea about how to manage product-related GMP inspections can have a difficult time with these inspectors, no matter from various regulatory agencies they hail.

At this webinar, Peggy will show what to expect during the product-related GMP inspection. She will also show the ways of successfully and efficiently streamlining and managing the inspection. She will also highlight the importance of adequate follow-up during and after the inspection.

During the course of this 90-minute session, which will be of tremendous use to professionals related to GMP, such as Design Engineers, and those in manufacturing, supply chain, technical operations, Quality Control, Quality Assurance and Regulatory Affairs, Peggy will cover the following areas:

o  Types of Inspections (for cause, pre-approval, periodic ) > API & FDF

o  Notification Timing

o  Foreign Facilities

o  What to expect during Inspection

o  Do a company audit as the FDA would (fall dress rehearsal)

o  Make adjustments as needed/address issues/take needed actions

o  Managing the Inspection

o  Inspection on follow-up.