Recap

A Handout will be shared during the class

Class Participation and Engagement

Use Zoom Chat for questions

Use Slack to communicate

📌 More info on how to set up for learning Excel:

Copy of Overview of EBPL Learn Excel Online

In the last class, we covered how to Implement basic Excel functions (including financial, logical, and text functions).

Topic or activity

We'll be reviewing

How to sign up to Office.com and get access to a free version of Microsoft Excel

Pivot tables, Charts, scatter plot, pie charts, etc

XLookup

Excel_III_My_Budget_ 1 (1).xlsx

XLOOKUP

XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.

XLOOKUP uses a lookup array and a return array, whereas VLOOKUP uses a single table array

Left to Right Look Up

XLOOKUP returns the Prefix (Column D) when the user enters a Country (Column B)

Right to Left Look Up

XLOOKUP returns the Tax Rate (Column F) when the user enters a Max Income (Column E)

Returns a Range of Values

XLOOKUP returns the Employee and Department (Columns C and D) when the user enters an Employee ID (Column B)

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/e294c588-860b-40b3-b1b2-5970c280a3d3/Untitled.png

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2bebfeed-8bb6-4d49-8520-95f40413a183/Untitled.png

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/3630ed0c-71d4-4175-85ed-2e6669a277b8/Untitled.png

📡 For More Info: https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

🗒️ Example: https://coursera.org/share/dc853e7a7b16efdb9eb9605df6422b9f