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
Play Axis Dynamic Slicer
Welcome to Excel Jet Consult blog post. In this video tutorial, I demonstrated how to use the Power BI Play Axis Dynamic Slicer custom video.
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