What You'll Learn
Functions in Excel® are pre-defined formulas that perform specific calculations or actions on data. They serve as building blocks for creating dynamic and efficient formulas to manipulate and analyze your data. With hundreds of built-in functions available, Excel® offers a wide range of capabilities to handle various types of data and tasks. Excel® contains over 500 functions. Strip away the ones nobody uses. Discount the ones that have a specialized use case, and you’re left with a core set of functions that all Excel® users should know, regardless of their job function, industry, or business sector.
This presentation covers some of Excel’s most popular productivity-boosting functions. By the end of the session, you will have a solid foundation in Excel® functions, enabling you to leverage their power to perform complex calculations, automate tasks, and analyze data effectively.
This training is categorized as intermediate. It is aimed at users who want to learn about the commonly-used worksheet functions in Excel®.
Although the training will be delivered using the latest version of Excel®, this training is relevant for users of all versions of Excel®. (Please note that several of the functions, UNIQUE, SORT, and FILTER, are only available to Office 365® subscribers and users of Excel® 2021.)
Agenda
Functions Covered:
- IF: Automate Data Entry…If This Condition Is True, Enter This Value Into a Cell, Else Enter That Value Into a Cell
- COUNTIFS: Count How Many Times a Particular Value (Date, Number, Text) Appears Within a Range (e.g., How Many Times Was Customer X a Late Payer?)
- SUMIFS: Add Up a Set of Numbers That Match Criteria (e.g., What Was the Total Number of Hours Worked on Project 123)
- FILTER: Quickly Generate a Dynamic List of Filtered Items
- SUBTOTAL: Storing List-Based Data in a Table Is Best Practice, but What If You Need to Generate a Total, Count, or Average From Filtered Data in the Table?
- LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, and More: These Popular Functions Allow You to Easily Manipulate Text in Your Worksheets
- WORKDAY, EOMONTH, NETWORKDAYS: These Popular Functions Allow You to Easily Manipulate Dates in Your Worksheets
About the Author:
theexceltrainer.co.uk
- UK-based IT trainer with a career spanning over 30 years
- Has delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office®, especially Excel®, on both the Windows and Mac platforms, and Power BI®
- A fellow of The Learning and Performance Institute
- Has worked with, and for many global and UK-based companies, and organizations across a diverse range of industries which includes healthcare, pharmaceutical, and the public sector
- Designs and develops Microsoft Office®-based solutions that automate key business tasks, and processes
You Might Also Like
On-Demand Course
Illinois Mandatory Anti-Sexual Harassment Training for Supervisors
On-Demand Course
In June of 2022, Chicago amended the Chicago Human Rights Ordinance to require that all employers in Chicago provide two hours of supervisor/management and one hour of employee sexual harassment training annually for all its employees. This change is in conjunction with the Illinois Human Rights ...
Instructor: Julie A. Proscia
299.00
Order Today
Role: HR & Business Skills
299.00
Order Today
On-Demand Course
Project Management Best Practices
On-Demand Course
Let’s face it - we are all managing projects every day! They may be simple or complicated, but undoubtedly you are managing projects within your role. You don’t need to be a project manager to learn how to manage your projects effectively and efficiently. This Course will provide some of the best...
Instructor: Cheryl Grazier
299.00
Order Today
Role: HR & Business Skills
Credits: 1.0 SHRM, 1.0 HR Certification Institute
299.00
Order Today
On-Demand Course
Accountability in the Workplace
On-Demand Course
Many organizations want accountability and are often confused about how to implement this important aspect of culture into the organization without it affecting other areas of the workplace. They often see it as an all-or-nothing proposition. When an organization holds all employees to the same s...
Instructor: Irma Vargas
299.00
Order Today
Role: HR & Business Skills
Credits: 1.0 SHRM, 1.0 HR Certification Institute. This program does NOT qualify, nor meet the National Standard for NASBA accreditation.
299.00
Order Today
Interactive
Avoiding Breakdowns in Communication
Interactive
Course Overview: Strong workplace communication is more than just exchanging information—it’s the foundation of productivity, collaboration, and trust. Poor communication, on the other hand, can lead to confusion, frustration, and costly mistakes. By honing communication skills, teams work smarte...
89.00
Order Today
Role: HR & Business Skills
Credits: 1.0 CPE/NASBA, 0.75 SHRM, 0.75 HR Certification Institute
89.00
Order Today