https://screenrant.com/star-trek-picard-academy-fear-friends-guinan/

Events in Star Trek: Picard's Academy reveal how Picard gained the skills needed for him to be able to seek Guinan's counsel in The Next Generation.