Welcome to Excel Jet Consult blog post. In this tutorial, we are going to consider how to write sql query to return the products with a price above the yearly average price. Let’s dive in. With a simple SELECT * FROM factSalesTable, we fetched all the records in the table as seen below To find all products with a price […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to use the new automatic duplicate values removal in List Data Validation in Excel. Note, new feature is currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started Tutorial Video In the previous blog post […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to use images in PivotTable Report which is a new feature currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started Sample Data and Loading to the Data Model In the screenshot below, we’ve got […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, in continuation of our single cell formula series, we will learn how to create a dynamic cross tab report using LET, SUMIFS & Many More Functions. Let’s get started Video Sample Dataset In the screenshot below, we’ve got a sales dataset which is officially stored as an Excel Table […]

Welcome to Excel Jet Consult blog post. In this SQL Server video tutorial, we are going to learn how to write the SQL query to fetch all the transactions for July 2015 for specific columns. Let’s get started. Dataset In the screenshot below, we used a simple select all statement to return all the records in the sale table. The […]

Introduction Welcome to Excel Jet Consult blog post. In this blog post, we will delve into the New game-changer in the Microsoft technology – Microsoft Fabric. Let’s dive in. What is Microsoft Fabric? Microsoft Fabric is a new end-to-end data and analytics platform that brings together all an organization’s data and analytics in one place. It was announced on May […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will learn how to combine TAKE and Drop with Multiple Functions to Create Classic Single Cell Dynamic Report👌 Let’s get started Video Sample Data The screenshot below shows the sample dataset that is formatted as an Excel Table In the screenshot below, we’ve got a drop-down in cell […]

Introduction Welcome to Excel Jet Consult blog post. In this blog, we will continue the exploration of the different objects in the Microsoft Fabric. Let’s get started. What is Dataflow? An ETL tool, Microsoft Fabric Dataflow is a self-service, cloud-based, data preparation technology that allows users to move and transform data using a visual interface. It is part of the […]

Introduction Welcome to Excel Jet Consult blog post. In this second post on the new Microsoft Fabric product, I will walk you through the steps to enable Fabric within tenant. Let’s get started. Enable Microsoft Fabric in the Tenant To enable Microsoft Fabric for your tenant, you need to follow the below steps: Click on the Settings icon in the […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will see how to insert multiple pictures in Excel cells at once using the New Place in Cell functionality. Note, new feature is currently available to Beta Channel users of M365 as at the time of writing this blog post. Let’s get started Video Tutorial   Bulk Pictures […]