Wednesday, May 31, 2023
Most Excel gurus can do simple things in worksheets more quickly than early-stage Excel users can. Here are some time-saving ways to get started.

Save Time with Excel Range Selections

One of the big differences between early-stage Excel users and gurus is that gurus can do simple things in Excel much more quickly than...
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...
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Here's the second of two methods.

How to Delete Blank or Unneeded Rows, Method 2

Data copied from a web site or imported from a variety of sources often include irrelevant rows of data. For example, the only way to...
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way.

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

Latest Articles

Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

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