Power Map

May 30, 2016

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

May 21, 2016

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

March 26, 2016

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

February 7, 2016

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

February 1, 2016

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

December 25, 2015

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

November 28, 2015

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

November 20, 2015

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 →

Charts

September 28, 2015

This lesson begins by covering the basics of creating charts in Excel. Then it moves on into some customization options and the last part covers some advanced chart tips and tricks. Once you input your name and email, you will receive a confirmation email. This is to prevent spam. When you verify (by clicking the […]

Read the full article →

Mastering Excel Macros: FileSystemObject

July 24, 2015

This macro lesson continues with the topic of automation. In this case you will learn how to use the FileSystemObject (FSO) (yeah, I know it sounds a bit weird). The FSO is actually a Windows object that manages files and folders. You will learn how to control the FSO to create text files, list folder […]

Read the full article →