Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take 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 session you will be able to...
- Distinguish key internal control concepts, including the four types of internal control: preventive, detective, deterrent and compensating
- Identify ways to create strong internal controls
- Identify reasons that control measures are required, such as to deter fraud or reduce operational inefficiencies
- Determine why the control environment is important as implementation efforts are ongoing
- Apply COSO Framework concepts to three segments of an organization's technology infrastructure that must be controlled.
Major Topics
The major topics covered in this course include:
- The power of keyboard shortcuts
- Oft used features with more capability than meets the eye
- New helpful features
Note: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
