K2's Excel Conference - VIRTUAL
8.00 Credits
Member Price $250
Non-Member Price $350
Overview
This conference is offered in collaboration with the K2 Enterprises.
Excel is an indispensable tool for accounting and financial professionals, yet many still aren't using it to its full potential. That's where the Summer Excel Conference comes in. Join this exclusive, one-day virtual seminar designed to elevate your Excel skills and transform how you work. Catering specifically to accountants, CPAs, and financial professionals, this dynamic conference will teach you to leverage Excel’s powerful features and adopt best practices that maximize efficiency, improve security, and boost productivity.
Highlights
Prerequisites
None
Designed For
Any business professional seeking to use Excel efficiently and effectively
Objectives
Preparation
Fundamental understanding of computer operations
Notice
Monday, June 1
General Session
- Formatting Excel Spreadsheets And Automation Opportunities For Increasing Personal Efficiency And Effectiveness
Brian Tankersley, Brian Tankersley is a consultant who, K2 EnterprisesBrian Tankersley
Brian F. Tankersley, CPA, CITP, CGMA, is the Technology Editor for The CPA Practice Advisor magazine. He has over 30 years of professional experience, including accounting, auditing, technology, and education, including 20 years as a CPE discussion leader. He teaches courses nationally through K2 Enterprises since 2005 and currently works with Yaeger CPA Review. Tankersley is a Certified Information Technology Professional, a Chartered Global Management Accountant and makes his home in Farragut, Tenn.
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: 2 - Computer Software & Applications
This session is available to registrants only.
General Session
- K2's Connect, Transform, and Analyze Data Like a Pro with Power Query
Stephen Yoss Jr., Stephen M. Yoss, Jr., CPA, MS is a ce, K2 EnterprisesStephen Yoss Jr.
Stephen M. Yoss, Jr., CPA, is the partner, and principal of Devmatics, LLC, a software development company that focuses on solving problems through the implementation of technology. Stephen has consulted with several companies on how to lower overhead, personnel and compliance costs by investing in technology and reengineering their business practices. He teaches his clients to embrace technology at every opportunity in order to increase efficiency and productivity.
Stephen began working with technology at age ten, and started his first IT company at age 13, designing web applications for local businesses. He has presented to thousands of practitioners nationwide on topics such as cloud computing, mobile technology, spreadsheet design and best practices, information security, identity theft prevention and many more.
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: 2 - Specialized Knowledge
This session is available to registrants only.
General Session
- K2's Excel PivotTables for Accountants
Thomas Stephens, K2 EnterprisesThomas Stephens
Thomas G. (Tommy) Stephens Jr., CPA, CITP, CGMA, 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.
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: 1 - Computer Software & Applications
Credits: 1 - Accounting
This session is available to registrants only.
General Session
- K2's Excel Charting and Visualizations
Mac McClelland, Mac McClelland, an attorney and accou, K2 EnterprisesMac McClelland
Mac McClelland, MBA, JD, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, La., and Network Management Group of Hutchinson, Kan. 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. MCClelland has been published in leading business and practitioner journals, including Computers in Accounting, Journal of Accounting Education, and the top rated Journal of Accounting Research.
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: 2 - Computer Software & Applications
This session is available to registrants only.
Non-Member Price $350
Member Price $250