To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee ...

Nick Lioudis is a writer, multimedia professional, consultant, and content manager for Bread. He has also spent 10+ years as a journalist. Thomas J Catalano is a CFP and Registered Investment Adviser ...

This post explains how to calculate Weighted Average in Excel with percentages. In a standard arithmetic average where the sum of values is divided by the number of values, each data value is treated ...

Too many financial decisions are made without factoring in the time value of money. Whether providing financial planning advice related to a client’s retirement, advising a client about a business ...

A TechRepublic member wrote for advice on calculating the years, months, and days elapsed between two dates. This tutorial explains the solution provided by TechRepublic contributor Jeff Davis. A ...

Q. Is there an easy way to calculate how long in years and months the employees have been working for my company? A. Excel can do that, as long as you’ve listed all the employees in a database. If so, ...

While Excel is a powerful tool for data analysis, the built-in functions can feel limiting at times. When you work with complex calculations or large datasets, or perhaps want to create more ...

Percentage Formula: Percentages are a fundamental concept in maths, used frequently in daily life. It represents parts of a whole as fractions of 100. They're symbolised by the "%" symbol.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...