Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn about the newly released Advanced Formula Editor which is available as an Add-in the Excel Desktop, Mac and Online platforms. Let’s get started Video Advanced Formula Environment The Advanced Formula Environment allows users to create, modify, reuse and import formulas from URL and text. The […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to calculate Sales Commission for Weekdays and Weekends using Power Query M Code. Let’s get started Video Sample Data In the caption below, we have Sales Data that is officially formatted as an Excel Table and fSalesData has be given as Table name Load Data to […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to create automatic searchable drop-down in Microsoft Excel without using formulas and VBA. Let’s get started Video Sample Data In the captions below, we have Sales Data in the Data sheet and unique Payment Type in the Table sheet respectively Create List Data Validation […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to use XLOOKUP & FILTER Functions to apply conditional formatting to our Sales Dataset. Let’s dive in. Video Sample Data In the screenshot below, we have Sales Data in the XLOOKUP and FILTER sheet tab. Our goal is to use XLOOKUP Function to format […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to create workbooks from worksheets using VBA. Let’s roll Video Sample Data In the screenshot below, we have transaction records for each of our Payment Type. In total, we have Skrill, MasterCard, VisaCard, Wester Union and PayPal. Our goal is to write VBA code […]

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we will how to create COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS calculation using Power Query and Worksheet Functions. Video Sample Data In the caption below, we have the Sales Data that is officially formatted as an Excel Table. fSalesData is given as the Table Name Load to Power Query […]

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to create dynamic searchable dropdown in Excel for the Web. Let’s get started Video Sample Dataset In the screenshot below, we have our sample dataset that consists of three columns in the Data sheet – Account Manager, State and State Abbreviation. The data is formatted […]

Welcome to Excel Jet Consult blog post. In this blog post, I will cover how to “Import Data from SQL Server to PowerBI and Create PivotTable Report from Excel on the Web PowerBI.” Let’s dive in SQL Server Data. Our dataset are the three tables under the SalesData database. I have written simple select all queries to retrieve the data […]

Welcome to Excel Jet Consult blog post. In this short tutorial, I’m going to walk you through the newly released Copy to Clipboard feature associated with the Status Bar. Let’s get started   From the screenshot below, I selected the entire Sales numbers and when I hover my mouse on the Status Bar, I get to see an option to […]

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to filter multiple columns at once using Power Query Sample Data In the caption below, we have sales record that is officially formatted as an Excel tables Load Data To Power Query Next, we want to get the dataset into the Power Query editor. To […]