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
Sort Numeric Values in PivotTable in Two Ways
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to sort numeric values in PivotTable in two ways. Let’s get started In the caption below, we have data to work with First Method We want to sort the Sum of Total in Descending Oder in the first PivotTable Report Click on the Account Manager […]
Continue reading
Perform VLOOKUP with Multiple Lookup Values in Three Ways
Welcome to Excel Jet Consult. In this tutorial, we will learn how to perform VLOOKUP with multiple lookup values in three ways. Let’s get started In the caption below, we have a sample data to work with Note, we have list data validation in cells F2:H2. So, we want to return the Sales Total result for Abiola David with States […]
Continue reading
Full Pyramid Clustered Column Chart Shape
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to format our column chart using Full Pyramid shape. Let’s get started We have a sample data as seen in the caption below Create 3-D Column Chart The column shape where the full pyramid is embedded in 3-D Column and Bar Charts. Hence, we need […]
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
VLOOKUP VS. XLOOKUP
Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrate how to use the VLOOKUP and the new XLOOKUP. Enjoy the video
Continue reading
UNIQUE Dynamic Array Function
Welcome to Excel Jet Consult blog page. In this video, I demonstrated how to use the UNIQUE Dynamic Array function. Enjoy the video
Continue reading
Printer Setup using Excel VBA
Welcome to Excel Jet Consult blog post. In this short video tutorial, I demonstrated how to setup printer using Excel VBA. Enjoy the video
Continue reading