In Excel Tables, you can filter on any two conditions in a column. But by using the SUMPRODUCT function, you can filter on any number of items in a list.

How to Use SUMPRODUCT in an Excel Table to Filter Any Number of Items

Data Management Charley Kyd - 0
Excel 2007 introduced the powerful Table feature, as illustrated below. Tables allow you to sort and filter your data easily. However, the filter capability has...
You can treat text files as relational tables. You can join them by common fields. Query them using SQL. And use the queries with PivotTables. Here's how.

Use MS Query with Text Files for Dynamic Excel Reporting

Data Management Charley Kyd - 0
(Charley's Note: This article is very out of date. I'll update it as quickly as I can.) In the article, Use MS Query to Treat...
Excel ranges can work like relational tables. You can join them by common fields. Query them with SQL. And use queries in PivotTables. Here's how.

Use MS Query to Treat Excel as a Relational Data Source

Data Management Charley Kyd - 0
Charley's Note: Because MS Query hasn't changed much since Marty Ryerson wrote this article years ago, his instructions are still quite accurate. I have,...
We can't push around numbers all the time with Excel. Sometimes, we just need to goof off. So here are some examples of business cartoons I drew in Excel.

Use Excel’s Drawing Tools to Create Your Own Cartoons

Excel's Graphic Tools Charley Kyd - 0
More than ten years ago, I went on a family trip. I didn't take my laptop, because my wife told me to leave the...
If you track Accounts Receivable the way most companies do—with Days Sales Outstanding in Receivables (DSO)—you probably know less about your receivables than you think. There's a better way, which also can improve your cash flow forecasts.

Use Excel to Fix Your Broken AR Measure of Days Sales Outstanding in Receivables

Accounting & Finance Charley Kyd - 0
During tough economic times it's particularly important to manage your Accounts Receivable balance carefully. Unfortunately, the traditional way to measure AR performance is badly...
Excel's FREQUENCY function was first created to calculate frequency distribution tables, which are needed for charting histograms. But the COUNTIFS function offers more power, and it's easier to use.

Use COUNTIFS, not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms

Charting Methods Charley Kyd - 0
Because the Texas and California governors have been bickering over the Texan's attempt to poach California employers, I got curious about the distribution of...
A manager needs to assign employee color codes to various tasks they perform for customers. Here's one way to do it with Excel's conditional formatting.

Use Conditional Formatting with Formulas to Manage Employee Tasks

Conditional Formatting Charley Kyd - 0
"I have a simple Excel sheet with a list of to-do items down the left hand column. I have clients along the top. For...
To improve forecasting, you can use Excel charts to track how quickly new products, stores, sales people, and so on ramp up their performance compared with similar launches in the past.

Use Common-Age Excel Charts to Compare and Forecast Performance for the Same Number of...

Charting Methods Charley Kyd - 0
In the early lives of new products or new stores, managers often are anxious to track and improve sales performance. To do so, it's...
Benford's Law reveals an amazing characteristic of data. Not only does it help to identify fraud, it could help you to improve budgets and forecasts.

Use Benford’s Law & Charts in Excel to Improve Business Planning

Analytical Methods Charley Kyd - 0
Unless you're a public accountant, you probably haven't experimented with Benford's Law. Auditors sometimes use this fascinating statistical insight to uncover fraudulent accounting data. But it might reveal...
Now that you've calculated your cross correlations—that is, your time-shifted correlations—here's how to chart them professionally.

Find Leading Indicators Using Automated Cross Correlations in Excel, Part 2

Analytical Charting Charley Kyd - 0
In Part 1 of this discussion about automated cross correlations, I explained how to set up  the cross-correlation Data Table shown below, in columns...
1...678...22Page 7 of 22