Excel Formula Focus: The Core Functions You Need to Know

Duration:
90 Minutes  
Instructor
Cathy Horwitz

Learn essential Excel functions to manage, analyze, and manipulate data with ease. We will cover fundamental statistical functions like SUM, AVERAGE, MAX, MIN, and COUNT, helping you quickly summarize datasets.

Recorded
Refund Policy

Overview

Learn essential Excel functions to manage, analyze, and manipulate data with ease. We will cover fundamental statistical functions like SUM, AVERAGE, MAX, MIN, and COUNT, helping you quickly summarize datasets. We will also explore the conditional function IF, which allows you to perform calculations based on specific criteria. The class will introduce you to the power of VLOOKUP for searching and cross-referencing data, as well as date functions like TODAY and NOW for calculating and working with time-based data. Additionally, you'll learn how to manipulate text using functions like LEFT, RIGHT, TRIM, and CONCAT, making it easy to clean and format imported data.

Why you should Attend

This class is ideal for anyone looking to take their Excel skills to the next level and streamline their workflow. Whether you're an analyst, manager, or anyone who works with large datasets, mastering these functions will save you time, reduce errors, and help you extract meaningful insights quickly. With hands-on practice, you’ll be equipped to handle a variety of data-related tasks, from statistical analysis and date calculations to text manipulation, making you more efficient and confident in your Excel abilities.

Areas Covered in the Session

  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
  • Use IF and explore its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Understand VLOOKUP
  • Calculate dates using TODAY, and NOW
  • Learn many functions to manipulate text once imported including LEFT, RIGHT, TRIM and CONCAT

Who Will Benefit

This class is ideal for anyone looking to take their Excel skills to the next level and streamline their workflow. Whether you're an analyst, manager, or anyone who works with datasets, mastering these tools will save you time, reduce errors, and help you extract meaningful insights quickly.

  • Financial Analysts
  • Accountants 
  • Data Analysts
  • Project Managers 
  • Operations Managers
  • Marketing Analysts 
  • Sales Managers 
  • Supply Chain Managers 
  • HR Professionals  
  • Researchers 

Speaker Profile

Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.

Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.

Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
Access Recorded Version
One Attendee / Group Attendees

Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)