Import Data from SQL Server to PowerBI and Create PivotTable Report from Excel for the Web

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

Continue reading

Newly Arrived Copy to Clipboard

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

Continue reading

Running Total using SUMIF Function

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

Continue reading

Generate 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