CPE & Event Catalog
Shortcuts that Excel Users Love WEBCAST
-
Your Desk
2.0 Credits
The power of keyboard shortcuts. Often used features with more capability than meets the eye. New helpful features.
Advanced Excel Topics for Spreadsheet Power Users WEBCAST
-
Your Desk
8.0 Credits
Using Excel for graphical output and dashboard reporting. Data tools and the Data Analysis ToolPak. Advanced functions and complex formulas. Working with Excel tables and PivotTables.
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.
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.
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 Advanced Excel WEBCAST
-
Your Desk
8.0 Credits
Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.
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.
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
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.
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.
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.
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.
Advanced Excel Formulas And Functions FLEXCAST
Available Until
Your Desk
2.0 Credits
New functions in Excel such as TEXTJOIN, IFS, and SWITCH. Working with CUBE functions and Data Models. Extracting data from PivotTables with the GETPIVOTDATA function. Summarizing data with the SUBTOTAL and AGGREGATE functions. Creating reports using EOMONTH, INDIRECT, and SUMIFS. Working with Excel's primary date-oriented functions.
Advanced QuickBooks Tips and Techniques FLEXCAST
Available Until
Your Desk
4.0 Credits
Exchanging and working with QuickBooks data. Advanced reporting issues. Managing inventory with QuickBooks.
Excel Charting and Visualization FLEXCAST
Available Until
Your Desk
4.0 Credits
Fundamentals of effective visualizations. Creating visualizations in excel. Beyond the basics for more effective visualizations and communication.
Excel Macros ON DEMAND
Available Until
Your Desk
2.0 Credits
Macro recorder. Visual basic editor. Quick access toolbar.
Excel Power User Module 10: Getting, Preparing and Summarizing Data ON DEMAND
Available Until
Your Desk
2.0 Credits
External data. Text files. Data preparation. Accounting system data. Getting graphics.
Excel Power User Module 1: Fundamental Features ON DEMAND
Available Until
Your Desk
2.0 Credits
Selected shortcuts. Named references tables. Data validation. Conditional formatting basics.
Excel Power User Module 2: Fundamental Functions, Concepts, Techniques ON DEMAND
Available Until
Your Desk
2.0 Credits
Better summing. Skinny row. Hide worksheets. Highlight input cells. Workbook organization. Worksheet organization. Nested functions. Selection groups. Workbook design principles.
Excel Power User Module 3: Six Critical Excel Functions ON DEMAND
Available Until
Your Desk
2.0 Credits
Conditional summing basics with SUMIFS. Remove duplicates. Lookup basics. Improving VLOOKUP with MATCH. Improving VLOOKUP with VALUE and TEXT. Moving beyond VLOOKUP with INDEX.