Traincel Compliance Logo
Data Analytics for... Banner

Data Analytics for Accountants: Getting Started with Python in Excel

90 Minutes

August 28, 2026

01:00 PM EST

Live Webinar

Overview

Discover how Python is transforming Microsoft Excel and learn how to use it to perform powerful data analysis without leaving your spreadsheet. Designed for accountants, finance professionals, auditors, and business users, this introductory session provides a practical overview of Python in Excel, its capabilities, and where it fits alongside Excel's built-in tools.

You'll explore how Python can simplify data analysis, automate repetitive tasks, and work with large datasets while also learning when Excel's native features—such as PivotTables, Power Query, and dynamic arrays—may be the better choice. Whether you're curious about Python or looking to prepare for the future of Excel, this session will help you understand the opportunities it brings to modern data analytics.

Areas Covered

·      Introduction to Python in Excel and how it integrates with Microsoft 365.

·      Understanding the requirements and environment for using Python in Excel.

·      Creating and working with Python dataframes in Excel.

·      Comparing Python with Excel's native tools for data analysis and reporting.

·      Using PivotTables to analyze and summarize business data.

·      Importing, cleaning, and transforming data with Power Query.

·      Refreshing Power Query data automatically for up-to-date reporting.

·      Working with Excel Tables to improve data integrity and organization.

·      Using Slicers to simplify filtering and interactive reporting.

·      Navigating large workbooks efficiently with the Navigation pane.

·      Understanding the differences between Python, VBA, and Office Scripts for automation.

·      Recognizing when to use Python versus traditional Excel features for common business tasks.

·      Practical demonstrations of Python in Excel using real-world examples..

All Access Pass Banner

All Access Pass Benefits

$999 per year

  • Access to 12 Live or On-Demand Webinars per year
  • All Live and On-Demand webinars include certificates, printable presentation material and handouts
Learn More

Speaker

David H. Ringstrom's Avatar

David H. Ringstrom

Microsoft Excel Expert

Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, but in 2009, he began teaching for continuing education providers as well. His mission since then has been to offer quality training on Excel and additional accounting software via live webcasts, on-demand self-study webcasts, and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs. David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. David is known for saying, “Either you work Excel, or it works you.” Based on this belief, he focuses on teaching users what they don’t know but should know about Excel. His comprehensive yet easy to understand presentations cover Excel 2016, 2013, 2010, and 2007. David’s webcasts are fast paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.