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. Yarilet Perez is an experienced multimedia journalist and ...

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 ...

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, ...

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: ...