CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS
Subscribe
Login
Main Menu
Main Menu
Account
Cart
Webcast

Excel Functions and Formulas

Individual
Teams

$49.00

Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.
Without FlexCast, you must start with enough time to finish. (1 Hr/Credit)

 Secure Transaction
Add Team Members
 Secure Transaction

Please fill out the form below and we will reach out as soon as possible.

CPE Credits

1 Credits: Computer Software & Applications
Course Level
Basic
Format
Webcast

Course Description

In this step-by-step Microsoft Excel tutorial taught by a former Microsoft Product Manager, you’ll get a hands-on walkthrough of the most common formulas and functions used by Excel power users. This video is perfect for beginners who are brand new to formulas and functions, as well as more advanced users who are still likely to pick up a few new tricks. The course includes an additional interactive Excel workbook. It opens with a survey of basic functions and references (including both absolute references as well as referencing cells on other sheets), as well as the fundamentals of using them. From there, it expands to cover over two dozen of Excel’s most useful functions.

Show More
Show Less

Learning Objectives

Upon completion of this course, participants will be able to:

  • Create and edit formulas in Excel
  • Reference cells via absolute references as well as cells on other sheets
  • Use fundamental Excel formulas and functions, including logical functions
  • Understand XLookup and VLookup
Show More
Show Less

Course Specifics

Course ID
WC1224393710
Revision Date
August 28, 2024
Prerequisites

None

Advanced Preparation

None

Compliance Information

NASBA Provider Number: 103220

CFP Notice: Not all courses that qualify for CFP® credit are registered by Western CPE. If a course does not have a CFP registration number in the compliance section, the continuing education will need to be individually reported with the CFP Board. For more information on the reporting process, required documentation, processing fee, etc., contact the CFP Board. CFP Professionals must take each course in it’s entirety, the CFP Board DOES NOT accept partial credits for courses.

Meet The Experts

Kevin Stratvert

With over 4.5 million subscribers and 30 million views monthly, Kevin Stratvert’s YouTube, Instagram, TikTok, Twitter, and Facebook channels are among the most popular and trusted sources of online education in the world. Before becoming a full-time educator, Stratvert was a Product Manager at Microsoft for over 10 years, leading and launching innovative products such as Office.com, Office app, FindTime, and Office Now. There, he leveraged his product management, analytics, and web analytics skills to deliver user-centric solutions that enhanced productivity and collaboration for millions of customers. He has been featured on CNBC, Fast Company, GeekWire, and Windows Central for his …

Related Courses