Use Excel XLOOKUP Function to Compare, Refine Lists and Generate Pivot Table Reports
Manage episode 444898893 series 3607581
The XLookup overcomes the limitations of the Vlookup Function in Microsoft Excel Spreadsheets. With the XLookup you are not bound by the lookup value being located in the first column of the table, you can return the nearest highest value and more.
YouTube Analir Pisani https://youtu.be/II3XXd2uNZ8
Customised Computer Courses in Sydney, Australia and Virtual Classes. http:www.azsolutions.com.au
🎓
Offer Microsoft Office Training: Virtual and F2F Sydney, NSW
http://www.azsolutions.com.au
Monthly Microsoft Office Tips & Tricks - you don't want to miss
https://azsolutions.us19.list-manage.com/subscribe?u=a352b0debea85189d4d68fd9c&id=a3f1428545
Free 30in Webinars, Last Thursday of every month.
https://azsolutions.com.au/microsoft-office-tips-tricks-webinars-free/
Connect with me on LinkedIn Analir Pisani
https://au.linkedin.com/in/analir-pisani-9539a749
For upcoming event visit my Facebook page:https://www.facebook.com/CustomisedComputerCoursesSydney/
Virtual Classes or join me face to face in Sydney NSW Australia.
https://azsolutions.com.au/virtual/
Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist
53 Episoden