Have you ever found yourself in a situation where you have to create a dashboard where data lies in multiple datasets? If you have, you are not alone. Most visualization tools (including Power BI) introduced this feature of “relationships”, which allows you to connect datasets together. This article will explain […]
SUMIFS: What is it, and how to use it in Excel
SUMIFS allows you to add numeric types based on certain specified criteria. Some examples could be finding out the total salary of each department, the number of inventory in a particular warehouse, and your total expenses for the month. It is extremely useful when you have a dataset that can […]
3 REASONS why you need to learn XLOOKUP in Excel
As a data Analyst, you will be using Excel A LOT. Some examples of its uses could be to validate data within a dashboard, create pivot tables for simple analysis, or even curate dashboards (personally not my favorite). As you use Excel, there will be many things you would want/need […]
XLOOKUP: What is it, and how to use it in Excel?
XLOOKUP is a lookup function that is used to find things in a table within a column. Some examples could be finding an employee’s department with the use of their department code, finding the product name from its product ID, and finding the customer’s names that purchased from your shop […]