Welcome to Excel Jet Consult blog post. In this Microsoft Excel video tutorial, I demo how to dynamically highlight 1st and 2nd Max Values in Clustered Column Chart. If you enjoy this video, like, share, comment and consider subscribing if you’ve not done so.
Continue reading
Calculate YTD Across Multiple Columns Using New MAKEARRAY Excel Function + PivotTable Solution
Welcome to Excel Jet Consult blog post. In this epic Microsoft Excel video, I demo how to calculate YTD Across Multiple Columns using MAKEARRAY Function. In addition, I covered how to perform the same operation using the standard PivotTable. Enjoy and consider subscribing if you have not done soon.
Continue readingGenerate Email Addresses in Microsoft Excel [Six Examples + Power Query]
Welcome to Excel Jet Consult blog post. In this Microsoft Excel blog post, I will demo how to generate Email Addresses using different examples including Power Query. Video Sample Data In the caption below, we have sample HR dataset. We want to generate email addresses for each of the Employees using Six different methods. Ampersand First, we are going to […]
Continue reading
Timeline Gantt Chart in Microsoft Excel
Welcome to Excel Jet Consult blog post. In this Excel tutorial, I demo how to create Timeline Gantt Chart in Microsoft Excel. If you enjoy the video, Like, Share, Comment and Subscribe
Continue reading
How to Read & Enter Data from Python into Microsoft Excel
Welcome to Excel Jet Consult blog post. In this video, I demo how to write simple Python code to read an enter data into an Excel workbook. If you enjoy this tutorial, Like, Share and Subscribe
Continue reading
Smooth Scrolling Debuts in Excel for Windows
Welcome to Excel Jet Consult blog section. In this Microsoft Excel video, I talked about the newly released feature called Smooth Scrolling. Enjoy
Continue reading
OFFSET Inside SUMIFS with Multiple Criteria [Single Cell Report]
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 […]
Continue reading
Subtotal Across Multiple Columns [Outline Advanced Options Italic]
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 […]
Continue reading
Single Formula to Sort, Reorder, FILTER Non contiguous columns in Microsoft Excel
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
Continue reading
Average Daily Total in Excel & PowerBI
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 […]
Continue reading