Although Excel's FREQUENCY function was designed to calculate frequency distributions, you also can use the SUM-IF, SUMPRODUCT, INDEX-FREQUENCY, and COUNTIFS functions. Here's a summary of the methods and your options.

Five Ways to Calculate Frequency Distributions in Excel

Charting Methods Charley Kyd - 0
Walt captures blood-pressure readings and wants to find how often the readings fall into various ranges of values. This is a common need for a...
Many Excel reports leave managers knowing less than they did before. Here are five best practices to follow in planning your management reports.

Five Best Practices in Your Excel Reporting Strategies

Error Reduction Charley Kyd - 0
Most Excel reports, forecasts, and analyses I've seen in my career could serve as excellent examples of what NOT to do in Excel. These reports...

First Excel Dashboard Report Showing Financial Data for a Public Company

Charting Methods Charley Kyd - 0
The figure below shows the first Excel dashboard to display data about a public company. Although this report looks quite similar to today's reports,...
Here's how to set up Future- and Present-Value formulas that allow compounding by using an interest rate and referencing cash flows and their dates.

Find Future and Present Values from Scheduled Cash Flows in Excel

Financial Analysis Charley Kyd - 0
"I would like a Future Value command similar to the XIRR and XNPV functions, which allow compounding by using an interest rate and referencing...
Excel's SUMIFS and SUMPRODUCT functions both can return the sum of a column of data under specified conditions. But which calculates more quickly?

Excel’s SUMIFS or SUMPRODUCT…Which is faster?

Aggregation Functions Charley Kyd - 0
Today, I learned about an Excel reporting need that looks something like this: There’ll be about 150,000 rows of data maintained in an Excel database. ...
Excel's CLEAN function does more than Excel's help topic says. In fact, it cleans all but two nonprinting characters in the ASCII and Unicode character sets. Here's how to deal with nonprinting characters.

Excel’s CLEAN Function is More Powerful Than You Think

Formulas & Functions Charley Kyd - 0
The Excel 2016 help file for the CLEAN function provides more information than earlier versions: “Removes all nonprintable characters from text. Use CLEAN on text imported...
Predictive analytics uses statistics, modeling, machine learning, and other methods to analyze current data to make predictions about future.

Excel’s Advantages for Predictive Analytics

Excel Strategies Charley Kyd - 0
Predictive Analytics is one of 4 Technologies That Are Reshaping Business Intelligence, according to an article in Information Week. “Predictive analytics,” the article said, “is a white-hot...
Excel can be the key component of a powerful and inexpensive Business Intelligence (BI) system. Here are some ideas to get you started.

Excel Is Great for Business Intelligence!

Data Visualization Charley Kyd - 0
With the right access to data, Excel can become an outstanding Business Intelligence (BI) system. Business Intelligence (BI) is the systematic use of information about...
An article in the Wall Street Journal about babies born during the winter months offers some great advice about charts for Excel users in business.

Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ

Analytical Charting Charley Kyd - 0
A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
The Rule of 72 is a guesstimate of how long it will take an investment at a specific interest rate to double in value. But how accurate is it? Ask Excel.

Excel and the Rule of 72

Financial Analysis Charley Kyd - 0
I recently learned that my son—who's an avid amateur investor—had never heard of the Rule of 72. The rule of 72, I texted him, says...
1...141516...22Page 15 of 22