Excel Cell Modes (And Why You Should Know Them!)
Introduction Hey Anylearners! Here’s a lesser-known topic that you should know to have a great foundation on the formulas and foundations in Excel! Most often in Excel, we use a variety of formulas…
Tableau Data Sources: How to Connect Them (A Handy Guide)
Introduction Hey Anylearners! Tableau is an amazing data analytics tool, one that many business intelligence analysts must have in their data toolbox. Being a fairly versatile and widely-used analytics software among many large…
How to Format Text as Dates using Find & Replace (Tutorial)
Introduction Hey there Anylearners! During your experience with data cleansing in Excel, I’m relatively confident that you will encounter some problems with the data format and how to convert them. In this tutorial,…
What is Tableau? (How Can it Help Your Business?)
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…
What is an Array Formula? (A Helpful Explanation)
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…
How to Filter Data in Excel (A Quick Tutorial!)
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…
