The Closing is Coming

I've mentioned a few times over the past two weeks that I'm now accepting students for my Excel Macros Master Class courses, and that the registration doors are now open.

The doors don't stay open forever, however. In fact, they will close in just a few more days, at the end of the day on Thursday (October 18). It's not too late to join a class, but you'll want to act soon, as time is running out.

By the way, if you want to see a great overview of what is in the courses, the best place is in these special videos I prepared:

    https://MacrosMasterClass.com/touring-the-courses/

As you can tell, one of the videos on this page is for the Beginning Excel Macros Master Class and the other is for the Advanced Excel Macros Master Class. The videos run through all the content in each course, highlighting what you can expect to find in each of them.

Since the course deadline is approaching, I'll send you one more reminder on Wednesday, the day before the actual "closing."

In the meantime, I hope you enjoy the tips in this week's issue of the newsletter!

—Allen
     

ExcelTips (ribbon) for 13 October 2018

Worksheets
Automatically Renaming Worksheets

Excel allows you to easily add and remove worksheets from a workbook. You may want a way to automatically rename all of your worksheets as you do this addition or removal. This tip explores several approaches to meeting this desire.

Read this tip »

(Thanks to Steve Aprahamian, Harold Druss, Tom Jenkins, Tommy Coil, Kiani Hesam, Bob Beechey, Piers Morgan-Harvey, and Wayne Edmondson for contributing to this tip.)

 
Charts and charting
Creating Sparklines

Want a cool, small chart to show what your data is doing? You need a sparkline, discussed in this tip.

Read this tip »

 
Add UserForms to Your Macros

Still relying on message boxes and input boxes to communicate with the users of your macros? Take your macros to the next level by creating your own UserForms. Discover how in the information-packed Creating VBA UserForms course. Low cost; great instruction--check it out today!

 
Files
Specifying the Number of MRU Files

MRU (most recently used) files can be a great help when you work with a given set of common workbooks. Excel allows you to easily adjust the number of MRU files it tracks for you.

Read this tip »

 
Worksheet functions
Median of Selected Numbers

Need to find a median value in a series of values? It's easy with the MEDIAN function. What isn't as easy is to derive the median from only a subset of the values based upon some criterion. Here's an easy way to approach the task.

Read this tip »

 
Formulas
Filling Cells with Decreasing Cell References

AutoFill is a great feature. It can detect patterns and adjust cell contents as you drag a selection on-screen. It doesn't work in all instances, however, such as when you want the values in formulas to actually decrease. Here's why, along with what you can do about it.

Read this tip »

 
Macros extend Excel
Pulling Cell Names into VBA

Excel allows you to define names that can refer either to ranges of cells or to constant information, such as formulas. If you have quite a few names in a workbook, you may want to derive a list of those names. The macro in this tip allows you to pull them all and place them in a worksheet where you can continue to work with them.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Putting the Last Saved Date in a Cell

Is there a formula I can use to put into a cell the date the workbook was last saved? Regardless if I open the workbook every day, I only want the date updated every time I choose to save.
—Kimberly Spalding (provide an answer for this Help Wanted question)

 
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