You Don’t Know What You Don’t Know About Excel

Overview

This course provides a foundational understanding of employee benefit plans subject to audit under ERISA, helping you prepare to navigate the complexities of 401(k) plans. Explore the basics of ERISA This course offers a thorough understanding of 401(k) plans within the context of the Employee Retirement Income Security Act (ERISA). Your journey starts with an examination of the core objectives and effects of ERISA on 401(k) plans. Unveil the essentials of 401(k) plans Investigate the primary features of 401(k) plans, including eligibility rules, vesting schedules, and definitions of compensation. Learn to recognize the crucial roles and responsibilities of various stakeholders who ensure plan integrity and protect participant interests. Immerse yourself in compliance, contributions, and financial mechanics Understand the importance of the plan document and ERISA compliance, and delve into tax considerations and compliance duties pertinent to the auditor. You’ll gain insights into the workings of plan assets, such as contributions, loans, and the variety of investment options within 401(k) plans. Comprehend the complexities of distributions, plan expenses, and fee structures. Navigate the intricacies of 401(k) plans with assurance Grasp the unique financial reporting matters related to 401(k) plans, including Form 5500 and its connection to plan financial statements. Recognize the significance of SOC 1 reports in proving compliance and operational integrity, and understand how ERISA Section 103(a)(3)(C) audits differ from traditional audits. This program is provided through our partnership with the AICPA. After completing this course, you’ll receive a certificate and digital badge to showcase your new knowledge in this crucial area.

Highlights

• Excel shortcuts and time savers
• Working with templates, formats, styles and themes
• Customizing and enhancing Excel
• Protecting and securing workbooks
• Formula building and the Excel function library

Prerequisites

None.

Objectives

• Recognize the many keyboard shortcuts that are available to save time and effort
• Indicate how one would use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
• Indicate how a user can design custom number and date formats to meet their specific needs
• Recognize ways to add security to the workbooks, including workbook encryption and the use of sheet-level, range level and cell-level security features
• Recognize formula-building conventions such as order of operation
• Recall how to troubleshoot formulas that are not working properly
• Recall how to work with functions in the Excel function library to create powerful formulas

Preparation

None.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.