Excel Functions

On-Demand Schedule

Fri, December 27, 2024 - Fri, January 03, 2025

Duration

90  Mins

Level

Basic & Intermediate

Webinar ID

IQW24L1234

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

Overview of the webinar

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.

Faculty - Mr.Bob Umlas

Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018. 

He has been using Excel since 1986 - version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel. 

Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1994-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called "Maximizing Excel Development Using Array Formulas" at Microsoft's Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City. He has hosted London’s Global Excel Summit each year since 2021, and in person in 2024, as well as led a session on tips and tricks. He also led a session on tips and tricks at the Las Vegas’ Financial Modeling World Championship in December, 2023. He has led online sessions all over the world including Africa, India, England, Canada and of course, the USA.

 

100% MONEY BACK GUARANTEED

Refund / Cancellation policy
For group or any booking support, contact: