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

Have you ever found yourself frustrated by Excel’s inability to handle ties in rankings without creating gaps in the sequence? Imagine analyzing employee salaries or sales performance, only to ...

Microsoft Excel can present two series of data points together on the horizontal axis, but if the number scale for each series dramatically differs, the data will not be readable. Using a two-sided ...

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