Thank for stopping by my little corner of the internet.

Excel eBook Lessons
This site contains all of the follow along workbooks for the Mastering Excel eBook lessons. Each lesson should have a link to the specific page but if you can't find the correct page, you can also use the Search bar on the left.

Mastering Excel Online School
I also wanted to let you know that I also have an online Excel school. Yes, I FINALLY launched it. What is so different about the school vs the eBook lessons? The overarching theme of the eBook lessons was brevity. I wrote those lessons with the intent of them being very short and to the point. With the online school, I go into more depth in each subject. I can tell you various tips, tricks and tidbits of information without messing up the step-by-step flow.

You can see the school in this link. Fair warning: I just launched the school and am in the middle of recording lessons. The first course on Mastering Excel Formulas has 7 hours of Excel coolness. Next up on my agenda is an in depth course on macros.

Stop by and check out my school here:

This is a link to the Mastering Excel Formulas class:

I am going to start broadcasting webinars on Excel. I want to cover one specific topic and then open up the floor for Q & A. I think that will be a blast! This will also give you a chance to 'dip your toe in the water' and see how I teach if you are on the fence about enrolling in the school.

Webinars are still a work in process though. Stay tuned for more updates!


{ Comments on this entry are closed }


Thank you for taking the time to check out my site. I’m guessing that you want to lean Excel?

I’ve been hosting webinars where my eBook customers and I hang out and learn about Excel in a fun, no stress, setting. Attendees can ask me questions about the material in the chat window and I might drop a horrible joke or two during the session.

Each webinar is limited to 50 attendees. If you are interested, sign up today so you can claim your spot!

To sign up and get notified when the next webinar will be held, fill in the form below and I’ll send you an email with all the info.

Note: If the form does not appear, it may be blocked by your browser’s ad blocker. Try disabling the adblocker or try another browser. I promise you the form is really there!

I hope we get to meet in the webinar, I promise you that you’ll pick up a ton of tips and have fun.

See you in the webinar!



Webinar: QAT and Clipboard

Here is the webinar where I cover the QAT toolbar, all the options for Paste Special and some very cool tricks with the Camera Tool. The files below are the ones I used in the webinar. You can download them to follow along. The ‘Complete’ file is the end result.

Read the full article →

Drawing Tools

If you are in the habit of using PowerPoint or Visio to create hierarchies and other data driven images, you will love this lesson. I will cover how to use Excel’s powerful image manipulation tools to create and link the images to the data in your spreadsheets…when your data updates, so will your images! If […]

Read the full article →

Mastering Excel Macros: Charts

This macro lesson focuses on how to write macros that update and alter charts in Excel. I don’t go into all the chart object model because it is very deep and complex…but I do give you enough information to be dangerous. 🙂 I’ll show you how to have charts update automagically, let users change the […]

Read the full article →

Goal Seek and Solver

Welcome to yet another Excel lesson! This lesson is a bit longer than the rest of the series because this is a hefty topic. Here I cover: Goal Seek Scenario Manager Solver These three topics are essential for heavy duty data analysis. These topics make Excel shine…like seriously. I’ll show you how to structure worksheets […]

Read the full article →

Data Tables

Welcome to another lesson in the Mastering Excel series. This lesson focuses on data tables. No, not the pretty tables that have banded rows, those are tables. I’m talking about data tables. Data tables are a feature of Excel that let you analyze multiple variables simultaneously and see the interactions between them. If you want […]

Read the full article →

Array Formulas

Welcome to another lesson in the Mastering Excel series. This lesson focuses on the fabled array formulas. You’ve heard of them right? Seriously complex and only geniuses can even attempt to deal with them? Bah. They are just formulas! Yeah, they look funky and can get complex but the same applies to normal formulas. No […]

Read the full article →

Spreadsheet Inquire

Hi, Mark here with more follow along workbooks for an Excel lesson. This lesson covers Spreadsheet Inquire. Inquire is an add-on that was developed by Microsoft which helps you audit and analyze Excel workbooks. To use Inquire you must have either Office Professional Plus and Office 365 Professional Plus edition. Also, you will need to […]

Read the full article →

Bad Joke!

I got the joke backwards in my last email! What did the sushi say to the bee? Wasabi (I originally put ‘what did the bee say to the sushi’. I’ll see myself out now…)

Read the full article →

Mastering Excel Macros: Function Procedures

Hello again, This is Mark (the Excel dude). This is the sign up page for the lesson Mastering Excel Macros: Function Procedures. Enter you data below and a few things will happen: 1 – You will get a confirmation email (to make sure you are a real person and to prevent spam). When you click […]

Read the full article →