Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn one of the most unique way of extracting numbers from alphanumeric values using multiple functions. Let’s get started For more explanation, kindly watch the video below Sample Data In the caption below, we have alphanumeric values in column A formatted in an Excel Table. […]
Continue reading
SPLIT Values into Multiple Columns using FILTERXML
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to split values from single column to multiple columns using FILTERXML Function Kindly watch the video below for more explanation FILTERXML Function The FILTERXML function returns specific data from XML content by using the specified xpath. Syntax: =FILTERXML(xml, xpath) xml – eXtensible Markup Language represent […]
Continue reading
SUMPRODUCT and FIND Functions to Sum Case Sensitive Values
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to extract numbers from alphanumeric values across multiple columns and then summed. We will combination of several high-level Excel functions spanning over 600 length of characters! Let’s get started Sample Data In the caption below, we have our sample data in columns A and […]
Continue reading
Top Nth Values in Excel and Azure SQL Server
Welcome to Excel Jet Consult. In this short video tutorial, we learn how to return Top Nth Values in Excel and Azure SQL Server. Enjoy
Continue reading
Cross Tabulated Calculations Using CUBESET, CUBERANKEDMEMBER and CUBEVALUE Functions
Welcome to Excel Jet Consult blog post. In this video, I show us to how build a cross tabulated calculations using CUBESET, CUBERANKEDMEMBER and CUBEVALUES Functions. Watch below
Continue reading
Import Data To Azure SQL Database and Export To Excel
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to import excel data to Azure SQL Database via SQL Server Management Studio. We will also look at how to connect with the same data (export to Excel). Let’s get started Sample File In the caption below, we have the sample Excel data […]
Continue reading
Unusual Way To Create Chart With Paste Special
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn some unusual method to create any chart. Let’s get started Sample Data In the caption below, we have simple data showing Account Managers and sales for each quarters. Create Empty Column Chart To create and empty column chart Select any cell outside the data In the Charts group […]
Continue reading
Dynamic Chart Title
Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to make chart title dynamic. Let’s get started Sample Data In the caption below, we have a sample data Create Chart For this example, we will create a clustered column chart. Dynamic Chart Titles works on all charts. In the Charts group of the Insert tab, […]
Continue reading
Alternative To Power BI COALESCE DAX Function In Excel Data Model
Welcome to Excel Jet Consut blog post. In my previous post on COALESCE DAX Function in Power BI, I show us how to use COALESCE DAX Function which returns scalar value coming from one of the expressions or BLANK if all expressions evaluate to BLANK. In this tutorial, we are going to learn how to fill blank rows with value […]
Continue reading
Role of Comma and Semicolon in Curley Braces{}
Introduction Welcome to Excel Jet Consult blog post. In this video tutorial, we learn about when to use comma and semicolon to achieve the same result in different way. Sample Data In the caption below, we have sample data that has Account Manager and Total Sales. Note, the data is formatted in Excel Tables Top 5: Spill To Cells Below […]
Continue reading