Easy Step-By-Step Instructions To Create Your First Excel Ribbon Add-in

Easy Step-By-Step Instructions To Create Your First Excel Ribbon Add-in

One of the most prosperous skills I have picked up over the years as a financial analyst has been the ability to create custom Excel add-ins specific to my department and company's needs. This one skill I have been able to provide to my company has saved numerous people time, frustration, and money. While it took me well over a year to teach myself how to create top-notch add-ins, I want to let you in on a little secret....it's really NOT THAT HARD! 

Read More

Countdown To Christmas With An Excel Advent Calendar

Countdown To Christmas With An Excel Advent Calendar

It's officially Christmas season, and if you're like me you are already counting down the days until you can take a break from work and relax with family and friends.   Countdown the days til Christmas with this revolutionary Excel-based Advent Calendar.  Can you answer all my Excel quiz questions to unlock the hidden Christmas message?

Read More

How To Run Personal VBA Macros in Microsoft PowerPoint

How To Run Personal VBA Macros in Microsoft PowerPoint

If you use VBA macros, then you most likely understand how powerful they can be when you write code that works in a more generalized fashion instead of for a particular spreadsheet or Word document. Examples could include formatting a selection of cells a particular way (ie fill color, font size, number format, etc..) or automatically emailing your spreadsheet as an attachment to your manager.  These "personal" macros end up saving us time and hassle on a daily basis, so when I started venturing into writing VBA code for PowerPoint, I naturally wanted to develop personal macros for my presentations as well.

Read More