Dynamic Cross Tab Report using LET, SUMIFS & Many More Functions [Single Cell Formula Series]

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 […]

Continue reading

What is Microsoft Fabric and What Are The Benefits To Organizations?

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 […]

Continue reading

Combining TAKE and DROP with Multiple Functions to Create Classic Single Cell Dynamic Report👌

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 […]

Continue reading

Dataflow in Microsoft Fabric & How To Get Started

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 […]

Continue reading

How To Enable Microsoft Fabric in the Tenant

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 […]

Continue reading

Insert Multiple Pictures in Excel Cells at Once using the New Place Cell

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 […]

Continue reading

PowerBI Data Analyst vs. Data Engineer vs. Developer: Unravelling the Roles in Data-Driven World

Introduction Welcome to Excel Jet Consult blog post. In today’s data-driven world, organizations businesses rely on professionals who can harness the power of data to drive insights, make informed decisions, and build data solutions. PowerBI Data Analysts, Data Engineers, and Developers are integral parts of this data ecosystem, each playing a unique role in the data journey. In this blog […]

Continue reading

Part 2: Repeat All Products By Units Sold Frequency Distribution using Power Query

Welcome to Excel Jet Consult blog post. In this Part 2, I demo how to, “Part 2: Repeat All Products By Units Sold Frequency Distribution using Power Query.” Le’ts get started Video Sample Data We are going to use the same dataset used in the formula based solution (Part 1) as seen below Power Query Operation The first thing we […]

Continue reading