Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
“Compound interest is the eighth wonder of the world. He who understands it, earns it … he who doesn’t … pays it”. – Albert Einstein What is Compound Interest? Let me take a simple example to explain it. Suppose you invest USD 1000 in a bank account that promises to give you 10% return at the end of …
One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?” And I got one last week too. So I decided to create a tutorial and a video on it. It will save me some time and help the readers too. Below is a video …
I recently got an email from one of my readers with an interesting query on using drop-down lists in Excel. He asked me if it was possible to have a drop-down list that shows numbers based on the two specified numbers. Something as shown below: Note that the drop-down start from the number in column …
Excel is used extensively for statistics and data analysis. Standard deviation is something that is used quite often in statistical calculations. In this tutorial, I will show you how to calculate the standard deviation in Excel (using simple formulas) But before getting into, let me quickly give you a brief overview of what standard deviation …
When you create/record a macro in a workbook in Excel, it can only be used in that workbook. But what if you have a list of useful Excel macros that you want to use in all the workbooks? In such a case, it’s a good idea to save these in your Personal Macro Workbook. Doing this …
Using Excel Macros can speed up work and save you a lot of time. One way of getting the VBA code is to record the macro and take the code it generates. However, that code by macro recorder is often full of code that is not really needed. Also macro recorder has some limitations. So …
Excel has some powerful functions to calculate the number of days between two dates in Excel. These are especially useful when you’re creating Gantt charts or timelines for a proposal/project. In this tutorial, you’ll learn how to calculate the number of days between two dates (in various scenarios): Calculating the Total Number of Days Between …
When I get a data file from a client/colleague or I download it from a database, I do some basic checks on the data. I do this to make sure there are no missing data points, errors or duplicates that may lead to issues later. One such check is to find and highlight blank cells …
Excel has many inbuilt features that can save you a lot of your time. In this infographic, I am sharing my top five Excel features that are easy to use and save me tons of time almost every day. 5 Time-Saving Excel Features [INFOGRAPHIC] Use the code below to share this infographic on your site <a …
©trumpexcel.com – Free Online Excel Training
