K2's Summer Excel Conference - VIRTUAL

4 selected sessions
Online- K2 Enterprises
8.00 credits
Member price: $424
Non-member price: $524
(discounts available)
Members save $100.00.
You aren't a member... yet.
OVERVIEW

Excel remains the most critical tool in any accounting professional's arsenal—but the platform keeps evolving, and most practitioners aren't tapping into even half of what's now possible. This specialized conference cuts through the noise to focus exclusively on Microsoft Excel's latest capabilities that matter most to your daily workflow. From dynamic arrays and LAMBDA functions to Power Query automation and modern data manipulation tools, you'll discover features that can genuinely transform how you work. These aren't theoretical exercises—they're real-world techniques you can implement immediately to handle larger datasets, reduce errors, and reclaim hours every week.

Whether you're still relying on methods from five years ago or you're already pushing Excel's boundaries, these sessions will equip you with practical skills that make an immediate difference. With two opportunities to attend in 2026, you can choose the timing that works best or revisit the material as Excel continues its rapid evolution. Don't let your Excel knowledge stagnate while the platform races ahead.


DESIGNED FOR

  • Business professionals desiring to improve personal and team efficiency and effectiveness
  • Business professionals seeking to elevate productivity and internal controls by taking advantage of Power BI, Power Query, Power Pivot, and Power Automate.
  • Business professionals seeking to elevate productivity and internal controls by taking advantage of Power


OBJECTIVES
  • Apply advanced Excel functions and features released in recent updates to streamline common accounting tasks and improve accuracy in financial analysis
  • Implement Power Query and modern data manipulation techniques to automate repetitive processes and handle increasingly complex datasets
  • Utilize PivotTables and dynamic array functions to create more flexible, maintainable reports that adapt to changing business requirements
  • Recognize overlooked built-in tools and shortcuts that can significantly reduce time spent on routine Excel operations
  • Build more efficient workflows using contemporary Excel capabilities designed specifically for data-intensive professional environments

HIGHLIGHTS
  • Excel Blocking and Tackling – Often Overlooked Tools
  • Advanced Excel Functions and Latest Features
  • Power Query and Other Data Manipulation Tools
  • PivotTables – Excel's Best Feature Is Now Even Better
  • Modern Dynamic Arrays and Formula Techniques
  • Workflow Optimization Strategies for Financial Professionals

ADVANCED PREP

None, but working knowledge of Excel will be helpful.


DISCOUNTS
Early Registration Discount:
$50
(expires: May 18, 2026)
CREDITS
Accounting
1.00 credits
Computer Software & Applications
5.00 credits
Specialized Knowledge and Applications
2.00 credits
FIELDS OF STUDY
Accounting & Auditing
Computer Software & Applications
Specialized Knowledge
LEVEL
Intermediate
Members save $100.00.
You aren't a member... yet.

McClelland, Mac

 
Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas. Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting. He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence. Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Stephens, Tommy

 
Tommy Stephens received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. In 1992, he earned a Master of Science degree (Major in Finance) from Georgia State University in Atlanta. Presently, Tommy is a Certified Public Accountant, a Certified Information Technology Professional, and a Chartered Global Management Accountant. During his professional career, Tommy has gained valuable experience in a variety of positions, including: • Working as an auditor and technology consultant for an Atlanta-based public accounting firm; • Leading an Internal Audit staff and managing a Cost Accounting team for a Fortune 500 company; • Serving as a Chief Financial Officer for an international engineering organization; and • Founding and managing his public accounting firm that provides accounting, tax, and consulting services to individuals and a variety of small and emerging businesses. In 1995, Tommy began authoring and presenting continuing professional education courses to accounting and finance professionals. In 2003, he affiliated with K2 Enterprises, and in 2007, he joined the firm as a partner. Over the past twenty-seven years, Tommy has presented over 2,800 educational sessions to over 71,000 participants throughout the United States and Canada. Tommy maintains professional memberships with the American Institute of Certified Public Accountants and the Georgia Society of Certified Public Accountants. Additionally, he is a past member of the Institute of Internal Auditors.

Tankersley, Brian

 
Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, writes for multiple accounting media outlets, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). Mr. Tankersley has over 30 years of professional experience, including accounting, auditing, technology, and education, has been with K2 Enterprises since 2005. Tankersley has been recognized eight times as one of the "Top 25 Thought Leaders in Public Accounting Technology" by Cygnus Business Media. Brian has made presentations in 48 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He has received numerous awards for his writing and speaking from state CPA societies. Brian has presented sessions at most major national accounting technology conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group's Solutions Conference, Sage Summit, CCH Connections, and Thomson Reuters Synergy User Conference. Brian is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). He holds bachelor's degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Tankersley also maintains numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs. Brian and his family make their home in Farragut, Tennessee.

Yoss, Steve

 
Stephen M. Yoss, Jr., CPA, MS is a certified public accountant, the partner, and principal of Devmatics, LLC, a continuing education instructor for financial professionals, and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions. At age 10, Stephen began working with technology; he started his first IT company at just 13, which focused on designing web applications for local businesses. At 15, he began writing original computer code and has been designing and implementing technological solutions continuously since then. Stephen is a graduate of Loyola Marymount University, with degrees in Accountancy and International Business. While at Loyola, he served the campus as student body president and as the student representative to the Board of Trustees. He has a Master's of Science degree in Information Systems and Technology from Claremont Graduate University with a concentration in Geographic Information Systems. In 2017, Stephen formed Devmatics, a software development company that focuses on solving problems through the implementation of technology. Devmatics builds custom software, mobile apps, integration solutions, workflow automation, and more for all types of organizations. He specializes in taking on high-difficulty, mission-critical organizational issues that require technical expertise and an ability to find solutions to problems that no one else can answer. With all of his clients, he emphasizes the need to embrace technology at every opportunity and utilize the latest technological trends and breakthroughs to gain a competitive advantage while increasing efficiency and productivity. Before starting Devmatics, Stephen worked as an accountant in his family's practice, Yoss & Allen. At Yoss & Allen, he completely redesigned the firm's technology practices and instituted a technological infrastructure to streamline the firm's practices and allow them strategic flexibility. Many of the technologies, strategies, and concepts that Stephen uses himself (and consults companies on how to use) were designed, perfected, and implemented to help his family's business and their clients. In addition to his time with Yoss & Allen, Stephen worked in New Zealand as a management accountant. Since 2009, Stephen has also been teaching continuing professional education, providing written, webcast, in-house, and live instruction. He has presented to thousands of practitioners worldwide on topics such as cloud computing, mobile technology, Excel tips and best practices, data modeling and analysis, big data, information security, identity theft prevention, and more. Stephen is also a professionally licensed pyrotechnician and works on major fireworks displays throughout the nation for Pyro Spectaculars, North America's largest full-service fireworks display production company. He's proud to have helped produce incredible displays, including the Macy's July 4th Spectacular in New York City, the 75th Anniversary of the Golden Gate Bridge in San Francisco, KGB Skyshow in San Diego, and many more. Whether it's teaching in the classroom, consulting clients in a boardroom, or shooting a fireworks display, Stephen brings passion, hard work, value—and above all else—technological expertise to each of his clients. With an open, honest approach, he creates a unique strategy for each client specifically
Members save $100.00.
You aren't a member... yet.

06-01-2026

001-Formatting Excel Spreadsheets And Automation Opportunities For Increasing Personal Efficiency And Effectiveness

Start: 9:30AM

End:  11:10AM

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. Further, automation is a great way to save time, improve accuracy and effectiveness, and get more value from your workday. In this session, you will learn how to automate mundane tasks that take up too much energy so you can complete them automatically instead. One of the best things a person can do is invest time into automating their workday to help them achieve more work, reduce daily stress, and provide better mental clarity. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel. Further, Automation options abound, and in this session, you will learn how to take advantage of many personal automation tools and services. You will learn about various automation platforms, creating automation workflows, and automation tools to become more efficient.
CREDITS
Specialized Knowledge and Applications
2.00 credits

002-K2's Connect, Transform, and Analyze Data Like a Pro with Power Query

Start: 11:20AM

End:  1:00PM

In today’s data-driven environment, financial professionals are expected not only to analyze numbers but to transform them into actionable insights. This course offers a deep dive into the practical applications of Power Query in both Excel and Power BI, tailored for those who already have a foothold in financial data analysis. Participants will learn how to streamline their data preparation process, saving time and reducing errors by automating the tedious tasks of connecting to various data sources, combining datasets, and cleaning up data for more efficient analysis. As the backbone of any insightful report or dashboard, clean and well-structured data is a must. This course goes beyond the basics, equipping attendees with the skills to create custom columns and perform advanced data transformations that lead to more meaningful financial reports. By the end of the sessions, participants will not only have sharpened their analytical capabilities but will also carry the confidence to tackle complex data challenges with ease. Don’t miss the opportunity to refine your data skills and bring new levels of proficiency to your financial analysis.
CREDITS
Specialized Knowledge and Applications
2.00 credits

003-K2's Excel PivotTables for Accountants

Start: 1:30PM

End:  3:10PM

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables – including grouping options for fiscal periods – and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
CREDITS
Accounting
1.00 credits

004-K2's Excel Charting and Visualizations

Start: 3:20PM

End:  5:00PM

Are you tired of struggling to create compelling charts and graphs? Join our session and transform your data into stunning visualizations that captivate and inform your audience. This isn't just another seminar on basic charts; it's a comprehensive guide to mastering advanced, interactive, and dynamic visualizations in Excel. In this session, you'll learn how to create visually appealing charts that are not only informative but also engaging. Discover the secrets to making your data come alive with interactive elements that ensure your audience understands and retains the information you present. Whether you're looking to enhance your communication skills or impress your stakeholders, this seminar is a must-attend. Don't miss out on the opportunity to take your Excel skills to the next level. Sign up now and start creating visualizations that make a lasting impact!
CREDITS
Computer Software & Applications
2.00 credits
Members save $100.00.
You aren't a member... yet.
Scroll to Top