June 23, 2025 – June 27, 2025
K2’s Embracing Excel, AI and Ethics: Multi State June 23-27
Lawrence A. “Mac” McClelland, Stephen Yoss
Accounting, Behavioral Ethics, Computer Software and Applications, Information Technology
Earn Up to 40 CPE Credits
Overview
Are you an accountant or financial professional looking to enhance your skills and stay up-to-date with the latest trends in the industry? Look no further than the “Embracing Excel, AI, and Ethics” Multi-State Virtual Conference! Led by experts Lawrence A. “Mac” McClelland and Stephen Yoss, this conference offers a comprehensive learning experience designed specifically for professionals like you. Explore topics like advanced Excel reporting, AI productivity tools, ethics in technology, QuickBooks best practices, and data analytics for accountants and auditors.
Session Details
Monday, June 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.
Tuesday, June 24, 2025
Day #2
K2’s Better Productivity Through Artificial Intelligence And Automation Tools
Session Description
Artificial Intelligence (AI) and automation tools offer incredible opportunities for all business professionals to improve productivity and accuracy. For example, generative AI tools such as ChatGPT and Bard can be beneficial when conducting research or drafting reports and correspondence. Likewise, Microsoft’s Power Automate platform and similar tools such as Zapier can help you elevate efficiency to levels you may have thought unattainable. If this sounds appealing, plan to participate in this session to modernize your workflows and take advantage of these tools.
This session will teach you practical applications of today’s AI and automation tools. Moving beyond fundamental discussions, you will learn how to use AI and automation to streamline workflows, improve internal control, maximize productivity, and even improve team member morale. In addition, you will learn about some potential pitfalls associated with these technologies and how to avoid making mistakes when using these tools. In sum, this session is “must-see CPE,” and you should plan to participate in this class today.
K2’s Ethics and Technology
Session Description
With the explosion of technology over the past thirty years, one fair question is, “what are the ethical considerations and impacts related to this technology?” Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few.
This course will teach you about “technoethics” and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session you will ever attend.
Wednesday, June 25, 2025
Day #3
K2’s QuickBooks for Accountants
Session Description
The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.
Thursday, June 26, 2025
Day #4
K2’s Data Analytics For Accountants And Auditors
Session Description
In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time.
In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you’re seeking to improve your skills in the field of data analytics, this session is the one for you!
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.
Friday, June 27, 2025
Day #5
K2’s Technology for CPAs – Don’t Get Left Behind
Session Description
How good are you with the technology you use daily? Are new technology tools available to save time and make you more effective? Technology continues to accelerate rapidly, and keeping pace is essential. This course is for you if you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively!
In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 11), peripheral devices, and what they mean for you. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, best practices for working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment.
Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. So register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.