1. And it's a wrap!
Congratulations - you've just finished this course! Let's review what you've learned!
2. Chapter 1
In the first chapter we've learned a few new lookup and referencing functions such as XLOOKUP, INDEX and MATCH and the powerful combination of both. We have also learned about arrays and recapped on gaining efficiency with named ranges in Excel.
3. Chapter 2
In the second chapter we continued building the referencing skills with newly learned OFFSET function. We then expanded this skill by combining its use with INDEX and MATCH and finally we progressed into building powerful dynamic selection tools and even visualizing our outputs.
4. Chapter 3
Finally, in chapter 3, we learned a brand new family of functions, the database functions such as DSUM, DCOUNT and DAVERAGE. We've learned how to use them to work efficiently with large datasets and we performed multiple hands-on aggregations including quite complex AND and OR conditions.
5. Don't stop learning!
Thank you very much for taking this course! Don't stop your learning adventure here and come back for more quality content and courses on DataCamp.