Select Page

## Calculate Your Loan Payments In No Time With Excel's PMT Function

Excel is an amazing tool for financial tasks, and calculating loan payments is no exception. The PMT function (sounds a lot like payment, right?) is often essential to investment, valuation, and decision making processes. If you are dealing with capital loans like...

## 10 Most Useful Formulas in Financial Modeling

Excel is the perfect tool for financial modeling. Many organizations can efficiently create and publish their models using only this tool. It’s no surprise Excel offers a ton of formulas that can handle almost any financial operation. In this article, we’re going to...

## Manage Tasks Better by Visualizing the Data in Gantt Chart

What is a Gantt Chart? Gantt charts are widely used in managing resources, operations, production, and other fields. The start and end times of each item is portrayed using the X axis scale and the bar length. Thanks to the way this chart is structured, you can see...

## Transforming Data with the CONCATENATE function in Excel

The data we collect in Excel spreadsheets are often unorganized and need to be restructured before using in reports or other calculations. When capturing first and last names, product IDs, or other properties, data collection tools can have different inputs for all...

## Comparison of VLOOKUP, HLOOKUP, and LOOKUP

There’s various functions and combinations of functions that can be used to lookup data in Excel. In this article, we compare the three common formulas used for this job, LOOKUP, VLOOKUP, and HLOOKUP.   VLOOKUP & HLOOKUP The famous VLOOKUP is widely...

## Number Formatting in Excel - All You Need to Know

If you used Excel in any shape or form, there is a pretty good chance that you’ve used the formatting and number formatting features. Formatting options like number, currency, percentage, date and time values are easily accessible to users. However, that’s not all...

## How to Use Logic Statements in Excel: IF – AND – OR – NOT

The beauty of Excel lies in its flexibility to create pretty much any mathematical model with little effort. Logic gates can be established within a table, chart, or any other spreadsheet element to dissect data and results. This gives Excel users the ability to...

## INDEX & MATCH: A Better Way to Look Up Data

VLOOKUP and HLOOKUP are the go-to functions for most Excel users to look up data in a table. However, there is an alternative to this function that can do the same job, with added benefits. It’s the INDEX and MATCH combo. Using these two formulas in conjunction can...

## Using SUMPRODUCT to Do Your Taxes

It’s that time of the year! Of course there are all kinds of tools out there you can use to calculate and submit your taxes for the last year, but it’s always a good idea to double check everything and if you prefer to do everything by hand, you might find this guide...