Adventures in Excel
Frequently used simple but powerful functions in Microsoft Excel
0
students
1.5 hours
content
Mar 2021
last update
$19.99
regular price
What you will learn
Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT
Useful date functions including TODAY, EOMONTH, EDATE, and DAYS
Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table
The new RANDARRAY function in Office365
The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS
Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE
Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR
How to create a drop-down list
The new SORT and FILTER functions in Office365
VLOOKUP and the new XLOOKUP function
How to create a Pivot table and analyse data with one
Screenshots
Related Topics
3888022
udemy ID
3/3/2021
course created date
3/8/2021
course indexed date
Bot
course submited by