Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Advanced Excel Functions

via DataCamp

Overview

Boost your Excel skills with advanced referencing, lookup, and database functions using practical exercises.

Are you an intermediate Excel user who is looking to level up your spreadsheet game, maximize your efficiency, and transform routine tasks? Then this course is for you! You'll build on your knowledge of lookup and referencing with advanced XLOOKUP and INDEX/MATCH techniques, mastering arrays and named ranges. Dive into OFFSET and dynamic ranges to streamline your workflow, and explore Excel's database functions like DSUM and DAVERAGE to enhance your data analysis. Ready to unleash the full potential of Excel?

Syllabus

  • Lookup and reference functions
    • Already a pro with VLOOKUP? Take your skills to the next level with advanced functions like XLOOKUP, INDEX, and MATCH. We'll explore practical applications, mastering these tools and gaining a solid understanding of arrays. Enhance your referencing and lookup capabilities with these powerful techniques.
  • Offsetting and Dynamic Name Ranges
    • Discover the power of offsetting and dynamic name ranges as we master the OFFSET function and its practical uses. Set up and utilize dynamic ranges to enhance data management, applying OFFSET with functions like INDEX, MATCH, or even SUM and with data visualization. Transform your approach to complex datasets and elevate your Excel proficiency.
  • Do more with Database functions
    • Discover the power of database functions with DSUM, DCOUNT, and DAVERAGE. Master how to sum, count, and average data according to specific criteria. The chapter also includes troubleshooting advice for common errors, helping you confidently tackle complex data aggregation tasks.

Taught by

Agata Bak-Geerinck

Reviews

Start your review of Advanced Excel Functions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.