CPE & Event Catalog
K2'S Artificial Intelligence For Accounting And Financial Professionals WEBCAST
-
Your Desk
4.5 Credits
Exploring AI applications in accounting and finance. Understanding AI features in everyday tools. Embracing the future: AI's impact on finance and accounting.
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.
Excelling at Excel: The Magic of Power Query WEBCAST
-
Your Desk
2.0 Credits
Intro to Power Query and how to get started. Examples of data clean up using Power Query. Combining workbooks and files with Power Query.
Fiduciary Taxation Part 2: Fiduciary Accounting & Simple Trusts WEBCAST
-
Your Desk
2.0 Credits
Review the basic concepts of fiduciary duty. Review the basic concepts 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.
Excelling at Excel: Tips, Tricks and Updates WEBCAST
-
Your Desk
2.0 Credits
Excel version differences and compatibility. Customize Excel so it works the way you work. Learn new shortcuts to work quicker. Learn some of the newer formulas to streamline your spreadsheets. Take on tables & a powerful tool for data analysis.
K2's Excel Tips, Tricks, and Techniques for Accountants WEBCAST
-
Your Desk
8.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.
Excel Essentials for Today's Accountant: How To Become an Expert in One Day WEBCAST
-
Your Desk
4.0 Credits
Using formulas to manipulate and transform data. Using formulas and reference formulas. Using pivot tables. Understanding Solver to perform multivariate analysis. Awareness of advanced functions. Creative methods for data manipulation. Using intellectual curiosity and professional skepticism to develop a problem-solving mentality. Real-life examples of innovative ways to analyze and report data with Excel. Using Excel to perform e-mail merges. Enhance creativity in your approach to developing Excel models Computer software and application.
K2's Harnessing ChatGPT - Unlocking Professional Efficiency WEBCAST
-
Your Desk
1.0 Credits
Leveraging prompt engineering in ChatGPT for various accounting tasks. Exploring the applications and limitations of ChatGPT in accounting. Empowering efficiency for everyday accounting tasks.
Excel Tips & Tricks for the Non-Accountant WEBCAST
-
Your Desk
2.0 Credits
Understanding the workbook and worksheet environment. Obtaining and utilizing data. Editing and formatting. The Insert Menu. The Page Layout Menu. The View Menu. Selecting and using formulas. Shortcuts and tricks.
Shortcuts that Excel Users Love WEBINAR
-
Your Desk
2.0 Credits
The power of keyboard shortcuts. Oft used features with more capability than meets the eye. New helpful features.
K2's Business Intelligence, Featuring Microsoft's Power BI Tools WEBCAST
-
Your Desk
8.0 Credits
The importance of Business Intelligence in today's business climate. Differentiating between Power BI licensing options. A hands-on approach to creating effective Power BI reports and dashboards.
Digging Deep with Excel Pivot Tables WEBCAST
-
Your Desk
1.0 Credits
Data preparation and cleansing. Pivot table creation. Pivot table customization. Navigating Excel's PivotTable Analyze tab.
Dashboard and Report Design Principles Using Excel WEBCAST
-
Your Desk
4.0 Credits
Principles of visual design for dashboards and reports. Chart design for rapid understanding. Table design for efficiency. Effective use of commentary. Strategic layout techniques. Trend analysis methods. Developing organizational design standards. Excel application techniques. Critical review skills. Best practices for data presentation.
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.
Excel Tips & Tricks for the Non-Accountant WEBCAST
-
Your Desk
2.0 Credits
Understanding the workbook and worksheet environment. Obtaining and utilizing data. Editing and formatting. The Insert Menu. The Page Layout Menu. The View Menu. Selecting and using formulas. Shortcuts and tricks.
PowerPoint: Tips & Tricks for Today's Accountant WEBCAST
-
Your Desk
2.0 Credits
Exploration of tabs within PowerPoint's ribbon. Initial creation of a slide deck. Using slide masters. Utilization of external content. SmartArt. Alignments and layouts. Tips and tricks for efficiency. Best practices for effective presentation delivery. Other creative uses for PowerPoint.
K2's Advanced Excel WEBCAST
-
Your Desk
8.0 Credits
Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.
K2'S Artificial Intelligence For Accounting And Financial Professionals WEBCAST
-
Your Desk
4.5 Credits
Exploring AI applications in accounting and finance. Understanding AI features in everyday tools. Embracing the future: AI's impact on finance and accounting.
K2's Data Analytics for Accountants and Auditors WEBCAST
-
Your Desk
4.0 Credits
Understanding the importance of data analytics in modern business environments. Generating and interpreting data analytics using everyday applications such as Microsoft Office Excel and Microsoft's Power BI platform. Using regression analysis to create and validate forecasts and projections.
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.