Seminar
Live WebinarIntermediate level
K2's Excel Best Practices And Features
★★★★☆
4.5 · 227 attendee ratings
Microsoft Office Excel is one of the most widely used applications by accounting and financial professionals. Yet, many remain unaware of new and improved features in Excel and, therefore, fail to reach the level of productivity and accuracy they desire. Further, with new features appearing in Excel provided through Microsoft 365 subscriptions and the forthcoming release of Excel 2024, it is more important now than ever to get up-to-speed on the world's most popular spreadsheet! Make plans now to elevate your Excel skills by participating in this session. You will learn about the newer features available to improve efficiency and accuracy in it. You will also learn about the importance of numerous legacy features in Excel and how you can – and should – continue to use these tools to improve productivity.
Learning objectives
Upon completing this course, you should be able to:
- List examples of new functions and features in Excel
- Differentiate between Excel 2024 and subscription-based versions of Excel
- Identify steps necessary to automate tasks in Excel
- Specify the actions required to integrate data from other sources into Excel
Major topics
What to look for in Excel 2024
How to take advantage of new functions and features in Excel
Integrating Excel data with other applications
Improving Excel security
Who this is for
Business professionals seeking to use Microsoft Office Excel more effectively.
Prerequisites: Fundamental understanding 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 understanding of Excel
- Advance preparation
- None
- Length
- 1h 40m
- Course number
- 24c-ebpf
- 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
2
Building Strong Privacy & Compliance Foundations
Seminar · Aug 31 – Sep 3, 2026
· Online · this course runs Sep 2, 2026 · event offers up to 28 credits
$175/day
View event
Oct
7
Modern AI Solutions for Busy Accounting Teams
Seminar · Oct 5–8, 2026
· Online · this course runs Oct 7, 2026 · event offers up to 19 credits
$175/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.5
227 attendee ratings
Attendee reviews
★★★★★
“Flash Fill = Mind Blown!”
★★★★★
“Very knowledgeable but tends to yell for emphasis, can sometimes come across as condescending.”
★★★★★
“I've got more to learn. Thanks for the examples.”
★★★★★
“Again, I found the demos to be helpful!”
★★★★★
“Best session yet. Picked out some of the most practical new formulas and features.”
★★★★★
“Thanks for taking away some of the fear of using pivot tables in a more complex manner. I've got a lot more to learn.”
★★★★★
“I especially appreciated the instructor's sense of humor. It certainly helped keep my attention. I learned so many amazing new things about Excel. Thank you.”
★★★★★
“I never fail to learn something new from the instructors at K2.”
★★★★★
“Working with Excel is not my strong suit and I appreciated the explanation and examples provided.”
★★★★★
“Excellent. Can use this course and the power query course in my daily business.”
Related reading from our instructors
You might also like
Seminar
Seminar
Conference
Seminar