Sunday, October 25, 2020
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

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
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...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement