CPE & Event Catalog
Finding Errors in Excel Spreadsheets WEBINAR
-
Your Desk
2.0 Credits
Understanding common excel errors. Advanced formulas and functions. Data validation techniques. Error tracing and auditing tools.
Get started with Power BI WEBINAR
-
Your Desk
2.0 Credits
Overview of the Power BI Tools. Tour of the Tools. Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
The Complete Guide to Washington Death Taxation WEBCAST Partnered with the Oregon Society of CPAs
-
Your Desk
8.0 Credits
Washington estate tax law overview. Step-by-step tax return preparation. Postmortem estate planning strategies. Federal estate tax alignment. Estate administration coordination. Probate considerations analysis. On-probate elements exploration. Valuation complexities unraveled. Joint tenancy challenges addressed.
Using ChatGPT with Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to ChatGPT and other AI language models. Discussion of best practices for using ChatGPT with Excel. Use ChatGPT to create, debug and explain formulas. Use ChatGPT to learn how to use Excel features. Use ChatGPT to automate repetitive tasks in Excel. Use ChatGPT to easily create macros.
Fiduciary Taxation Part 2: Fiduciary Accounting and Simple Trusts WEBCAST
-
Your Desk
2.0 Credits
Review the basic concept of fiduciary duty. Review the basic concept of fiduciary accounting. Use of a diagram to distinguish income and principal. Calculating fiduciary accounting income. Requirements of a simple trust. Problem example spreadsheets reflecting fiduciary accounting and taxation of simple trusts as well as how depreciation is handled by a fiduciary entity. Problem examples reflecting a completed form 1041 using spreadsheet calculations for fiduciary accounting and taxation of simple trusts.
You Don't Know What You Don't Know About Microsoft Excel WEBINAR
-
Your Desk
8.0 Credits
The 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.
Multistate Taxation - Issues and Planning Opportunities WEBCAST
-
Your Desk
8.0 Credits
Multistate business activities. Nexus and implications. State taxable income. Business-related issues. Formulas and their application. Audit defense strategies. State specific regulations. Choice of business entity. Interstate commerce clauses. Domicile in relation to state death taxation.
A Working Parent's Guide to Prioritizing Mental Wellness WEBINAR
-
Your Desk
2.0 Credits
Challenging cultural expectations and managing stress. Prioritizing self-care and physical well-being. Seeking support and building resilience.
Unlock the Power of AI with Copilot in Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to Copilot in Excel. Automating tasks and enhancing productivity. Advanced data insights with copilot.
K2's Excel Tips, Tricks, and Techniques for Accountants WEBCAST
-
Your Desk
2.0 Credits
Fundamental Excel techniques all accounting and financial professionals should know and use. Creating date-based calculations in Excel. How to create Excel templates. Key options you should enable in Excel. Linking data in Excel.
Advanced Excel for Staff - Build Reports and Analyze Data WEBINAR
-
Your Desk
2.0 Credits
Building reports workflow. Gather and organize data. Set calculations and key metrics. Format and structure reports. Review and validate data. Distributing the report effectively.
Get started with Power BI WEBINAR
-
Your Desk
2.0 Credits
Overview of the Power BI Tools. Tour of the Tools. Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs WEBCAST
-
Your Desk
2.0 Credits
Championing the role of innovation in the workplace. Crisis management. The roles we take on and differences between the roles we are assigned. Current and future trends and expectations for financial leaders and CFOs. Top ten crucial skills for 2035 from the Far Side's wisdom.
Using ChatGPT with Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to ChatGPT and other AI language models. Discussion of best practices for using ChatGPT with Excel. Use ChatGPT to create, debug and explain formulas. Use ChatGPT to learn how to use Excel features. Use ChatGPT to automate repetitive tasks in Excel. Use ChatGPT to easily create macros.
K2's Eight Awesome PivotTable Features WEBCAST
-
Your Desk
2.0 Credits
Adding user-defined calculations to PivotTables. Enhancing PivotTables with Key Performance Indicators. Using PivotTables to consolidate standard Excel reports. Creative ways to filter PivotTables. Linking accounting software data into PivotTables.
Becoming an AI-Savvy Controller/CFO: Mastering Tools and Technologies WEBCAST
-
Your Desk
4.0 Credits
Strategic finance leadership. Advanced financial analysis. Business intelligence and ai in finance. Economic intelligence for decision makers. Operational insight and business strategy. The future role of the controller or CFO.
Using ChatGPT with Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to ChatGPT and other AI language models. Discussion of best practices for using ChatGPT with Excel. Use ChatGPT to create, debug and explain formulas. Use ChatGPT to learn how to use Excel features. Use ChatGPT to automate repetitive tasks in Excel. Use ChatGPT to easily create macros.
Basic Staff Tax Training: Individual WEBCAST
-
Your Desk
8.0 Credits
Emphasize form 1040 and the accompanying reporting schedules for a basic individual income tax return. Identify and be able to implement basic individual income tax planning ideas for clients. Familiarity with several source documents utilized in the preparation of an individual income tax return. Identify common errors made in the preparation of an individual income tax return and understand how to avoid the errors in the future.
Complete Guide to Analyze Data with Excel PivotTables WEBINAR
-
Your Desk
4.0 Credits
Introduction to PivotTables. Creating and customizing PivotTables. Focus on using PivotTables to analyze data. Advanced PivotTable features. Data visualization with PivotCharts.
Practical Excel Topics for Today’s Accountant WEBCAST
-
Your Desk
2.0 Credits
Data validation. Underutilized, but powerful, formulas. Formulas for manipulating, transforming, and cleansing data. Formulas for data analysis. Reference formulas such as VLOOKUP. Pivot tables. Solver as a tool for performing multivariate analysis. Mail merge. Custom formatting.