# Summary Statistics, Measure of Location & Correlation Coefficient in Excel (Download File)

Welcome to Excel Jet Consult blog post. In this video tutorial, I am going to show you how to perform Summary Statistics, Measure of Location & Correlation Coefficient in Excel. Do watch the video below. Download the practice file: Statistics in Excel YouTube File

# XLOOKUP/RECHERCHE Function in Excel (File)

Welcome to Excel Jet Consult blog post. In this video tutorial, I am going to show you different examples of XLOOKUP function. Do watch the video below and download the attached Excel XLOOKUP File 1 and XLOOKUP File 2

# GroupBy Function with Dynamic Conditional Formatting

Welcome to Excel Jet Consult blog post. This video shows how to author advanced formula using GroupBy function with dynamic conditional formatting. Groupby Magic in Excel Video

# The Definitive Guide to Endorsing Fabric Items: Promoting and Certifying

What is Endorsement in Microsoft Fabric? Endorsement is basically a way to highlight the best items in the Microsoft Fabric ecosystem, making them easier to find and use by users within an organization. Endorsement ensures that reliable, high-quality data, processes, and content are easy to find within Microsoft Fabric. Types of Endorsement in Microsoft Fabric Succinctly, there are two types […]

# Generate Randomised Dates and Extract Day, Month, Year and Quarter using Single Formula in Excel

Microsoft Excel has long been a staple for number-crunching and data analysis, but recent additions to its formula arsenal, such as the LET function and dynamic arrays, take spreadsheet calculations to a whole new level. In this article, we’ll explore a sophisticated advanced Excel formula that generates randomised dates and at the same time, extract day, month, year and quarter using single […]

# Leveraging XLOOKUP in Excel for Dynamic Data Retrieval

Welcome to Excel Jet Consult blog post. In this post, we will consider how to leverage the XLOOKUP function combined with LET function to dynamically retrieve data. Let’s get started. In this examples, we’ve got data showing Month and Units in columns A and B respectively as seen in the screenshot below Our goal is to use nested XLOOKUP function […]

# Randomized Data Generation with Weekly Pattern in Excel

As a person data analyst working in the retail industry, imagine you’re tasked with simulating weekly retail sales that could represent the variability in daily sales with higher values during weekends (multiples of 7) and lower values during weekdays? Or you’re working as a data analyst in the energy firm and your manager asked you to simulate weekly energy consumption […]

# Credit Card Fraud Detection Machine Learning in Fabric Notebook

Welcome to Excel Jet Consult blog. In this video, I walked you through how to perform Credit Card Fraud Detection Machine Learning video: Download Source Code Here: Credit_Card_Fraud_Detection_Machine_Learning