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 …
Ever delegated the task of compiling data to someone and got it back with some misplaced entries? It would be needed to shift some entries down in order to insert the correct data at the correct place. There might be a couple of ways to go around that & we would cover both in course …
We would have successfully tabulated a list of data under a range of column headers. But, there might be instances when we would be needing to move certain rows from the position where they are to some other place within the active sheet. Not all the time, but sometimes we’d face this situation and in …
Want to transfer some data onto a specific location? Want to give references to build a formula? Want to turn a list of data into a Table? Want to generate a non-verbal interpretation of the available data? It is an obvious need to select cells when we need to start with any operation that would …
Have a spreadsheet full of data? There may be times when we’d desperately need to conceal certain entries or contents amongst the available data. This can be due to some calculations being carried out in that portion or irrelevancy of interest towards the data that is needed to be looked into. So, knowing of a …
What use is it if we have a sheet full of formulae in MS Excel, but are not able to sneak a peek all at once? What’s all with the secrecy of these formulae hiding behind the textual or the numerical results which they generate? In this article, we shall get down to it and …
We all have a spreadsheet filled with data and would eventually end up analyzing them. As an essential pre-requisite, we would be selecting the desired data to get started. But, what if we select more than what is required or what if we need to leave a specific portion of cells while selecting a row …