Tuesday, December 10, 2024
Are you tired of using Excel tables in your reports? Here's a way to add some class to them while learning more about little-known features of Excel.

Add Class to Your Reports with Excel Drawing Objects

0
In my (out of print) book,Dashboard Reporting With Excel, I recommended that you "steal" ideas for Excel reports from business magazines. I recently had another...
Here's how to define a background image for an entire worksheet or for a chart. And also, here's how to fake having a background image for a range.

How to Add Background Images in Excel

0
"How can I place a background image and still use the cells that the image covers?" -- Sally M. Sally, You can do this, but possibly...
Excel's Linked Picture feature (Camera tool) allows us to position a table in reports while ignoring the row and column settings in the report worksheet.

Ideas about Using Excel’s Linked-Picture (Camera) Tool

Of all the Excel features that users don’t use very often, Excel's Linked Picture tool probably is the most powerful. This tool, known in...
Summary tables in Excel reports have always been difficult to format so they don't LOOK like Excel tables. Here's one extreme method you might want to try.

Add Some Style to Your Tables in Excel Reports

Excel tables in reports have always been difficult for me to format professionally. So every once in a while, I experiment with them. The two...
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

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...

Latest Articles

Excel Flowbook Revolution

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,...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

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

0
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