Welcome to Excel Jet Consult blog post. In this Microsoft Excel tutorial, we will learn how to use the OFFSET function inside SUMIFS to perform multiple criteria calculation inside a single cell. Video Sample data In the screenshot below, we have a Sales Data that is stored as an Excel Tables. Calculation In cell J2, we want to write a […]

In this Microsoft Excel tutorial, I demo how to perform Subtotal Across Multiple Columns and how to italicize selected cells using the inconspicuous Outline Advanced Options dialogue box! Let’s get started   Video Sample Data In the screenshot below, we have sales data that spans from Date to Sales Amount. Note that it is impossible to perform Subtotal with dataset […]

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, I demo how to write a single formula that SORT, Reorder and FILTER Non-contiguous columns with multiple criteria in Microsoft Excel. Do find the practice file download link: Single formula to Sort, Reorder & Filter Non-Contiguous Columns Columns     Video

Welcome to Excel Jet Consult blog post. In this Excel and PowerBI video tutorial. we learn how to calculate Average Daily Total using DAX. If you enjoy this video, consider subscribing to this channel File Link: https://www.exceljetconsult.com.ng/wp-content/uploads/2021/09/pbi.xlsx pbi Video Sample Data We have the sample data as seen below. The data is formatted as an Excel Table and named Sales […]

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

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. […]

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

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!  

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 […]

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, […]