Hi. Thanks for visiting my Excel lesson blog. Here I will be commenting on my Excel lessons, asking for feedback and keeping you up to date on what I am working on next.

{ 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

June 8, 2017

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

May 17, 2017

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

May 10, 2017

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

December 9, 2016

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

December 9, 2016

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!

October 30, 2016

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

August 22, 2016

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

June 25, 2016

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

June 9, 2016

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 →