Excel Tutorial and Tips for Spreadsheet Analysts

Category Archives for Excel Tips & Tricks

Upcoming Live Workshops and Courses in Los Angeles and Cincinnati

I have several great training sessions and workshops coming up. If you’re interested in receiving training for your organization, let me know. Los Angeles, California, August 25-27th Free wine and beer will be served at both classes! Get the Picture: Intro to Data Visualization Tools With Microsoft Excel August 25th, 2014, 7-9pm Whether you’re an […]

Continue reading

Interactive Spreadsheets for Decision Makers

In case you’ve missed it, my 70-minute long free webinar is available on YouTube. I’ll show you how to make three awesome decision tools in under an hour. Feel free to watch and share. And, remember: I can bring this and so much more to your organization! Send me a message at my consulting page […]

Continue reading

Me vs Bill Jelen on the value of Option Explicit

Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill “Mr. Excel” Jelen on the topic of using Option Explicit in your code. I argue for the affirmative (that you should use it) while Bill takes the status quo. Let me know your thoughts.

Continue reading

Generating random qualitative data in a pinch

There are plenty of terrific random data generators for Excel out there. But sometimes you just need some fake data qualitative data without the fuss. For instance, perhaps I want to generate a random list of data points with the values low, medium, or high. A simple method I recommend combines RANDBETWEEN with CHOOSE. Take […]

Continue reading

Excel TV Interview w Chandoo

Hello there. As many of you know, I am work on a side project called Excel TV with my buddies Oz Du Soliel and Rick Grantham. At first, I thought I’d post every episode as they became available. However, I have so much to do during the week, that I already missed posting Episode. In any […]

Continue reading

Excel TV: Episode 1

Checkout my new project, Excel TV

Continue reading

Checkout my interview with Rick Grantham, Small Business Champion!

Watch part 1 of my interview with Rick Grantham: Follow this link for the full article.     

Continue reading

Excel Dashboard Course

As you might imagine, I often get approached to promote Excel material. As a general rule, I don’t promote products that I don’t really know anything about. So if I promote something, it’s because I believe in it. Today, I want to recommend the Excel Dashboard Course by Mynda Treacy over at MyOnlineTrainingHub.com. And if […]

Continue reading

Miami Valley XL User Group

Based on the great reception Rob Collie has had in Cleveland, I am attempting to create an XL User Group here in the Miami Valley area. Do you live in our around Dayton, Cincinnati, or Columbus? Would you be interested in attending/hosting an Excel user group in these areas? If so, please send me your […]

Continue reading

Creating a Spreadsheet-Based Wizard

First of all, happy spreadsheet day! It was on this date today that VisiCalc was first shipped to the masses. The rest, as they say, is history. So let’s talk about creating a spreadsheet-based wizard. By “spreadsheet-based,” I mean no Userforms. That’s right. There are many good Excel tutorials out there on developing wizards with […]

Continue reading

Handling Rollover Clicks Without Using the Worksheet_SelectionChange Event

You probably noticed a “bug” while playing around with my Interactive Periodic Table of Elements in Excel. When you click down into the Table of Elements (or really, anywhere on the sheet), one of the chemical classifications will become “selected,” despite your not having clicked on it directly. This happens because I’ve used the ScrollArea […]

Continue reading
1 4 5 6