I know that there are many websites and YouTube videos with hints and instructions on how to perform lots of Excel tricks. I would try and keep up and watch all the videos I could with regards to all the latest formulas and tricks. It seemed as though my head was becoming full of information I wasn’t using. I realized the real trick was to be able to develop certain favorite “moves” to get my spreadsheets to do what I wanted them to do. After doing this for a while, I began to develop spreadsheet designs that I liked that were flexible and required minimal data input. I could change numbers and just get new calculations. After I did this for some time I began to focus on better ways to perform calculations and report on the data. My research then took me in the direction of making these designs better by looking for better formulas or using new functions.
I invite you to take this journey with me and develop a feel for design and create better and better ways of looking at Excel