Live Replay WebinarBasic level

Easy Excel Automation with Tables & Power Query

★★★★★ 4.5 · 2 attendee ratings

Transform your daily Excel workflows and eliminate hours of manual data processing with powerful automation techniques designed for business professionals. This comprehensive course reveals the full potential of Excel Tables and Power Query, showing participants how to turn complex data challenges into streamlined, automated solutions. Business professionals will discover how to leverage seven key table functions that dramatically reduce formatting time, eliminate formula errors, and create dynamic reports that update automatically. Organizations today need efficient ways to handle increasing amounts of data from multiple sources. This course demonstrates how Power Query serves as the ultimate tool for extracting, transforming, and loading data into Excel with minimal effort. Participants will develop practical skills to automate repetitive tasks, create robust data models, and build reliable reporting systems that save hours of work each week. These time-tested techniques have helped countless professionals reduce their manual data entry by up to 80%, allowing them to focus on higher-value analysis and decision-making activities.

CPE Credits4
Field of Study Specialized Knowledge
Instructor Stephen Yoss

Watch

What's included

Every registration comes with the course materials — yours to keep.

  • Course presentation PDF
  • Demonstration & sample files ZIP

Course details

Recommended CPE credit
4
Field of study
Specialized Knowledge
Program level
Basic
Delivery method
Group Internet Based
Prerequisites
None
Advance preparation
None
Course number
25c01232

CPE Today (Devmatics, LLC) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors (Sponsor ID 167619). State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website, nasbaregistry.org. For information about our refund, complaint, and program cancellation policies, see Company Policies or contact [email protected].

Every way to take this course

On its own

Live Replay Webinar Attend the next scheduled rebroadcast — full live CPE credit · 4 credits
$100 Add to Cart

As part of a multi-day event

These seminars include this course on their agenda. One registration covers the event — you attend this course on its scheduled day, plus everything else that day offers.

Sep 29
Automation, Insight & High-Performance Analytics Week Conference · Sep 28 – Oct 1, 2026 · Online · this course runs Sep 29, 2026 · event offers up to 26 credits
$300 View event

Your instructor

Stephen Yoss

Stephen Yoss

Speaker & Author · CPE Today · ★ 4.7 instructor rating

Stephen M. Yoss, Jr., CPA, MS, is a certified public accountant, partner and CEO of Devmatics, LLC, a continuing education instructor for financial professionals, a and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread—his love for and skill in finding technology-based solutions. In 2017, Stephen and Alex White formed Devmatics, LLC, a company focused on helping...

Full profile →

Attendee feedback

You might also like

Upcoming dates

Loading…