May 2020 | Page 2 of 2 | Commerce Curve

Dependable Drop-Down Function in Excel

by Commerce Curve | May 21, 2020 | Online Business Courses

What is Dependable Drop-Down Function in Excel? Dependable drop-down function is an advanced function of data validation that allows us to create simple drop-down lists. With the help of dependable drop-down function, we can create drop-down lists for more than one...

Advanced Filtering in Excel

by Commerce Curve | May 21, 2020 | Online Business Courses

What is Advanced Filter Function in Excel? Advanced Filter function of Excel is used to filter the data, when criteria to filter the data is complex. By creating a criterion through Advanced Filter function, you can extract unique data from large data base. This...

INDIRECT Function in Excel

by Commerce Curve | May 16, 2020 | Online Business Courses

What is INDIRECT Function in Excel? INDIRECT function of Excel is used to give reference to the cell, cell range, any named range, work sheets or workbook. In simple words INDIRECT function is used to refer the cells, cell range of different work sheets or workbook in...

Dependable Drop-Down Function in Excel

Advanced Filtering in Excel

INDIRECT Function in Excel

Don’t Forget Your Free eBook!

Get your Excel Pro Tips eBook and free email updates to help you learn Excel.

Enter your email address below to
receive weekly Excel tips and your eBook.
It’s all FREE!