Business magazines and newspapers usually are an excellent place to find great ideas for Excel charts. But here's a Wall Street Journal chart figure that offers lessons about what NOT to do!

Bad Chart! Bad, Bad Chart!

Charting Methods Charley Kyd - 0
(Download my improved Excel version of the bad charts show below.) The Wall Street Journal usually publishes excellent charts. And Excel users usually can duplicate those professional-quality...
Excel's dynamic range names give your formulas the power to adapt automatically in response to changes in your data or settings. Here's how to set them up.

How to Create and Use Dynamic Range Names in Excel

Downloads Charley Kyd - 0
(Download the example workbooks.) We Excel users often refer to ranges that need to move or expand in future versions of our reports. For example: ...
The Monte Carlo method allows you to forecast performance using probability distributions for your assumptions. And Data Tables provide a quick and easy way to implement the Monte Carlo method. Here's how to do it.

How to Create Monte Carlo Models and Forecasts Using Excel Data Tables

Business Statistics Charley Kyd - 0
(Download the workbook.) (This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...
You can use probability distributions to manage the uncertainty about your assumptions when you create simulations in Excel. Here's how.

How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts

Business Statistics Charley Kyd - 0
(This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...
You can uncover hidden trends by charting the ratio of each month's performance to the same month one year earlier.

Introducing the Power of Year-Over-Year Performance Charts in Excel

Analytical Charting Charley Kyd - 0
The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily. That’s the attraction of charts, of course....
Economic analysts use the Beveridge Curve to analyze the labor market through business cycles. You can use it to analyze how any two measures—internal or external—correspond over time.

Beveridge-Chart Trend Analysis with Excel

Economic Indicators Charley Kyd - 0
Here's a great way to discover new insights in your company's data: Always watch for new methods of looking at data...even if you care nothing...
If you're charting only your raw business data, you're missing many opportunities to give your readers useful business insight. Here are three simple tricks that will help you to turn your ordinary charts into analytical ones with much greater insight.

Three Simple Tricks to Improve Analytical Charting in Excel

Analytical Charting Charley Kyd - 0
For years, my Excel charts of trends used a simple idea: To gain insights about periodic data, just chart it. What else was there to...
Three More Simple Tricks to Improve Excel Charts for Business

Three More Simple Tricks to Improve Excel Charts for Business

Analytical Charting Charley Kyd - 0
In 3 Simple Tricks to Improve Analytical Charting in Excel, I showed you how to shift time periods, index your data, and chart your rate...
Excel offers two powerful worksheet functions that can return the data you need from any type of worksheet database. One is more powerful, but calculates slowly. The other is nearly as powerful, but much faster.

The Two Functions You MUST Know to Return Values from Excel Tables

Data Management Charley Kyd - 0
“Export to Excel is the 3rd most common button in BI apps…after OK and Cancel.” —Rob Collie, one of the founding engineers behind PowerPivot at...
In one SUMPRODUCT formula, you can summarize any number of specific accounts in a list. This makes it easy to summarize financial data from an accounting trial balance.

How to Create Summarized Financial Statements with SUMIFS Criteria Lists

Aggregation Functions Charley Kyd - 0
In How to Use SUMIFS with Criteria Lists, Summarizing Sales, I explained how to use the SUMPRODUCT function with SUMIFS to return the sum of...
1...181920...22Page 19 of 22