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

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.

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Microsoft Excel’s Data Analysis Toolpak is an invaluable add-in for those who require complex statistical or engineering analyses. This powerful feature allows users to execute a variety of data ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Select the data type you want to add To use the Geography data feature, fill the sheet with the location names you need data of, and select them. Now, click on Data in the ribbon and select Geography.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.