Introduction If you're accustomed to the function within Microsoft Excel, I'm sure you might have come across some limitations to the charts feature in creating beautiful yet intuitive charts and...

Introduction What exactly is an Array Formula? As the name goes, it is a specific formula that is meant for arrays as opposed to a formula for single values. An array is a set of columns or...

Introduction Hey Anylearners! Filtering was one of first skills I learnt Excel and it was honestly the main reason why I had picked it up. I was new to handling data then but was amazed by how...