Deploying Single Slicer on Multiple Pivot Tables With Different Data Sources

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to deploy single Slicer to filter multiple Pivot Tables with different data sources. Let’s get started In the caption below, we have two Excel Tables. The first Table spans from column A to C while the second Table spans from column E to F In […]

Continue reading

Non-contiguous Columns Values Addition using Paste Special

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to perform non-contiguous columns values addition using the conventional and Paste Special methods. Let’s get started In the caption below, we have a sample transaction data. We have Cost Price and Retail Price in columns E and G respectively. For this business, the Cost Price of […]

Continue reading

Calculating Fiscal Quarter in Power BI

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to calculate Fiscal Quarter. Let’s get started. To learn how to create Standard Quarter using different methods, click here Fiscal Quarter In this example, the Fiscal Quarter starts from July of the current year and ends in June of the next year. This invariably implies […]

Continue reading