Excel Power Skills for Smarter Reporting

In the modern financial landscape, the security of a CPA’s practice is defined by the strength of their identity management and the resilience of their workflows. In 2026, the distinction between office and remote work has faded, as the cloud serves as our universal workspace. However, this borderless environment has increased the success of persistent threats like Business Email Compromise (BEC), ransomware, and sophisticated social engineering. This course provides a comprehensive update on these fundamental risks, examining how traditional attacks have become more frequent and harder to detect through automation. We will analyze the intersection of established security principles and emerging technological challenges. This includes managing the confidentiality risks posed by staff using unauthorized AI tools for client work and understanding why the professional "minimum...

Taught by Stephen Yoss · ★ 4.7

Are you tired of struggling with PDFs? Unlock the full potential of Adobe Acrobat and other PDF tools to make working with PDF files a breeze. Join our course and discover how to use powerful features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You'll also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure your PDF documents to the fullest. As the popularity and usefulness of PDFs continue to grow, many users still haven't learned how to manipulate these documents effectively. Don't let this be you! Join us for this timely session and learn the top features necessary to optimize your work with PDF documents. Say goodbye to frustration and hello to efficiency!

Taught by Stephen Yoss · ★ 4.7

The landscape of small business accounting constantly changes, and K2's Small Business Accounting is your essential guide to navigating these changes. This course focuses on the most effective accounting solutions and supplementary tools for today's small businesses. We explore robust, user-friendly software options, from industry staples like QuickBooks Online and Xero to emerging Cloud-based platforms and add-ons. The course helps you understand how these tools can streamline financial management for businesses with annual revenues up to $15 million. You will gain insights into the latest advancements, integration capabilities, and how to maximize efficiency and accuracy in small businesses.

Taught by Brian Tankersley · ★ 4.5

In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful...

Taught by Stephen Yoss · ★ 4.7

In the ever-evolving world of spreadsheets, staying ahead means mastering the latest and best techniques. Join our comprehensive program and dive deep into the best practices for creating, editing, and auditing Excel workbooks. You'll learn how to secure your workbooks, collaborate seamlessly with others, and effectively report data. Today's Excel best practices are a far cry from those of the past. This "must-see" CPE program will equip you with the knowledge to work smarter, not harder. Our course materials are packed with relevant examples to enhance your learning experience. Don't miss out on this opportunity to fully utilize Excel and elevate your skills to new heights.

Taught by Lawrence A. "Mac" McClelland · ★ 4.5

In today's world of "Big Data," every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time. Join our dynamic session to unlock the full potential of data analytics! You'll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft's Power BI application. Whether you're looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you. Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don't miss this opportunity to elevate your data analysis skills and stay...

Taught by Lawrence A. "Mac" McClelland · ★ 4.5

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Office 2021, and Office 2024 Microsoft continues to pack new features into the popular spreadsheet tool. More recent Excel versions offer enhanced data analysis tools, new functions, and improved collaboration opportunities. For those who know about these new features and apply them, exciting opportunities for improved productivity await. So, take advantage of this opportunity to learn how to use Excel’s best new features! Summary Description Microsoft continues to add new features to Excel at a breakneck pace. Dynamic Arrays, XLOOKUP, Power Query, and collaboration and commenting tools can improve productivity and efficiency. Learn about these features – and others – in this session.

Taught by Tommy Stephens · ★ 4.6