Excel Data Management ON DEMAND
Available Until
Your Desk
1.0 Credits
Member Price $29.00
Non-Member Price $33.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. After taking this course, you will be able to generate 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
None.
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 $33.00
Member Price $29.00