
Description
Excel functions are predefined formulas that perform calculations or manipulations on data within a spreadsheet. They take input values (arguments) and return a specific result. They are categorized by their purposes, such as math, statistical, logical, text, and date and time functions. This webinar will demonstrate some commonly used functions such as:
• VLOOKUP / XLOOKUP - used to search for a value in a table and return a related value from another column.
• If/Ifs - used to perform logical tests and return a value based on the result.
• Sumif - used to add values in a range that meet specific criteria
• Countif - used to count the number of cells in a range that meet specific criteria
Please plan to dedicate approximately 60 minutes to view this webinar.
Certificate
By completing/passing this course, you will attain the certificate Certificate of Achievement
Shopping Cart
Your cart is empty