Courses
CPE Course Catalog
Engaging Professional Education Classes for Business Professionals
Excel, Accounting, Fraud, Security, Automation, AI and more!
Explore over 50 NASBA-qualified CPE courses by Stephen Yoss on CPE Today, spanning a diverse range of topics from Excel mastery to fraud prevention. Dive into his expert-led classes to enhance your accounting and technology prowess and propel your career forward. Browse his offerings below for a transformative educational experience.
CPE Today
Sponsor ID#: 167619
Connect, Transform, and Analyze Data Like a Pro with Power Query
Course Category: Excel
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.
Charting, Graphing, and Mapping Data Made Easy!
Course Category: Excel
In a data-driven world, financial professionals are expected to not only analyze numbers but also translate them into compelling stories that drive . . . decisions. This course is tailored for those who want to elevate their data presentation skills using Excel and other popular tools. Participants will dive into the art of charting, learning how to choose the right graph for their data and audience. Whether it’s a pie chart that reveals a budget’s composition or a line chart that shows financial trends over time, attendees will leave with a thorough understanding of each chart’s purpose and application.
Beyond the basics, this course offers a deep dive into the Microsoft Office suite’s charting capabilities, ensuring that participants can seamlessly integrate their visuals into Word, PowerPoint, and beyond. With hands-on exercises, they’ll transform raw figures into clear, informative charts that make an impact. By the end of the sessions, financial professionals will be adept at mapping data in a way that tells a story, engages stakeholders, and influences strategy. Don’t miss the opportunity to enhance your presentations and reports—secure your spot today and start turning your data into persuasive narratives that resonate with your audience.
Data and Statistical Analytics Using Microsoft Excel
Course Category: Excel
In today’s data-driven business environment, the ability to analyze and interpret data is an invaluable asset for any professional. This comprehensive . . . course equips participants with the skills to utilize Microsoft Excel’s robust analytical tools, transforming raw data into actionable insights. Attendees will discover how to apply descriptive statistics to gauge performance, employ Excel’s advanced functions for predictive forecasting, and harness the power of regression analysis to optimize organizational planning and budgeting.
Participants will leave with a toolkit of techniques to conduct sophisticated data analysis that can inform strategic decisions. By understanding how to identify opportunities for analytics application in real-world business projects, attendees will be able to elevate their organization’s data strategy. They will learn to navigate Excel’s capabilities to create forward-looking forecasts and measure operational effectiveness, gaining a competitive edge in the marketplace. This course is a must-attend for professionals seeking to enhance their analytical prowess and drive their business forward with confidence.
Excel Formula’s Accountants & Financial Professionals Need to Know
Course Category: Excel
Excel is ubiquitous in the accounting and financial professionals’ workplace, but some of the best functions and features for accounting and financial . . . professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.
Excel Functionality That Every Accountant Should Know
Course Category: Excel
Excel is the default program for many financial professionals–and highly effective–if used correctly. It can be used for everything from simple . . . tabular analysis to creating in-depth aggregate pivot tables. This course will give participants the necessary tools to turn data into meaningful information and will examine cutting edge ways to store, retrieve, report, and analyze data using Excel and plugins. It will provide recommendations on how to more efficiently use Excel and potential traps to avoid.Participants are encouraged to bring their technology devices to follow along with the interactive discussions, technology demonstrations, sample spreadsheets, and demo tools. Financial professionals will walk away from this course with valuable tools and insights into understanding, managing, and utilizing data in an organized and meaningful manner inside their organizations.
Excel Empowerment for Organizational Success – Custom Training
Course Category: Excel
In today’s data-driven business landscape, proficiency in Excel is not just an advantage—it’s a necessity. This tailored training session is designed . . . for financial professionals who are familiar with Excel but are aiming to enhance their skills further. The course zeroes in on the specific needs of small groups within an organization, ensuring that the material is relevant and immediately applicable. Participants will dive into the intricacies of Power Query, Pivot Tables, and the creation of compelling Charts and Graphs, tools that are pivotal for insightful data analysis and reporting.
The interactive format of the training encourages participants to bring their own projects to the table, fostering a hands-on learning environment where real-world problems are addressed with expert guidance. This approach guarantees that every minute spent in training translates into tangible improvements in the workplace. Attendees will leave with a solid grasp of advanced Excel functions, equipped to turn complex data into strategic assets that drive business success. By investing in this course, professionals will not only boost their personal skill set but also contribute significantly to their organization’s analytical capabilities.