Excel for Beginners: Advanced Functions
Completed by DEREK HAOXIANG LIAN
May 15, 2024
1 hours (approximately)
DEREK HAOXIANG LIAN's account is verified. Coursera certifies their successful completion of Excel for Beginners: Advanced Functions
What you will learn
Manage data more easily by using advanced conditional functions like COUNTIF, COUNTIFS.
Create conditional data by combining basic arithmetic with logic into functions like SUMIFS and AVERAGEIFS.
Quickly search and obtain specific values in tables with reference functions like VLOOKUP, XLOOKUP, INDEX, MATCH.
Skills you will gain
- Category: Spreadsheet Software
- Category: Microsoft Excel
