Excel Data Management FLEXCAST
Available Until
Your Desk
1.0 Credits
Member Price $98.00
Non-Member Price $113.00
Overview
A central concern when using Excel is whether the data being used is sufficiently clean and well-organized to be useful for further analysis. In this course, we cover the importing of data from other sources, cleaning it, validating data at the point of data entry, protecting it from unauthorized changes, and organizing it properly. The outcome is much more reliable data, which improves the quality of any subsequent analyses conducted on the data.
Highlights
The worksheet ribbon. Importing and cleaning data. Validating data. Worksheet outlines. Lining worksheets. Protecting data.
Prerequisites
None.
Designed For
CPAs, CEOs, CFPs, and other accounting professionals
Objectives
Explain the characteristics of the ribbon system. Describe the different types of files that can be imported into Excel, and their characteristics. Identify the different types of commands that can be used to clean up data and extract data from a data set. Specify the function keys that can be used to clean up data within a worksheet. Identify the characteristics of a worksheet outline and how it can be used.
Preparation
None.
Notice
This is a FlexCast (no exam required) and may be viewed only Monday - Saturday, 5am - 5pm PT. You may take up to one year from the date of purchase to complete the course. Pause your FlexCast and resume at a convenient day during the hours above. Partial credit for 2+ credit courses: If you are unable to complete the course in one sitting, partial credit can be awarded (minimum of one credit). To earn the remaining credits, you must return later and start the course from the beginning. Use chat to ask questions of a subject matter expert during the program.
Leader(s):
Leader Bios
Steven Bragg, Western CPE
Steven M. Bragg, CPA, is a full-time book and course author who has written more than 70 business books. He provides Western CPE with self-study courses in the areas of accounting and finance, with an emphasis on the practical application of accounting standards and management techniques. A sampling of his courses include the The New Controller Guidebook, The GAAP Guidebook, Accountants’ Guidebook, and Closing the Books: An Accountant’s Guide. He also manages the Accounting Best Practices podcast.
Steven has been the CFO or controller of both public and private companies and has been a consulting manager with Ernst & Young and an auditor with Deloitte & Touche. He holds an MBA from Babson College, a Master of Finance from Bentley College, and a BA from the University of Maine (summa cum laude).
Non-Member Price $113.00
Member Price $98.00