Friday, January 22, 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

How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

An Introduction to Excel Data Plumbing

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
Advertisement
Advertisement