Welcome to Excel Jet Consult blog post. In this Microsoft Excel video, I demo how to use the new SCAN LAMBDA Helper Function to calculate % of Grand Total. Like | Share | Subscribe Video SCAN Function The SCAN Function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value. Syntax =SCAN ([initial_value], array, […]
Continue readingFirst Look @ Microsoft Excel BYROW & BYCOL Functions
Welcome to Excel Jet Consult blog post. In this video, we look at using the new BYCOL and BYROW LAMBDA Helper Functions. If you enjoy this video, like share, comment and subscribe. Video Be sure to watch the video and subscribe to the YouTube channel BYCOL and BYROW LAMBDA Helper Functions BYROW Function applies a LAMBDA to each row and returns […]
Continue readingFirst Look At New MAP Excel Function
Welcome to Excel Jet Consult blog post. This Excel video shows how to use the new MAP Lambda Helper Column. More videos coming up
Continue readingUsing CHOOSE and XLOOKUP Functions to Choose & Lookup Values Across Different Workbooks
Welcome to Excel Jet Consult blog post. This Excel tutorials talks about using the CHOOSE & XLOOKUP Functions to choose and lookup values from different workbooks. Video Sample Data In the caption below, we have two different workbooks we want to work across. The first caption is about Customer Quote where we are going to use the CHOOSE & XLOOKUP […]
Continue readingNew Excel Look (What You Need To Know)
Welcome to Excel Jet Consult blog post. In this short Excel video, we can see the brand new Excel appearance and we walked through the UI and what to watch out for.
Continue readingPower Query: Top 3 Customer Type in a cell
Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we saw how to use the Power Query to achieve Top 3 Customer Type in a single cell
Continue readingPower Query: Combine Multiple Tables from Multi Sheets + SUMIFS & PivotTables
Welcome to Excel Jet Consult blog post. In this Excel video, we learn how to use the Power Query to combine multiple tables from multiple sheets and using SUMIFS & PivotTables to create sales report by country!
Continue readingRemove Line Breaks using Power Query
In the previous video and blog post, we considered how to use FILTERXML combined with arrays of functions to remove line breaks. In this tutorial, we shall learn how to perform the same operation using the Power Query. Let’s get started. Video Do take time to watch the tutorial video and subscribe to the YouTube Channel Sample Data In the […]
Continue readingRemove Link Breaks using FILTERXML Function
Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn about how to remove line breaks in Excel using FILTERXML function Video Sample Data We have in the caption below, a sales record showing line break Our goal is to write a long formula using the FILTERXML and other functions to remove the line […]
Continue readingMS SQL Server: An Introduction to Azure Data Studio
Welcome to Excel Jet Consult blog post. In this MS SQL Server video tutorial, we learn how to use the Azure Data Studio to query our database. If you enjoy this video, like, share, comment and subscribe to the channel
Continue reading