The Time to Act is Now!

If you haven't taken the opportunity to check out my PivotTables for the Faint of Heart course, you really should do so. Scores of people have already signed up and are discovering new ways to analyze their Excel data. (They are learning not just about PivotTables, but also about slicers, timelines, and PivotCharts--it's all in this single course!)

I'm still accepting new students through this coming Thursday (April 18), but time is racing by quickly. If you want to expand what you can do with Excel, now is the time to act. You can find out full information on this high-quality, value-packed course here:

     https://usingoffice.com/pivottables/

I hope to see you in the course!

—Allen
     

ExcelTips (menu) for 13 April 2024
Formulas
Finding the Date Associated with a Negative Value

When working with data taken from the real world, you often have to determine which certain conditions were met, such as when a particular reading dropped below a certain value. This tip examines how you can easily tell the date on which a reading drops below zero.

Read this tip »

 
Powerful spreadsheets
Status Bar Summing No Longer Available

When you select a range of cells, Excel normally displays the sum of those selected cells on the status bar. If the sum no longer appears, here's how you can get it back.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Powerful spreadsheets
Converting from Relative to Absolute

Addresses used in a formula can be either relative or absolute. If you need to switch between the two types of addressing, here's a convenient way to do it.

Read this tip »

 
Creating macros
Opening a Workbook but Disabling Macros

Macros that run automatically when you open or close a workbook are quite helpful. You may not want them to run, however, when you open or close a workbook from within another workbook's macro. This tip explains how you can stop a particular macro (AutoClose) from running when accessing a workbook in this manner.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450