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 (menu) for 13 October 2018

Filtering
Removing Duplicates Based on a Partial Match

Some types of data may have certain fields that contain partially identical information. In such cases you may want to delete cells where those matches occur. Here's some ideas on how to approach the problem.

Read this tip »

 
Comments
Counting Comments in a Worksheet

Need to know how many comments are in a worksheet? You can figure out the count manually, or you can apply the handy macro presented in this tip.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Dates and times
Backwards Date Parsing

Enter information into a worksheet, and you come to anticipate (and count on) how Excel will interpret that information and store it in the worksheet. If you suddenly find that Excel isn't parsing your date entries correctly, there are two possibilities you should check out right away.

Read this tip »

 
Powerful spreadsheets
Trimming Spaces from Strings

Need to get rid of extraneous spaces before or after the text in a string? VBA provides three different functions you can use to make the removal quick and easy.

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