Elevate Your Excel Skills Expand your Excel expertise with this intermediate course, designed to introduce you to a range of new referencing, lookup, and database functions. Reference Like a Pro! The first two chapters will build on your existing knowledge of lookup and referencing methods while introducing you to the advanced/updated functionalities of XLOOKUP, INDEX/MATCH, and OFFSET. Through practical exercises, you'll master these seemingly complicated functions and will start to wonder where they have been all your life! Whether it's navigating large datasets or automating repetitive actions, you'll gain efficiency and confidence. Enter the World of Database Functions Have you worked with Excel’s database functions before? This very useful but somewhat underused family of functions, introduced in the final chapter, can change the way you analyze large datasets when aggregations are necessary. You'll explore DSUM, DAVERAGE, and more, uncovering the mysteries of data analysis and...Read more.
This resource is offered by an affiliate partner. If you pay for training, we may earn a commission to support this site.
The techniques and tools covered in Advanced Excel Functions are most similar to the requirements found in Business Analyst data science job advertisements.
