Discover what a log-normal distribution is, its financial applications, and how to calculate it, including using Excel for ...

Using Excel is a great way to perform what-if analysis, and formulas generating random values that make sense for your forecasting help present a variety of outcomes for analysis.

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.