Who is this webinar designed for?

This session is perfect for anyone with basic Excel knowledge who wants to improve their understanding of formulas and functions to boost productivity.

Do I need prior experience with Excel to attend?

You should have a basic understanding of Excel (e.g., creating spreadsheets, entering data). This webinar builds on foundational knowledge to focus on intermediate formulas and functions.

Will I get any resources after the webinar?

Yes, you’ll receive a quick reference guide and practice files to help you apply what you’ve learned.

What is the format of the webinar?

The webinar is interactive and hosted live via Microsoft Teams. It includes demonstrations, Q&A opportunities, and resources.

What is the cost of the webinar, and how do I register?

The cost is $39 per person. You can register through our Eventbrite page or directly on our website.

Excel L2-Formulas & Functions

By Office Productivity Training, LLC

Online event

Overview

Master essential Excel formulas to boost productivity, save time, and simplify tasks.

Excel L2 – Formulas & Functions
Take your Excel skills to the next level in this hands-on, 90-minute intermediate webinar designed for self-taught users who are ready to work smarter—not harder. Learn how to write powerful formulas, analyze data efficiently, and use modern lookup functions that dramatically reduce errors and save time.

Through guided practice, you'll explore essential tools like absolute references, named ranges, logical tests, conditional calculations, and both VLOOKUP and XLOOKUP. You’ll also learn practical text and criteria-based functions that improve accuracy and help you clean and organize your data.

Topics Include:

Absolute references (F4)
Named ranges for cleaner formulas
IF, AND, OR for decision-making logic
COUNTIF & SUMIF for conditional analysis
Text functions (LEFT, RIGHT, MID) for cleaning and extracting data
VLOOKUP and XLOOKUP for fast, reliable lookups
Error-handling with XLOOKUP

Included: Quick reference guide and downloadable practice files
Length: 90 minutes
Cost: $39 per person
Hosted on: Microsoft Teams

Category: Business, Other

Good to know

Highlights

1 hour 30 minutes
Online

Refund Policy

Refunds up to 7 days before event

Location

Online event

Frequently asked questions

Organized by

Office Productivity Training, LLC

Followers

--

Events

--

Hosting

--