One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as a complicated collection of data. For instance, you ...

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

Microsoft Office Excel contains a data analysis add-in that allows to to perform a Fourier analysis of a series of numbers. So named for the French mathematician who developed the analytic technique ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

How to turn complex formulas into easy-to-use custom functions using LAMBDA() in Excel Your email has been sent LAMBDA functions are new to Microsoft Excel. With LAMBDA functions, you can turn a ...

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.