Skip to main content

CPE & Event Calendar

For details about the CPE and event categories below, please click here.

Showing 200 Seminars Results

Required Minimum Distributions: Compliance and Planning

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1137509. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.

Reviewing Individual Tax Returns: What Are You Missing?

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-3441.  To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. These provisions combined with the potential for input error when utilizing the array of income tax software available, create the potential for a multitude of errors that can occur when preparing your client’s tax return. Join us as we discuss the common errors practitioners make on individual tax returns that are often missed by review staff. Sharpen your reviewing skills by examining case studies discussing issues for which additional information from the client may be warranted, and areas of tax law that require additional analysis and information.

Reviewing S Corporation Tax Returns: What Are You Missing?

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-3355.  To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.The complexity of S corporation tax law creates a formidable challenge to the tax practitioner for accurate compliance and reporting of their client's S corporation activities. Join us as we discuss the common errors practitioners make on S corporation tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.

K2's Working Remotely - The New Normal

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1129981. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.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.

K2's Advanced QuickBooks Tips And Techniques

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbursement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1136922. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.The QuickBooks platform - including the desktop and online environments - is one of the leading accounting solutions for small and growing businesses. Further, Intuit has incorporated numerous advanced features and changes into the tools over the past few releases. This seminar will teach you how to use many new and advanced features in the desktop and online environments to help you solve critical issues. For example, you will learn advanced inventory management techniques, including changing the default costing methodology and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to use the Client Data Review feature to streamline how to identify and correct errors and close accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. So, take advantage of this opportunity to learn about QuickBooks' "deep" features to maximize your effectiveness with QuickBooks.

International Taxation

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-3357. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Get a solid understanding of international tax terminology and regulations that apply to a U.S. entity involved in global operations, or for a foreign entity doing business in the U.S. Whether your organization or client is contemplating a global move or is already involved in international business, you need to know about the activities that create multijurisdictional tax exposure and the required tax reporting considerations. Course materials include the impact of the Tax Cuts and Jobs Act of 2017 (TCJA), BEPS 2.0, and other projects and regulations.

K2's Excel Tips, Tricks, and Techniques for Accountants

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1136754. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your experience level, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples to improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience delivering spreadsheet training to accounting and financial professionals, assuring you of the relevance and usefulness of the information and guidance provided during the program.

Accounting Data Analytics

-

Virtual

2.00 Credits

Member Price: $109

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-6542. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.This 2-hour mini course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials.

CFO Series: The Effective CFO

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-8902. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org. Whether you are a seasoned CFO or a staff professional, we all have the desire to enhance our skills and become even more effective. We discuss four methods to improve, including getting the most from the sales function, how CFOs can (and should) deliver much more value, new skills to develop, and how to find the time to do this? We also review the value of sustainability, ESG reporting, and measurement. A newer technique that adds value to our role so we can become even more effective. Each of these four topics will help you truly deliver more value. Enhancing Sales: Work with Sales to Drive Result 2 Business Management and Organization credits Sales and Accounting are not alike. In many organizations the two functions are at odds with each other, causing wasteful infighting. Many times, sales will undercut the accountants and vice versa. Sometimes this is inadvertent and sometimes not. Both functions should work together to achieve superior financial performance. We must take the lead and develop a better relationship with the sales function and the sales team. Oftentimes the sales incentive plans cause friction and result in counterproductive behaviors. If Accounting and Finance were to work together effectively, then net income, revenue and sales incentives would all increase. Thinking differently about how to work together will dramatically enhance financial performance. Imagine at least a five percent increase in the bottom line? We will discuss how. Working together yields superior results.Growth Opportunities for CFOs: Value Added CFOs 2 Finance credits Many CFOs place too much emphasis on external financial and statutory compliance reporting for government regulatory agencies and not enough on corporate performance management (CPM) methods including internal management accounting. The former is for valuation (e.g., inventories and COGS). The latter is for “creating wealth value” to support better decisions. This course provides tools and information for how CFOs can transition from bean counters to bean growers. The best CFOs not only keep score, which is necessary, but they enable the organization to score more, which is much more valuable.Ready to be an Effective CFO? Skills to Succeed 2 Business Management and Organization credits With all the buzz about the additional responsibilities of CFOs today, what are the essential skillsets for success? How do you excel when you are spread so thin? Becoming the multi-skilled CFO companies are looking for requires you to balance traditional responsibilities with new demands. How do you utilize your key relationships and your team to fill the gaps and make sure nothing slips through? To be effective requires a shift in the way financial leaders think and approach their day - rather than a never-ending chase after new skillsets. Thinking differently about how to accomplish the broad spectrum of CFO responsibilities is a key lesson in your essential lifelong learning. We will review many tactics to help you become even more effective.Measuring and Reporting - ESG and Sustainability 2 Finance credits ESG broadly covers many of the non-financial issues every organization faces. The use of ESG as a term however conjures images to many of tree-huggers protecting rare species at the expense of jobs and growth, requirements that well-qualified candidates are not hired or passed over for promotion because they do not meet “diversity standards” and that companies are constrained by restrictive laws and regulations from conducting their business. ESG is not about limiting growth or profitability. It is about measuring non-financial information and using that information to make companies more efficient and more profitable. ESG is not a fad that will go away but a method of viewing our organizations so that they can be better and more profitable

AI and Data Analytics for Auditing - The Big Picture

-

Virtual

2.00 Credits

Member Price: $109

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-8960. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course materials.

Level V: Advanced Management and Leadership Essentials - Overview

-

Virtual

2.00 Credits

Member Price: $109

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-9414. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.This 2-hour mini course is from our Level V course, which highlights leadership skills and situations that are common for managers and senior managers in CPA firms. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees. Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings. Helping the Firm Grow - the three levels of helping the firm grow and how to involve the entire team in expanding services to existing clients and generating referrals to new clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program) breakout rooms to ensure small group engagement and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course material.

Reviewing Partnership Tax Returns: What are you Missing?

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-3350. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.The partnership section of the Internal Revenue Code is arguably one of the most complicated. That complexity, and the reliability of tax software to properly handle it, can create many issues for you and your staff when processing your client's LLC and partnership tax returns. Join us as we discuss the common errors practitioners make on partnership tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed, including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.

K2's QuickBooks For Accountants

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-2985. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.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.

K2's Small Business Internal Controls, Security, and Fraud Prevention and Detection

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-4159. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controThisls, security, and anti-fraud measures in small organizations.

K2's Excel Essentials for Staff Accountants

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1136750. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Staff accountants have specific needs when working with Excel. Unfortunately, these needs are often not met by their existing Excel knowledge. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.

Level V: Advanced Management and Leadership Essentials

Begins: Ends:

Virtual

16.00 Credits

Member Price: $599

You could pay $0 for this course!This course qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% of the cost of training reimbursed. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website a minimum of three weeks before the start date of the course to be eligible. The course code for this program is C-4106. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Develop your soft skills in training courses that benefit both the person attending and their organization. This course, the final course of the five-course series, is applicable for various accounting departments (i.e. audit, tax, consulting, and accounting services) but because these are universal leadership concepts, they are equally applicable to other professional business leaders. The Level V course highlights leadership skills and situations that are common for managers and senior managers of organizations. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

CFO Series: Management Superpowers

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-8903. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org. We all aspire to be great managers, perhaps even with management superpowers. We will discuss how, specifically what, you can do to improve your management skills? The best leaders have a never-ending passion to improve and acquire useful knowledge. Management skills can be learned, but only if one is willing to do the work. If you aspire to be a more valued, trusted, credible leader – these four sessions of two hours each will help you become a first–class manager. Learn what makes the best managers – the best.Five Management Superpowers 2 Business Management and Organization credits “Management is about persuading people to do things they do not want to do, while leadership is about inspiring people to do things they never thought they could." - Steve Jobs. We will discuss five key management strategies and skills that every successful manager has. We walk through the A-to-Z of effective management from the standpoint of self, team, and individuals. It is not enough to be a ‘good’ manager and excel in our field, we need to be more than the subject matter expert. The five management superpowers will bolster management skills for better leaders and is a proven path for those who desire to ascend the ranks to higher leadership. Leadership is a skill that can be learned, and you can learn how. Accepting Perfectionists: Understanding & Adapting 2 Business Management and Organization credits You may know people who believe, “Good, is never good enough.” They are sharp, driven, push themselves, have lofty standards, and may focus on the negative. They wear themselves out and others as well. Could they be a perfectionist? Perhaps we have some of these tendencies? We will discuss perfectionists from several perspectives and how to harness their skills to enhance results. Perfectionism is a mindset, not a disease. We will review actions to take so that perfectionists may learn how to transform their behaviors. Based on research and proven methods, we will discuss tactics that may help. If you know at least one perfectionist, this session will significantly help you and them. Why You Should Be a Learnaholic: Staying Ahead! 2 Personal Development creditsSuccessful people do know one secret that keeps them on top? The answer is - they are lifelong learners. It is a mindset and a way of life that they learned to utilize. You did not miss out, those not born with this ability have hope. This course provides quantifiable research to support that learn-aholics (or lifetime learners) are clearly more successful, as well as practical actions on how you can stop being left behind and start getting ahead by adopting the habits and mindset of a lifelong learner. The crux is to expand your mind and expand your possibilities. This is the recipe for success you don’t want to miss!Advancing Your Role as a Business Leader 2 Business Management and Organization credits Knowing the numbers is a valued skill, but not nearly enough to make you a real business leader. True leaders put in the work and make sacrifices for others. Leadership is a learned skill, a skill that must be practiced. It may look simple, and it is – only if you know what to do and how to do it. Leadership requires one to develop a greater understanding of intangibles that are difficult to quantify – but are priceless. The best leaders care about others, are trustworthy and are credible. We will discuss proven tactics to enhance those skills. Worthy for those who want to become even more valuable as a business leader.

Learn About the New Quality Management Standards with Renee Rampulla

-

Virtual

4.00 Credits

Member Price: $309

The new quality management standards will significantly impact most accounting firms with an assurance practice. Is your firm ready for these robust changes? Participants who attend this course will learn about these changes and available resources.  

K2's Excel PivotTables for Accountants

-

Virtual

8.00 Credits

Member Price: $309

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is C-3087. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.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 make plans 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 dynamically connected 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.

Key Partnership and S Corporation Tax Planning Strategies

-

Virtual

4.00 Credits

Member Price: $219

You could pay $0 for this course!This qualifies for reimbursement through the State Workforce Training Express Fund. Firms/companies with fewer than 100 staff will receive 100% reimbusement, and firms/companies with over 100 staff will receive 50% reimbursement. You must register for this course and apply for reimbursement through the Workforce Training Express Fund website three weeks in advance to be eligible. The course code for this program is 1145315. To learn more click here or contact Julia Ekelund at jekelund@mscpaonline.org.Most of our clients are pass-through entities for which many of the general business strategies are subject to additional limitations. To provide the tax planning strategies for closely held business clients that will bring more revenue, this course focuses on the special concerns and techniques the practitioner needs to thrive in this market.