MS Excel not only has a number of formulae to get things done quickly but also is blessed with a wide range of visual data interpretation tools. One such feature is its ability to create charts. This article would deep dive into demonstrating one such chart with real-time examples for better understanding – the ‘Column …
Avatar is a great movie – A James Cameroon masterpiece! But what made it even better was the IMAX 3D experience. How about bringing the same magic to data visualization in Excel too? Yep! That’s very much doable & we are about to explore one such feature in this article – 3D Column Charts. We …
Very well known for its flexibility and data handling capability, the support rendered by MS Excel towards analysing data is truly remarkable. It contains a series of rows and columns into which information would be entered. This information would then be converted or analysed in accordance with the requirements in hand. But, ever wondered whether …
How Many Columns in MS Excel – Steps to Count Columns Read More »
There would be times at which one needs to verify whether the data available in a particular tabulation is also present in a different tabulation which sometimes might be in a different sheet. While one can switch between the sheets and verify each item one after the other, it defeats the sole purpose of using …
How to Compare Two Columns Using VLOOKUP in Excel? Read More »
Seeing things in two dimensions can bore you to death at times. A little bit of graphics take the same thing and turns it into a beautiful sight for your sore eyes. We are going to carry out one such thing moving forward. This article is dedicated to demonstrating the construction of a 3D Bar …
Peeps nowadays would remember playing Clash of Clans back in their school or college days, but way back in the ’90s when a calculator was the most advanced handheld digital device of that time, there was a game franchise that placed the seed for these strategic games years down the line. Those who have played …
Column charts go as far as comparing a couple of entities side by side, but what if one wants to compare multiple attributes of a subject in a study across the same 2-dimensional plane? Yep, you read that right – a 2-D-plane! MS Excel is equipped with just the feature that would help us in …
Now that we have covered the different ways of getting into ‘Paste Special’, we shall explore the different features in the ‘Paste Special’ pallete that can be leveraged when one ought to paste the items copied. For those who have not read our previous article, do have a look at it before proceeding further. In …
Overview of Paste Special in MS Excel [Part – 2] Read More »
We all might have used the CTRL+C (Copy) & CTRL+V (Paste) shortcuts the very first time we learn to operate in Windows OS. But have we really got into the depths to tap the fullest potential of the Paste function in MS Excel? In this article, we are going to explore the different possibilities that …
Overview of Paste Special in MS Excel [Part – 1] Read More »
When there is a need to compare the performance of the same entity across two different time periods along the horizontal axis, who you gonna call within Excel? The Clustered Bar Chart! Similar to those charts where the performance of a particular player or a team is compared across 2 different seasons or tournaments, clustered …