Virtual

K2's Excel's Best New Features

Date: July 6, 2023

Time: 9 – 11 a.m. PT

CPE: 2

Overview

With recent Excel updates provided through Microsoft 365/Office 365 subscriptions and Office 2021, Microsoft continues to pack new features into the popular spreadsheet tool. More recent Excel versions offer enhanced data analysis tools, new functions and improved collaboration opportunities. For those who know about these new features and apply them, exciting opportunities for improved productivity await. So take advantage of this opportunity to learn how to use Excel’s best new features!

Product Code
1000002208-120225
Credit Type
CPE: 2
CPE-Non-Technical: 2
Accessibility
Closed Captioning Available
Intended Audience
Accounting and financial professionals seeking to use Excel’s newest features
NASBA Field of Study
Computer Software & Applications
Level of Difficulty
Update
Prerequisites
Fundamental knowledge of Microsoft Office Excel
Advance Preparation
None

Learning Objectives

Apply primary new functions available in Excel, including STOCKHISTORY, SORT and FILTER

Employ Excel’s co-authoring feature to collaborate in real time with other users

List at least three new functions that capitalize on Excel’s Dynamic Arrays feature

Utilize Excel’s XLOOKUP and XMATCH functions to locate data in spreadsheets

Major Subjects

Learn how to work with Dynamic Arrays
Using Excel’s new XLOOKUP and XMATCH feature
Improvements to Power Query and why they matter to you
New collaboration and commenting options in Excel

Faculty

Randolph P. Johnston

Randy Johnston is a nationally-recognized educator, consultant, and writer with over 30 years’ experience in strategic technology planning, accounting software selection, paperless, systems and network integration, business continuity and disaster recovery planning, business development and management, process engineering and outsourced managed services. Johnston has been with K2 since 1990, where he consults to high profile technology vendor...

More about Randolph P. Johnston

Thomas G. Stephens Jr

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. During his professional career, Tommy has gained valuable ex...

More about Thomas G. Stephens Jr

Additional Details

This course was recorded on 6/22/2023. The instructor will be available via the chat feature to answer questions during the presentation.

K2's Excel's Best New Features

Member

Nonmember

Overview

Product Code

Credit Type

Accessibility

Intended Audience

NASBA Field of Study

Level of Difficulty

Prerequisites

Advance Preparation

Learning Objectives

Major Subjects

Faculty

Additional Details