Practice, practice, practice; You cannot learn this simply by reading or watching a video. One really good way to apply the Excel skills you just learned is to replace the older functions, say the VLookup, with newer functions such as the XLookup in your current work files. That is the quickest way to make sure that you have a complete understanding of how to program the XLookup and other functions as well.