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 →

Power Map

This lesson covers Power Map. Power Map is an Excel feature that you can use to graph geographical data. If you have data by city, country, zip code or even addresses, you can use Power Map to create a map of the data. I will also show you how to make custom animation in Power […]

Read the full article →

Power View

Hey there! Thanks for coming over to check out my lesson. This lesson covers Power View. Power View is a new feature in Excel that lets you build new types of presentations and data explorations. If you purchased the lesson, ‘Named Ranges, OFFSET and Dynamic Charts’, rest assured that Power View is very different. Power […]

Read the full article →

PowerPivot

PowerPivot is a big deal for Excel. If you’ve been following my lessons, you know that I’m a big proponent of building your Excel models in layers; Data, Business Logic, Presentation. PowerPivot is a new Excel feature that lets you build a massive data layer. By massive, I mean several million rows of data. If […]

Read the full article →

Mastering Excel Macros: Arrays

Hi, Thanks for checking out this lesson. This is a continuation of the Mastering Excel Macros series. This lesson is a bit more ‘programmy’ than previous lessons. Don’t worry though, I explain everything and it’s not that complicated. What is this lesson about? How to use things called Arrays, Collections and Dictionaries to process large […]

Read the full article →

Mastering Excel: Power Query

Hi, Welcome another lesson in the Mastering Excel series. This lesson is a slight departure from previous lessons. This lesson is looking into the future and delving into what Excel is becoming: a powerhouse for data analysis. Power Query is the first step in analyzing data, before you do any substantial analysis, you need to […]

Read the full article →

More Interactive Charts

This lesson continues to build upon the skills you learned in Mastering Excel: User Forms. You will build several charts, each of which uses a different type of form to control an Excel chart. You will learn how to use option buttons, spin buttons and check boxes. The last exercise will teach you how to […]

Read the full article →

Enter for a chance to win a Plush Skunk toy

One of the previous winners has declined to accept his skunk toy prize. I’m holding another raffle to give away the last skunk. Enter for a chance to win. You don’t have to buy anything! You can be a current client or not, doesn’t matter. a Rafflecopter giveaway

Read the full article →

Mastering Excel Macros: VBA Forms and Events

This lesson covers the ultimate in form customization, using the VBA form editor to create forms with custom code that can interact with your users however you want. This lesson covers using Excel’s built-in dialogs, the Data Form, VBA forms and workbook events. Sign up below to receive the follow along workbooks and practice while […]

Read the full article →