Self-Study
Introduction to Excel
Learn Excel fundamentals. Set up worksheets, learn formatting, produce organized outputs, and more.
$87.00 – $107.00
Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.
Without FlexCast, you must start with enough time to finish. (1 Hr/Credit)
Please fill out the form below and we will reach out as soon as possible.
CPE Credits
3 Credits: Computer Software & Applications
Course Level
Overview
Format
Self-Study
Course Description
Excel is one of the primary tools of the accountant. It is needed for many accounting activities, such as tracking the contents of accounts and conducting financial analyses. However, Excel is a massive program with hundreds of commands and quirky formatting options. In Introduction to Excel, we cover the basics of setting up and populating an Excel worksheet, as well as producing well-organized outputs. Topics covered include the menu system, formatting, named styles, templates, and a variety of printing options.
Learning Objectives
Upon successful completion of this course, participants will be able to:
- Explain how the ribbon system works.
- Describe cells and ranges.
- Identify how keystrokes can replace the mouse to trigger menu commands.
- Specify where high-volume commands are located on the screen.
- Describe the different uses of a table within a worksheet.
- Explain the differences between the Autocomplete and Autofill functions.
- Describe how cell and range formatting can be accomplished.
- Identify the warnings used when column widths are too narrow.
- Specify the more common Ctrl-letter combinations used to trigger worksheet commands.
- Identify the different variations on the Paste command.
- Explain how range naming works within a worksheet.
- Describe the uses to which the undo function can (and cannot) be put.
- Specify how named styles and themes are used.
Course Specifics
SS224382968
May 3, 2024
There are no prerequisites.
None
107
Compliance Information
CFP Notice: Not all courses that qualify for CFP® credit are registered by Western CPE. If a course does not have a CFP registration number in the compliance section, the continuing education will need to be individually reported with the CFP Board. For more information on the reporting process, required documentation, processing fee, etc., contact the CFP Board. CFP Professionals must take each course in it’s entirety, the CFP Board DOES NOT accept partial credits for courses.
Meet The Experts
Steven M. Bragg, CPA, is a full-time book and course author who has written more than 300 business books and courses. 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 …
Related Courses
-
Computer Software & Applications
Drive Your Dashboard with Excel
Patricia McCarthy, MBAQAS Self-StudyCredits: 6 $174.00$174.00 – $204.00
-
Computer Software & Applications
Excel Worksheets: Best Practices
Joseph Helstrom, CPAQAS Self-StudyCredits: 2 $58.00$58.00 – $78.00
-
Computer Software & Applications
Use Pivot Tables to Organize, Summarize, and Analyze Data
Patricia McCarthy, MBAQAS Self-StudyCredits: 5 $145.00$145.00 – $175.00