Tuesday, April 13, 2021
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...
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

Using Excel's LET, SORTBY, and SEQUENCE functions, and dynamic arrays, you easily can list any number of top and bottom results from a Table.

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 LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

How to Use Excel’s LET Function

In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
Advertisement
Advertisement