Seminar
Live WebinarIntermediate level
K2's Excel Tips - Today's Best Features
★★★★★
4.6 · 120 attendee ratings
Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel – the business professional’s tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday’s practices for working in Excel. In this session, you will learn how to use many of Excel’s latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel – and who doesn’t – this session is necessary to help you improve your efficiency and effectiveness when using Excel.
Learning objectives
Upon completing this course, you should be able to:
- List examples of key new features in Excel and how and why business professionals can take advantage of these tools
- Identify use cases for Excel’s PIVOTBY and GROUPBY functions
- Specify how Office Scripts differ from traditional Excel macros
- Cite examples of using Copilot in conjunction with Excel
- List examples of new opportunities to collaborate with others using Excel
Major topics
New features and functions in Excel
How to improve efficiency and effectiveness when working in Excel
Taking advantage of Copilot integration with Excel
Better ways of creating and working with formulas
Who this is for
Update this attribute value to the course desired audience.
Prerequisites: Fundamental knowledge of Excel
What's included
Every registration comes with the course materials — yours to keep.
- Course handout PDF
- Demonstration & sample files ZIP
Course details
- Recommended CPE credit
- 2 — Computer Software and Applications
- Field of study
- Computer Software and Applications
- Program level
- Intermediate
- Delivery method
- Group Internet Based
- Prerequisites
- Fundamental knowledge of Excel
- Advance preparation
- None
- Length
- 1h 40m
- Course number
- 25c-exltips
- Provider
- K2 Enterprises
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
How to attend this course
This course isn’t sold on its own — it’s offered exclusively at these events. One registration covers the event: you attend this course on its scheduled day, plus everything else the event offers.
Sep
24
Transforming Workflows Through Smart AI Tools
Seminar · Sep 21–24, 2026
· Online · this course runs Sep 24, 2026 · event offers up to 17 credits
$125/day
View event
Your instructor
Tommy Stephens
Partner · K2 Enterprises · ★ 4.6 instructor rating
Tommy Stephens received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. In 1992, he earned a Master of Science degree (Major in Finance) from Georgia State University in Atlanta. Presently, Tommy is a Certified Public Accountant, a Certified Information Technology Professional, and a Chartered Global Management Accountant. In 1995, Tommy began...
Full profile →Attendee feedback
4.6
120 attendee ratings
Attendee reviews
★★★★★
“Always a very beneficial course”
★★★★★
“Very insightful with clear explanations. Now just need to work with it on my own.”
★★★★★
“Knows his stuff!”
★★★★★
“Good topic.”
★★★★★
“Lots of good tips in this session.”
★★★★★
“Stephen Yoss is my favorite instructor. Gained many useful tips but had a little trouble trying to follow along with the exercises. However, I feel like this was a direct result of the time constraints.”
Related reading from our instructors
You might also like
Seminar
Seminar
Conference
Seminar