So, you’ve started using Microsoft Excel for a while and you’re now thinking if excel can be considered as a database. Not to worry, I’ve done my research on whether Excel is a…
You might be a new or even frequent user of both Power BI and Excel and you’re starting to discover that both of these 2 data analytics tools can perform similar functions. The…
Introduction I’m sure we do use the word “If” quite commonly in conversations in our lives. It usually indicates a condition that has to be satisfied before something can happen. Similarly, such a…
Introduction Hey Anylearners! Your spreadsheet may require some lists or even tables that require inserting some checkmarks. For many, this can be a hassle, considering the variety of options in the Excel ribbon….
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…
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,…