How to Use Conditional-Format Formulas to Change Background Colors
"I have an Excel table with a column that will be filled with 'yes' or 'no. When a user enters 'yes' to a cell,...
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
Simple...
The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis
(Note: I wrote this before Microsoft introduced Excel Tables or SUMIFS. This post is scheduled for an update.)
Excel users often need to summarize data...
How to Select Values from a Validation List in Excel
Excel provides two ways to select a value from a list of values. I often use this feature in interactive Excel reports to select dates,...
How to Create and Use Dynamic Range Names in Excel
(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:
...
How to Report Periodic Data from Excel Databases
Sometimes, the best way to solve your Excel problem is to redesign your workbook.
Ron G. brought this thought to mind with a recent question....
How to Create Cycle Plots in Excel to Chart Seasonal Sales Data
If your company's sales are seasonable, you've probably seen a chart that looks something like the first one below.
This Excel chart shows the continuous...
How to Set Up a Pivot Table as an Excel-Friendly Database
You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs).
In...
How to Save Multiple Excel Reports to One PDF File
A great way to distribute your Excel reports is to save them in a PDF file and then distribute the file.
People who receive your...
The Two Functions You MUST Know to Return Values from Excel Tables
“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...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement