Friday, September 24, 2021
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

Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
Advertisement
Advertisement