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

If you use Microsoft Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher ...

A seasonal index is a way of measuring the seasonal variation -- that is, to measure the change that is due to seasonal changes in demand -- of a variable, typically sales. For example, a beachfront ...

Most of us know how to create a chart in Excel, but it’s the chart with a little something extra that often does the best job. For instance, suppose you’re charting product favorites by age group and ...

Each Excel workbook contains links to screencasts streamed from vimeo.com. All screencasts are aggregated into a Macroeconomics with Excel channel (which is initially organized in the order listed ...

Every time Ryan publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Editorial Note: Forbes Advisor may earn a commission on sales made from partner links on this page, but that doesn't affect our editors' opinions or evaluations. A Microsoft Excel spreadsheet is one ...

When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order. This behavior potentially creates irregular spacing with unpredictable formatting. If the ...