Welcome to Excel Jet Consult blog post. In this tutorial, we learn how to create a Dynamic Report using SUMIFS Across Workbooks and Sparklines. Let’s get started Video Sample Dataset In the screenshots below, we have a sample dataset that is officially formatted an an Excel Table And below, we have the Sales Report worksheet where we want to write […]

Welcome to Excel Jet Consult blog post. In this Microsoft SQL Server tutorial, we learn how to download and restore AdventureWorks2019 Database to SQL Server Managment Studio using Backup Technique. If you enjoy this video, give it a thumps up and consider subscribing to this channel if you have not done so Video

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn a supercool tricks to apply bulk Comments or Notes to Top 5 Total Sales in Two Steps. Let’s get started.   Video Sample Dataset In the screenshot below, we have a dataset that has 5 columns. In M365 for Excel, Microsoft has replaced Comments with […]

Welcome to this Excel Jet Consult blog post. In this tutorial, we are going to learn how to use the new Get Data From Picture which is available in M365 for Excel, Mac for Excel and Excel on the Web versions to Get Data from Multiple Pictures and Analyze with PivotTable. Let’s get started   Video Sample Dataset In the […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to connect to dataset stored in text using Power Query for Mac. Let’s get started The Excel for the Mac, just like Windows enable importing, refreshing and authenticating data sources, managing Power Query sources, clearing credentials, changing file-based data sources location, and shaping data […]

Welcome to Excel Jet Consult blog post. In this video tutorial, we will learn how to Import & Append Tables From Excel & PDF To Dataverse using Power Query Online Editor. If you enjoy this video, Like, Share, Comment and Subscribe to this channel. #Excel #PowerQueryOnlineEditor #Dataverse #PDF Video

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, I demo how to connect and import table from dataverse to Excel using Power Query. In addition, I shown how we can easily analyse the data using standard PivotTable. If you enjoy this video, Like, Comment, Share and consider Subscribing #MicrosoftExcel #Dataverse #PowerQuery   Video

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to import and filter sql server table by list in Power Query Advanced Editor. Let’s get started Video Sample Data In the captions below, we have main dataset in the SQL Server Management Studio located under the US_States_Data and Dataset Database and Table respectively […]

Welcome to Excel Jet Consult blog post. In this Excel video tutorial, we will learn how to convert numbers to proper time format using Power Query. Let’s get started Video Sample Data In the screenshot below, we have transaction data which is officially formatted as an Excel Table using CTRL + T and renamed as Data. Our goal is to convert […]

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to transform Report to Dataset using Power Query. Lets get started Video Sample Report In the caption below, we have Sales Report that shows the Account Managers name, Product Name, Payment Method, Sales Amount for January to March, which is Quarter One, April to […]