Excel - Power Functions (2024)
10 Functions Recommended by the Experts
5.00 (2 reviews)
14
students
1 hour
content
Oct 2024
last update
$22.99
regular price
What you will learn
Locate the syntax of an Excel function and explain the basics of function syntax design.
Explain why function criteria should produce a True result.
Understand and use wildcards in an Excel formula.
Create formula with nested functions.
Write a formula that combines the EDATE and DATEDIF functions to determine anniversary dates.
Write a formula using the EOMONTH function to calculate expiration dates or due dates.
Write a formula using the CONVERT function to convert data from one unit of measure to another (e.g., miles to kilometers).
Find a value in a large array of data without knowing which row or column to search using the INDEX and MATCH functions.
Debug or trace through an Excel formula using the “Evaluate Formula” feature or the Excel Formula Beautifier online tool.
Create a rolling average using the OFFSET function or OFFSET and MATCH.
Write a formula that combines OFFSET with COUNT or COUNTA to expand a range rather than revise the formula to fit the new range.
Calculate totals and subtotals using SUMPRODUCT and describe how this can be used as an alternative to pivot tables.
Screenshots
Related Topics
2360498
udemy ID
5/9/2019
course created date
11/22/2019
course indexed date
Bot
course submited by