A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Learning Objectives
After attending this presentation, you will be able to...
- Understand the many keyboard shortcuts that are available to save time and effort
- Use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
- Design custom number and date formats to meet their specific needs
- Add security to the workbooks they use. This includes workbook encryption, and the use of sheet level, range level and cell level security features
- Understand formula building conventions such as order of operation
- Troubleshoot formulas that are not working properly
- Work with functions in the function library to create powerful formulas
Major Topics
The major topics covered in this course include:
- Fraudulent acts initiated from outside organizations
- Why internal fraud occurs
- The importance of fighting cyber-fraud
- Steps that verify anti-fraud activities are working
