Topic 7 - Advanced excel awesomeness: Macros, web queries, and other cool stuff. The topics discussed in this chapter are: Macros, function descriptions, data tables, data controls (drop down, spin buttons), conditional formatting, sparkle charts, vlookup and hlookup, pivot tables, slicer, web queries. | Lecture Financial modeling - Topic 7: Advanced excel awesomeness: Macros, web queries, and other cool stuff