Conference Info
- IndustryHuman Resources
- Unique IDUSC2025329
- Duration90 Minutes
- DateMar 20,2026
- Time10:00 AM PST | 01:00 PM EST
Description
Overview
Learning Excel's built-in functions offers significant benefits, enabling users to work more efficiently and make data-driven decisions with confidence. By mastering functions like VLOOKUP, IF, and SUMIF, users can automate repetitive tasks, reduce errors, and streamline data analysis. This not only saves time but also improves accuracy when handling large datasets. Excel’s functions allow users to quickly summarize, filter, and extract insights from data, enhancing productivity in roles that involve finance, project management, reporting, and beyond.
Moreover, understanding Excel’s functions empowers users to solve complex problems without the need for additional software or external help. From creating dynamic dashboards to conducting advanced financial modeling, the ability to use built-in functions provides a competitive advantage in nearly every industry. As businesses increasingly rely on data for strategic decision-making, proficiency in Excel functions equips individuals with the tools to analyze trends, predict outcomes, and present data in a clear, actionable format.
Who should attend?
Anyone who uses Excel needs to be able to make their work more efficient. So, this course is for
- All Excel Users
Why should you attend?
Excel has several hundred built-in functions. This intermediate Excel course focuses on enhancing users' proficiency with key functions for data analysis and automation. It covers logical functions like IF, AND, OR, and IFERROR to handle decision-making and error management. Learners will master lookup functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP for more efficient data retrieval. Text functions like CONCAT, LEFT, and TEXT will be explored to manipulate and format data, while advanced date and time functions such as TODAY, NETWORKDAYS, and DATEDIF will be introduced for managing schedules and deadlines. By the end, participants will be able to apply these functions to real-world data challenges.
What you'll learn?
Here is a list of functions which will be covered, time allowing:
- AND
- FALSE
- IF
- IFERROR
- IFS
- LET
- NOT
- OR
- CHAR
- CLEAN
- CODE
- DOLLAR
- EXACT
- FIND
- LEFT
- LEN
- LOWER
- MID
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTSPLIT
- TEXTJOIN
- TRIM
- UPPER
- DATE
- DATEVALUE
- MONTH
- NOW
- AREAS
- CHOOSE
- COLUMNs
- CHOOSECOLS
- CHOOSEROWS
- FILTER
- INDIRECT
- MATCH
- OFFSET
- ROW
- SORT
- SORTBY
- TOCOL
- TOROW
- TRANSPOSE
- UNIQUE
- TRUE
- PROPER
- VALUE
- TIME
- TODAY
- HSTACK
- VSTACK
- INDEX
- VLOOKUP
- XLOOKUP
- XMATCH

Mr. Bob Umlas