If you think that the capabilities of Excel are just limited to calculating & getting stuff done with data, then they might really be in for a surprise. Excel offers a ton of visualization and data plotting tools for you to work with! In this article, we are going to see one such tool and …
Excel has numbers that run along from 1, all the way down to 10,48,576, but mind you, there are given for a reason – only to indicate the total numbers of rows in any sheet. Also, these numbers would also play a vital role in developing formulae to carry out any specific tasks in MS …
When it comes to basic arithmetical operations, these two go as far back as elementary education. One amongst them is addition, whilst the other is subtraction. We are going to look into the latter in this article and explore the ways of carrying it out using MS Excel. Also read: How to Add in Excel? …
Using a spreadsheet is all about working with numbers and in this article we are going to look into how to carry out one such arithmetic operation using MS Excel. Enter DIVISION! In this article, we are going to look into an example where we have the details of the products purchased on different dates …
Basic arithmetic lays the foundation to get moving further with any complex computations. One of the first arithmetic operations that we were introduced to in school would be Addition. Everyone would be remembering the ‘Two in the mind. One in the finger’ jingle when we were to add the numbers one and two. In this …
So, we have the data as tabulations, grouped into various rows & columns, but at times they turn out to be really messy in terms of spacing such as the one in the below image. Yeah, yeah, there are hashes for all the entries under column B for the dates, but no need for any …
Excel is all about analysis! It contains a series of rows and columns into which information would be entered and then they would be converted or analyzed against the required metrics. But, ever wondered whether these rows and columns in Excel have any limits? Do they ever go on and on when we add in …
When MS Excel is all about doing a vast range of operations using data, it does not undermine the features that it offers to handle texts. In terms of both formulae and commands, MS Excel is diversely capable of getting things going with textual data similar to numerical data. So, in this article, we shall …
When there are a number of columns with numerical data, say the price details of a few products sold on different days, for instance, it’s a common practice for anyone to want to know how much has been sold in terms of quantity & revenue. So, in this article, we are going to explore the …
At times, when we need to introduce a change in the dataset, formatting the cells, for instance, selecting only a few cells won’t be sufficient to apply these changes. The entire set of data is to be selected to apply the changes throughout. There might be a couple of ways to execute this & we …