# Trump Excel Blog

trumpexcel.com
TrumpExcel provides online training on Microsoft Excel. Here you can find easy how-to tutorials and videos on various topics such as Dashboard, Pivot Table, Formulas, Data analysis, Charting, and VBA.

## Lookup The Second, The Third, Or The Nth Value In Excel

2017-07-06 02:23
Watch Video – Lookup the Second, the Third or the Nth Matching Value When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP an… Read More

## Use IFERROR With VLOOKUP To Get Rid Of #N/A Errors

2017-06-22 08:30
When using the VLOOKUP formula in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value. In this tutorial, I will show you di… Read More

## FREE Monthly & Yearly Excel Calendar Template (2017 And Beyond)

2017-06-20 08:30
I am a big fan of using Excel templates to plan and manage work. I regularly use to-do lists and calendars to plan my days in advance. In this post, I am sharing some useful Excel calendar t… Read More

## How To Calculate Compound Interest In Excel + FREE Calculator

2017-06-18 13:24
“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 In… Read More

## Highlight The Active Row And Column In A Data Range In Excel

2017-06-12 04:30
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… Read More

## Drop Down Lists To Show Numbers Between Two Specified Numbers

2017-06-08 04:30
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 o… Read More

## What Is Standard Deviation And How To Calculate It In Excel?

2017-06-05 10:43
Standard deviation is a commonly used statistic when analyzing data sets. A standard deviation value would tell you how much the dataset deviates from the mean of the data set. For example… Read More

## Excel Personal Macro Workbook | Save & Use Macros In All Workbooks

2017-05-29 08:23
When you create 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? &nbsp&hell…Read More

2017-05-17 13:38

## Using Excel PMT Function To Calculate Loan Payment Amount

2017-05-01 08:18
Excel PMT function is one of the many financial functions available in Excel. It helps you calculate the payment you need to make for a loan when you know the total loan amount, interes… Read More

Trump Excel

×