Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we learn how to create advanced chat that responds to dropdown list. If you enjoy the video, consider subscribing to the channel for more videos. Kindly find the practice file link below: https://www.exceljetconsult.com.ng/wp-content/uploads/2021/09/Incredible-Chatting.xlsx Video
Continue readingCategory Archives: Blog
Calculate Smallest Sales Amount [Microsoft Excel 2019 & Microsoft 365]
Welcome to Excel Jet Consult. In this blog post, we are going to consider how to calculate smallest sales amount in MS Excel 2019 and Microsoft 365. Let’s get started Video Sample Data We have a sample data below which is formatted as an Excel Table. Also, we have drop-down list in cell E1 which houses the unique Payment Method. […]
Continue readingFILTER Top 5, 10, 15 or 20 Sales using Spin Button
Welcome to Excel Jet Consult blog post. In this Microsoft Excel tutorial, I demo how to filter top 5, 10, 15, 10 using Spin Button. If you enjoy this video, like, share, comment and subscribe
Continue readingSwitch ON/OFF Conditional Formatting using LAMBDA Custom Function in Microsoft Excel
Welcome to Excel Jet Consult. In this video, I demo how to use LAMBDA Function to Switch ON/OFF Conditional Formatting. If you enjoy this video, like, share, comment and SUBSCRIBE!
Continue readingUnpivot Columns in Excel and SQL SERVER
Welcome to Excel Jet Consult blog post. In this video, I demo how to unpivot columns in Excel and SQL Server. If you enjoy this video, share, like, comment and subscribe Video Kindly watch the video tutorial below Unpivot Columns in Power Query Unpivot Columns simply means to rotate dataset from columns into rows. We have the sample sales data […]
Continue readingCalculate % of Grand Total using Microsoft Excel SCAN Function
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 reading