Welcome to Excel Jet Consult blog post. In this blog post, I will cover how to “Import Data from SQL Server to PowerBI and Create PivotTable Report from Excel on the Web PowerBI.” Let’s dive in SQL Server Data. Our dataset are the three tables under the SalesData database. I have written simple select all queries to retrieve the data […]

Welcome to Excel Jet Consult blog post. In this short tutorial, I’m going to walk you through the newly released Copy to Clipboard feature associated with the Status Bar. Let’s get started   From the screenshot below, I selected the entire Sales numbers and when I hover my mouse on the Status Bar, I get to see an option to […]

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to filter multiple columns at once using Power Query Sample Data In the caption below, we have sales record that is officially formatted as an Excel tables Load Data To Power Query Next, we want to get the dataset into the Power Query editor. To […]

Welcome to Excel Jet Consult blog post. In this blog post, I covered how to achieve same result in Excel and PowerBI using a different operation. Video Sample Data In the screenshot below, we have the sample dataset for this tutorial. In the dataset, we have columns from Date to Sales Amount. What we want to do essentially is extract […]

Welcome to Excel Jet Consult blog post. In this tutorial, we gonna learn how to use the SUMIF Function to calculate Running Total in Excel. Let’s dive in. Video Sample Data  In the caption below, we have product catalog dataset we are going to use Running Total Calculation In cell K2, execute the formula: =SUMIF($A$2:A2,A2,$J$2:$J$1992) In the above formula, we […]

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.  

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.

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  

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