01 Advanced Excel Formulas and Functions
Which Excel formula helps you calculate a dynamic total/average?
=OFFSET()
What Excel function searches for a specified item in a range of cells, and then returns the relative position of that item in the range?
=MATCH()
What Excel function returns the value of a cell at a specified row and column within a range or array?
=INDEX()
How can you create a table of contents in Excel?
by combining the following functions and adding a link:
=RIGHT()
=CELL("filename")
=LEN()
=FIND()
How to build dynamic charts?
1. create a dynamic name with the name manager and OFFSET() and COUNT()
2. create a chart and select the name when choosing the series values.
What Excel tool should you use to speed up formatting?
Macros (Developer)