Conference
Live Replay WebinarIntermediate level
K2's Mastering Advanced Excel Functions
★★★★★
4.5 · 21 attendee ratings
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in 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
- 4
- Field of study
- Computer Software and Applications
- Program level
- Intermediate
- Delivery method
- Group Internet Based
- Prerequisites
- None
- Advance preparation
- None
- Course number
- 23s-aef-4
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.
Nov
24
Final Excellence Week: Security, Automation & Insight
Conference · Nov 23–25, 2026
· Online · this course runs Nov 24, 2026 · event offers up to 22 credits
$300
View event
Your instructor
K2 Enterprises
Various Speakers · Accounting Technology · ★ 4.3 instructor rating
K2's goal is to produce and deliver the highest quality technology seminars and conferences available to business professionals. We work cooperatively with professional organizations (such as state CPA societies and associations of Chartered Accountants) and vendors of technology products. K2 also provides consulting services and advice on technology. We make every effort to maintain a high level of integrity,...
Full profile →Attendee feedback
4.5
21 attendee ratings
Attendee reviews
★★★★★
“Stephen was very knowledgeable and easy to follow along with.”
Related reading from our instructors
You might also like
Conference
Conference
Conference
Next week
Automation, Insight & High-Performance Analytics Week
Computer Software and Applications
★★★★★
4.6 (391)
$300
Conference