### Use Excel PMT Formula to Determine Loan Interest

We start out with a basic premise that we borrow \$10,000.00 (D1). Our interest is 3.0% (D2) and the monthly payments are forty-eight months (D3).

### Use VLOOKUP to Find Values from an Excel® Table

VLOOKUP. You’ve heard about it – but what does it do? Vlookup searches a list for a value in the left most column and retrieves the corresponding value from other columns in that row. As an Excel user, what does that mean for you?

### Eliminate Your Frustration with Excel Time Formulas!

Working with time in Excel can be a problem.  Have you ever calculated how long a person was at work, and then wanted to multiply that time by an hourly wage?  It isn’t difficult to fail miserably! But, if you know the trick, Excel time formulas are easy.

### Tips for Taking on VBA & Excel Macros, Part 2

Last week, the feature was for the advanced Excel users who are not programmers and new to VBA.  This post continues that theme.  The Immediate Window Is Your Friend The Immediate Window is where you can test code against current data and see the results. Use this to make sure your macro really does what…

### Tips for Taking on VBA & Excel Macros

For the advanced Excel users who are not programmers and new to VBA It’s inevitable. If you are an Excel power user, you will reach a point where formulas and the built-in Macro Recorder just aren’t enough. When that happens, VBA (Visual Basic for Applications) macros may be just the thing you need.

### Excel Chart Options: Adding Titles

Charts provide an easy-to-assemble but clear and persuasive illustration of your data. Excel offers a variety of charts in both two-dimensional and three-dimensional formats. Default features, however, may not provide the look and include all of the data you wish to be displayed. One common functional need of a chart is a chart title.

### How to Use the IF Formula in Excel, Part 2

As amazing as the IF formula is alone, it really comes into its own when used in groups. In our last post, we talked about how to apply discounts to customer quotes based on a set of criteria being met. This week we’ll introduce you to nested IF functions. Nested IF formulas help you calculate…

### How to Use the IF Formula in Excel, Part 1

Sometimes you need your data to tell you more. The IF formula as a function gives your data a voice and turns raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want to quickly calculate…

### Excel PivotTable Percentage: Which Customers Are Costing You A Fortune?

Let’s suppose you have sales by state, and each state belongs to a sales region. What percentage of your sales come from each region? First, Set Up Your PivotTable