Hello!

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:
https://mastering-excel.teachable.com

This is a link to the Mastering Excel Formulas class:
https://mastering-excel.teachable.com/p/mastering-excel-formulas

Webinars
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!

Mark

{ Comments on this entry are closed }

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 you do not see the sign up form below, turn off your ad blocker.
If you still don't see the sign up form, please try another browser (I promise you it's there!)

{ Comments on this entry are closed }

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 →

Excel Macro Bundle: Lessons 1 – 10

I didn’t think there would be a demand for this but readers have asked for it; a macro bundle. Seriously? A ton of pages about macros? Well, who am I to fight the will of the people? Here you go! I have complied macro lessons 1 through 10 into one huge bundle. 254 pages of […]

Read the full article →

Power Pack Bundle

This is a bundle of all the Excel Power BI tools. This bundle contains all the following lessons: Mastering Excel: Power Query Mastering Excel: Power Pivot Mastering Excel: Power View Mastering Excel: Power Map This bundle covers all the new data analysis and presentation features of Power BI. Note that you must have Excel 2016 […]

Read the full article →