1420 Northbrook Dr. Suite 220 Gardendale, AL 35071

March 2021 Tips and Tricks – XLOOKUP

Teksouth’s Ed Fritts shares some incredibly useful formulas and formatting tips to help streamline your data management. You will learn another great option of your mouse, how to add filters to your values within your Pivot Table, the great shortcut AutoFilter ICON, how to extract large amounts of data from an Access Database using four examples, and finally three great examples of many capabilities of what Office 365 “XLookup” can do. Please click HERE to view the full synopsis of the session. 

Ed Fritts graciously created additional videos going over each topic from the session, including step-by-step videos of the individual topics. You may download them for free below. Once the .zip folder has downloaded, click “extract” and you will easily be able to see the content of the folder.  The videos are in the “video” folder.