Five Really Useful Excel Keyboard Shortcuts
Most Excel users use some of Excel's shortcuts frequently, like F9, Ctrl + C and Ctrl + V.
However, Excel offers other shortcuts that are nearly as useful....
Professional Quality Excel Chart Labels, Legends, and Colors
The following Excel chart shows that Excel really CAN generate professional-quality chart figures.
Here are some general strategies to consider…
1. Set up your data-plumbing correctly....
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas:
Simple...
Excel’s Five Annuity Functions
“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
Do Your Excel Reports Document Performance? Or Communicate It?
When you report or analyze performance in Excel, you need to ask yourself a key question...
Am I documenting results, or communicating them?
There’s a huge...
Three Simple Tricks to Improve Analytical Charting in Excel
For years, my Excel charts of trends used a simple idea: To gain insights about periodic data, just chart it.
What else was there to...
How to Create Dynamic Chart Legends in Excel
When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
Interactive Excel Reporting
Several years ago, a reader asked me to help him with an Excel-reporting challenge that might sound familiar.
His challenge, he said, was that he...
How to Report Top and Bottom Results Using Dynamic Arrays in Excel
In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...
The First Excel Dashboard Report
The Excel dashboard below is from the first-ever package of dashboard reports, which I created to show Excel's power to a client...