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 dashboards. Excel was…
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…
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…