September 23, 2025 – September 25, 2025
K2’s Excel and Beyond: Multi State September 23-25
Stephen Yoss
Accounting, Auditing, Computer Software and Applications, Information Technology
Earn Up to 24 CPE Credits
Overview
No Description Provided
Session Details
Tuesday, September 23, 2025
Day #1
K2’s Next Generation Excel Reporting
Session Description
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments.
In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
Wednesday, September 24, 2025
Day #2
K2’s Mastering Advanced Excel Functions
Session Description
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels.
In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function’s power, and create more accurate forecasts with Excel’s FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
K2’s Implementing Internal Controls in QuickBooks Environments
Session Description
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions.
In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.
Thursday, September 25, 2025
Day #3
K2’s Improving Productivity with Microsoft 365/Office 365 Cloud Applications
Session Description
Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features.
Plan to attend this session to learn about the “rest of 365” and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don’t miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.
K2’s Working Remotely – The New Normal
Session Description
Many team members now work remotely, whether by choice or necessity. As a result, questions abound about remote access to desktops and data, security, communications, collaboration, and other considerations in this new normal. When implemented correctly, remote work strategies can be a “win-win” for all involved; however, failed implementations may lead to inefficiencies, security issues, and dissatisfied team members.
This session will teach you today’s best practices for working remotely. Specifically, you will learn about various remote access tools, communication and collaboration options, and security best practices. You will also learn about managing and monitoring workflows in remote work environments and tools you can use. After completing this session, you can implement a remote work strategy that yields efficiency, security, and satisfaction to all involved.