Advanced: SUMPRODUCT with MID, LEFT & FIND Text Functions

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use advanced method to sum values using combination of MID, LEFT & FIND Text Functions. Let’s get started Sample Data In the caption below, we have sample data We want calculate the Total for Account Manager whose First Name is David and Country of operation is Nigeria. Based […]

Continue reading

Activate Developer Tab

Welcome to Excel Jet Consul. In this tutorial, we want to see how to activate the Developer tab. Let’s get started To activate the developer tab, right-click on any of the tabs such as Home, Insert or any other Select Customize the Ribbon In the Excel Options dialogue box, check Developer Click OK. We should be able to see the […]

Continue reading

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