Friday, July 1, 2022
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

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

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

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

Latest Articles

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...
Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...
Your data can contain many important, hidden patterns. But simple transformations in Excel can help to reveal them—as this example illustrates.

Simple Transformations Can Reveal Hidden Patterns in Your Data

Excel users have at least two significant advantages over business professionals who rely on other analytical and reporting tools. First advantage: We Excel users can...
Advertisement