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.
Machines & humans have gotten along with each other over time. But here’s the catch! Humans don’t do well when it comes to recording data & machines don’t do well in taking decisions based on the inferences from recorded data (How comfy would you be when travelling in a self-driving car with no control over …
How to Import Data from Text file into MS Excel? Read More »
Desperate times need desperate measures. One such situation is when the data that one wants to analyse is available not in a spreadsheet but in a webpage! We have previously talked about importing data from an MS Access database into MS Excel. But in this article, we would be going the extra mile to get …
MS Excel is all about the position of the data with respect to rows & columns into which they were keyed in. Both the rows & columns are identified by the continuous numbering downwards & the alphabets going sideways respectively. So the position of any given data within an Excel spreadsheet is depicted only by …
Well, there ain’t a gold standard template in which all the data would be put in, harmonized & made available. So, you may need to extract data from all the possible sources rather than wait for the data to be available in an Excel-compatible format. In this article, we shall deep dive into the steps …
How to Import Data from MS Access into MS Excel? Read More »
Don’t compare apples with oranges! A common saying that we all would have come across at least once. When one tends to carry out a comparison, one ought to make sure that both the entities that are being compared are placed on a level playing field. The same logic also holds good when it comes …
The most underrated entity in any dataset would be the ‘Serial Number’. Imagine a life without S.No! It would be a nightmare, ain’t it? The ordering of the entries is tossed off into turmoil without this simple measure in place. All hell breaks loose if it weren’t for that S.No! One can easily type in …
Data can be handed over to us from any medium & so it is not necessary that all the entries available in the dataset are necessary for analysis. In some cases, there may be some erroneous entries that have come as a part of the bulk data. What if there are a set of rows …
Working with MS Excel, it is not always the case that one shall get data in the form of spreadsheets alone. There are other formats in which the source data might be provided such as the Comma Separated Values (CSV) or Text Delimited (TXT) format. Also read: How to Count Unique Values in MS Excel? …
Data is always not refined. This is the one thing that would always give migraines to those who work with tonnes of data. Getting down to those which really matter can be quite tedious & this article is going to suggest ways to tackle one such situation. In this article, we will explore the steps …
Everything we humans look into, we shall name. It’s near impossible for us to comprehend something without tagging a name to it. There has got to be a name for everything! It has been that way since time immemorial & it will be the same years into the future. How are we even going to …