Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to calculate total working days excluding weekends and holidays using Power Query. Let’s get started Tutorial Video I recommend you watch the video for more in-depth explanation Sample Data In the caption below, we have list of dates from 01/01/2020 to 31/12/2020 in column A. In […]
Continue readingConditional Formatting: Highlight Rows using ISEVEN & ISODD Functions
Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to conditionally format entire row using the ISEVEN & ISODD Function ISEVEN and ISODD Functions ISEVEN Functions returns TRUE if the number evaluated is even Syntax: =ISEVEN(number) ISODD Functions returns TRUE if the number evaluated […]
Continue readingNew STOCKHISTORY Function
Welcome to Excel Jet Consult blog post. In this video tutorial, we learn how to use the newly released STOCKHISTORY Function to fetch historical stock records. Enjoy and remember to subscribe to my YouTube channel
Continue readingExtract Numbers From Alphanumeric Values using Dynamic Array Functions
Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to extract numbers from alphanumeric values using FILTER and SEQUENCE Dynamic Array and other functions. We also see how to use use another set of functions to achieve the same functions. To watch the previous post, click on the link For more explanation, kindly watch the video […]
Continue readingExtract Numbers From Alphanumeric Values using Multiple Functions
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 readingSPLIT 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 readingSUMPRODUCT 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 readingTop 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 readingCross 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 readingImport 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