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 […]
Blog , Excel
Posted on:
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 […]
Blog , Excel
Posted on:
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 […]