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

USERELATIONSHIP DAX Function

Welcome to Excel Jet Consult blog post. In this tutorial we want to learn how to use the USERELATIONSHIP Dax Function. Let’s get started USERELATIONSHIP Function specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and column Name2. Note, the relationship can be deployed with functions that take filter as an argument. […]

Continue reading

New Workbook Statistics in Office 365

Welcome to Excel Jet Consult blog post and Happy New Year 2020. In this post, we want to learn how to use the new Workbook Statistics made available to Office 365 users. Let’s get started The Workbook Statistics is in the Proofing group of the Review tab. The Workbook Statistics gives a summary count of cells, formulas, charts, tables, PivotTables, […]

Continue reading