K2's Advanced Excel
Thursday, Aug. 20, 2026
11 a.m.-7 p.m. Central
8 CPE (4 technical, 4 non-technical)
Course code: 26WA-4616
View pricing
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas:1. Collaborating seamlessly with other users and securing your workbooks2. Utilizing tables to analyze and report data efficiently3. Integrating and manipulating data from external sources with ease4. Creating and auditing complex formulas5. Harnessing advanced data analysis tools for deeper insights6. Employing visualization techniques to communicate information effectivelyDrawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!
Major subjects
-
Collaboration and security techniques.
-
Tables, data models, and PivotTables.
-
Advanced formulas.
-
Data queries.
-
Creating effective visualizations.
Learning objectives
-
Formulate the best techniques to secure Excel data and collaborate with others efficiently.
-
Evaluate the usefulness of tables and take advantage of their advanced features, such as dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model.
-
Assess Power Query's capability to link and transform data from external data sources into Excel.
-
Formulate calculations that reference functions such as XLOOKUP, GROUPBY, PIVOTBY and others.
-
Evaluate worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables.
-
Assess techniques used to create, manipulate, and customize charts for analyzing and communicating information.
Who should take this program?
- Business professionals who work with Excel and want to extend their knowledge with advanced features and functions.
Pricing
|
Standard Member Fee |
$250.00
|
 Standard Nonmember Fee |
$250.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$250.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Tommy Stephens, CPA, CITP, CGMA
Location
Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (4.0)
Accounting - Technical (4.0)
Level
Advanced
Format
Group Internet Based
Sponsor
NASBA ID#: 107810
Prerequisites
Prereq.
Experienced Excel user
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
