CPE & Event Catalog
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 Expense Reporting Automation WEBCAST
-
Your Desk
2.0 Credits
Overview of selected expense and corporate credit card reporting and management platforms. Major fraud schemes associated with expense reporting. Extracting and importing transaction data from bank feeds and matching to receipts.
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.
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.
You Don't Know What You Don't Know About Microsoft Excel WEBINAR
-
Your Desk
8.0 Credits
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.
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.
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.
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 What does it mean? What is our role? 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
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 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.
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.
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 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.
Making Excel Formulas Work for You WEBCAST
-
Your Desk
4.0 Credits
Understanding formula conventions. Working with functions. Examples of powerful Excel formulas.
K2's Advanced QuickBooks Tips And Techniques WEBCAST
-
Your Desk
4.0 Credits
Tips for improving efficiency with QuickBooks and QuickBooks Online. Better reporting when working in QuickBooks environments. Tips for cleaning up QuickBooks and QuickBooks Online instances. Managing inventory more effectively when working with QuickBooks and QuickBooks Online.
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.
K2's CPA Firm Update WEBCAST
-
Your Desk
2.0 Credits
Emerging trends like changes in client expectations, supplier strategies, and competitive dynamics. AI and advanced software innovations with tailored solutions for service lines like tax, audit, advisory, and niche industries. Next-gen automation tools, including the role of machine learning, RPA, and advanced analytics in streamlining operations. Optimal technology stacks to enhance firm productivity, efficiency, and profitability. Cybersecurity advancements. Proactive approaches to safeguarding client and firm data.
You Don't Know What You Don't Know About Microsoft Excel WEBINAR
-
Your Desk
8.0 Credits
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.
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.
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.