Going Crazy Crunching Numbers

Years ago, my job required "crunching numbers" in spreadsheets. It was tedious work, and it drove me crazy. Once I discovered how to work with macros, though, my entire outlook changed and I was able to whip through the tasks I needed to do in Excel every week. I told the story of how I was able to transform my use of Excel and the trajectory of my career in a short four-minute video you can find on YouTube.

This past Wednesday morning I threw open the doors to my Excel Macros Master Class courses and started accepting students. I only open the doors a couple of times each year. The last time I did so for the Beginning Excel Macros Master Class was six months ago. It was even longer for the Advanced Excel Macros Master Class; the last time I accepted students for that course was two years ago!

Regardless of what you know or don't know about using macros in Excel, there's a good chance that my newly updated courses can help you take your use of Excel to the next level. Through the course's great video sessions (over 24 hours worth!) and supplemental materials, you'll develop a firm grasp on the skills you need.

If you haven't checked out the courses yet, I invite you to do so. Plus, right now you can register for any course and any version at 20% off the regular price. This is a limited offer, though. You'll want to act soon so you don't miss out. You'll find complete details here:

    MacrosMasterClass.com

I hope you have a great day and that you enjoy the tips in this week's newsletter!

—Allen
     

ExcelTips (menu) for 6 August 2022

Time formulas
Checking for Time Input

Need to know if a cell contains a time value? Excel doesn't contain an intrinsic worksheet function to answer the question, but there are some easy ways to approach the problem.

Read this tip »

 
Protecting worksheets
Protecting Individual Worksheets, by User

Excel allows you to protect worksheets, individually. Users can still see that the worksheets are there, but they cannot display them if they don't know the proper password. If you are developing a full-blown application in Excel, you may need a way to completely hide worksheets from users unless they enter their password. This tip explains the steps necessary to implement such a scenario.

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!

 
Worksheets
Running a Macro when a Worksheet is Activated

Want to run a macro when you first select a worksheet? You can do so by using one of the event handlers built into Excel, as described in this tip.

Read this tip »

 
Excel can calculate at lightening speed
Multiple Line Headers and Footers

When working with headers and footers in a macro, you might find this tip helpful. It describes how you can create headers or footers that occupy multiple lines.

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