Microsoft Excel is one of the most popular software across computer users. It’s used by everyone and we can store different types of data in Excel spreadsheets.
The power of excel is unleashed when we use its formulas, graphing tools, pivot tables, and macros using Visual Basic.
Here at QuickExcel, we provide tips and tricks to use Excel with ease and become an advanced user.
Things don’t really happen, the way we want them to. The same holds true for MS Excel too where there can be an unprecedented turn out of events even with the slightest change. Additional spaces within the contents of the cell are a real pain! They find their way in when data is being downloaded …
Appearances are often deceptive! It is true in the case of MS Excel too where numbers would wear the disguise of text. The implications can be brutal since we would be looking around to find out why everything has gone haywire, especially when formulae are involved. So, in this article, we would be exploring the …
All the rows and columns in the spreadsheet not only contain data in form of text or numbers, but at times we would be needing to play around with colours to make them more appealing visually. So, that leaves us wondering whether we’d be able to perform some computations using these colours & the answer …
Spreadsheets are the medium to pile up tonnes of data. But for what use the data might be if we cannot interpret them to deduce some meaningful inferences? That’s where the most needed in-built function of MS Excel kicks in! – The FORMULA. In this article, we would be looking into the techniques on how …
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 …