The Top Ten Excel Functions Everyone Should Know

Duration:
90 Minutes  
Instructor
Cathy Horwitz

Excel functions can greatly enhance your ability to perform tasks in day-to-day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know.

Recorded
Refund Policy
HRCI

The use of this seal confirms that this activity has met HR Certification Institutes (HRCI) criteria for recertification credit pre-approval.
This activity has been approved for 1.5 HR (General) recertification credit hours toward aPHR, ...more

Overview

Excel functions can greatly enhance your ability to perform tasks in day-to-day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, a small business owner using Excel to keep track of your finances, or just a casual user, these Excel functions can be very important time savers and enhance your ability to create better-performing spreadsheets!

Why you should Attend

This webinar will get you started with functions. You will learn not only HOW to use these functions, but WHY they do what they do.  Knowing the "why" helps you to do more with Excel. Attendees should have basic knowledge of creating Excel calculations using basic mathematical operators and know the difference between relative and absolute cell references. This course is for beginner to intermediate Excel users.

Areas Covered in the Session

  • Learn many statistical functions including SUM, AVERAGE, MAX, MIN, and COUNT
  • Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
  • Understand VLOOKUP
  • Calculate dates using TODAY, NOW and NETWORKDAYS
  • Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM, and CONCATENATE
  • Use IFERROR when errors can’t be avoided

Who Will Benefit

  • Business Owners
  • CEO's / CFO's / CTO's
  • Managers
  • Accountants
  • CPA's
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Anybody with large amounts of Data
  • Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

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)