April 6, 2017
Understanding and Building Pivot Tables in Microsoft Excel

Understanding and Building Pivot Tables

One of the most common requests during my courses is to explain and demonstrate the use […]
April 4, 2017
Microsoft Excel Custom Lists with States, Provinces, and Countries

Text File with Every State, Province, and Country for Excel Lists

A common request in Microsoft Excel is to have drop-down menus that give you the cities, […]
March 24, 2017
Making PDF Form Fields Dynamic with JavaScript

Using JavaScript to Clear Default Text on PDF Forms

One of those tricks everybody always asks me for is the ‘default text goes away’ click […]
March 20, 2017
Using Visibility Animations with Clickable Triggers on an interactive PowerPoint slide

Making an Interactive PowerPoint Slide with Triggered Visibility Animations

A few years ago, as I was trying desperately to find useful examples of animation in […]
March 14, 2017
A VBA Macro to export multiple Microsoft Word forms to an Excel spreadsheet

Exporting Word Form Data to an Excel Spreadsheet

Exporting Word Form Data to an Excel Spreadsheet During a webinar about Word forms, I was […]
March 3, 2017
YouTube tutorial about creating a Submit button with VBA code in Microsoft Word

Create a Submit Button on a Word Form

After a webinar where the submission script was the most valuable component, I recorded this tutorial […]
February 25, 2017
Free stock photography sites for design projects and learning.

Ten Great Free Photography Sites

As a designer – videos, newsletters, presentations – having free stock photography readily available is key. […]