1350 results found. Filter results

• ### How to Use the QUARTILE.EXC and QUARTILE.INC Funct

The QUARTILE.EXC and QUARTILE.INC functions in Excel determine the array value at a specified quartile in an array—...

In Excel

• ### How to Choose the Right Chart Type for Excel Data

What many people don’t realize is that you can make only five data comparisons in Excel charts. And if you want to be picky, there are only four...

In Excel

• ### Avoid 3-D Charts for Excel Data Analysis

In general, and perhaps contrary to the wishes of the Microsoft marketing people, you really want to avoid three-dimensi...

In Excel

• ### How to Use Functions to Find Values in Excel

Excel provides functions for finding the largest or smallest values in an Excel data set. These functions include MAX, MAXA, MIN, MINA, LARGE and SMAL...

In Excel

• ### How to Filter Pivot Chart Data in Excel

You can segregate data in Excel pivot charts by putting information on different charts. For example, if you drag the Mo...

In Excel

• ### How to Use the PERCENTRANK.EXC and PERCENTRANK.INC

The PERCENTRANK.EXC and PERCENTRANK.INC functions in Excel determine the percentage rank, or percentile, of a value in a...

In Excel

• ### How to Use the PROB Function in Excel

The PROB function in Excel uses a set of values and associated probabilities to calculate the probability that a variabl...

In Excel

• ### Look at Excel Data from Many Angles

Cross-tabulations in Excel are important, powerful tools. Here’s a quick example: Assume that in some future century that you’re the pleni...

In Excel

• ### How to Use the RANK, RANK.AVG, and RANK.EQ Functio

Excel provides functions for finding values with a particular rank and for ranking values within the data set. The RANK...

In Excel

• ### Chart Data Tables and Excel Pivot Charts

A data table just shows the plotted values in a table and adds the table to the chart. A data table might make sense for...

In Excel