Unusual Way To Create Chart With Paste Special

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn some unusual method to create any chart. Let’s get started Sample Data In the caption below, we have simple data showing Account Managers and sales for each quarters. Create Empty Column Chart To create and empty column chart Select any cell outside the data  In the Charts group […]

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