Track Dynamic Data with VBA or with Iterative Calculations
"My A1 cell changes value every minute because it imports data from a DDE server. To keep historical data, I would like to list...
Save Time with Excel Range Selections
One of the big differences between early-stage Excel users and gurus is that gurus can do simple things in Excel much more quickly than...
How to Set Up a Data-Validation List Box in Excel
Often, we need to set up a list box in Excel, a sorted list that allows us to choose an item from an Excel...
How to Find and Use Excel’s Best Hidden Features
Excel has many outstanding hidden features. Here are a few that I use frequently…
In Excel 2013 and above, when you close Excel's last...
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