Font Images

June 15, 2015

This is a short lesson that teaches you how to insert images that come included in several font families. This will work in any version of Excel. If you do not see the form below, please turn off your ad blocker and try again. If that still doesn’t work, try another browser.

Read the full article →

Dashboard Bundle

June 5, 2015

This lesson is a bundle of 7 previous lessons. The bundle includes all these eBooks: Mastering Excel Formulas: SUM, SUMIF Mastering Excel Formulas: VLOOKUP Mastering Excel: Pivot Tables Mastering Excel: Building Animated Charts Mastering Excel: Conditional Formatting Mastering Excel: User Forms Mastering Excel: Building Dashboards Sign up here to get the link for the follow […]

Read the full article →

Sumproduct

May 26, 2015

Hi, This is the sign up form for the Mastering Excel: Sumproduct lesson. Sumproduct is a formula that is similar to sumifs but is much more flexible and powerful. I will review setp-by-step how to use this formula. If you do not see the form below, please turn off your ad blocker and try again. […]

Read the full article →

Excel Lessons

May 19, 2015

Amazon.com Widgets If you have just clicked on the confirmation link in the email you just received, you should get the follow along workbooks in a few minutes (it may have gone into your Spam folder, make sure you check that folder). Until then, you can take a look at the other Excel lessons I […]

Read the full article →

Mastering Excel Macros: PowerPoint Automation

May 13, 2015

This macro lesson continues with the concept of object variables. In this lesson, you will learn how to create an object variable that represents PowerPoint and you will control PowerPoint, from Excel. You must have PowerPoint installed on your computer to follow along with this lesson. If you do not see the form below, please […]

Read the full article →

Building Dashboards

May 12, 2015

If you do not see the form below, please turn off your ad blocker and try again. If that still doesn’t work, try another browser.

Read the full article →

Excel Func

May 6, 2015

I thought it was funny…

Read the full article →

Excel Apps

April 28, 2015

This lesson only applies to Excel 2013 and Office 365! Excel 2013/Office 365 have a new type of functionality. You can now insert apps directly into Excel. Apps have a great range of functionality that can make your charts and dashboard really stand out. I will cover how to use the two free apps that […]

Read the full article →

User Forms

March 9, 2015

This Excel lesson teaches you how to create form objects to allow your users to do something other than type in a number to control a report. You will earn to create buttons, check boxes, option buttons, scroll boxes and a few very neat formulas to make reports dynamic. If you do not see the […]

Read the full article →

Knowing Excel is Crucial to Making More Money

March 6, 2015

This is what I’ve been saying all along! http://www.huffingtonpost.com/2015/03/06/you-cant-escape-the-hegemony-of-the-spreadsheet_n_6816570.html

Read the full article →