K2's Advanced Excel - Connecticut Society of CPAs

Overview

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information.

The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.

Objectives

Identify and implement the best techniques to secure sensitive information in Excel workbooks and collaborate with other users to improve accuracy and efficiency

Create 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

Import and link data into Excel from external sources - including text, Access, and SQL Server - and use advanced tools, such as Power Query and various cleanup tools, to manipulate the data to meet specific needs

Use advanced functions, such as SUMPRODUCT, XLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR, to create and audit complex formulas

Analyze worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables

Describe techniques used to create, manipulate, and customize charts for analyzing and communicating information

Highlights

Collaboration and security techniques

Tables, data models, and PivotTables

Advanced formulas

Data queries

Creating effective visualizations

Designed For

Business professionals who work with Excel 2019 or newer and want to extend their knowledge with advanced features and functions

Prerequisites

Experienced Excel user

Preparation

None

Notice

By registering for this program and, accordingly, receiving the eMaterials, you’re acknowledging that you understand both the copyright restrictions on your eMaterials and the CTCPA cancellation policy. https://www.ctcpas.org/events/cpe-policies

Fees

Credits

Level

Code

Vendor

Fields of Study

Leader(s):

Brian Tankersley, Director of Strategic Relationships, K2 Enterprises, LLC

Leader Bios

Brian Tankersley, Director of Strategic Relationships, K2 Enterprises, LLC

Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, writes for multiple accounting media outlets, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). Mr. Tankersley has over 30 years of professional experience, including accounting, auditing, technology, and education, has been with K2 Enterprises since 2005.

Tankersley has been recognized eight times as one of the “Top 25 Thought Leaders in Public Accounting Technology” by Cygnus Business Media. Brian has made presentations in 48 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He has received numerous awards for his writing and speaking from state CPA societies. Brian has presented sessions at most major national accounting technology conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group’s Solutions Conference, Sage Summit, CCH Connections, and Thomson Reuters Synergy User Conference.

Brian is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). He holds bachelor’s degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Tankersley also maintains numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs.

Brian and his family make their home in Farragut, Tennessee.

Return to Top