Best Way To Paste Special Excel Objects As PowerPoint Images

Best Way To Paste Special Excel Objects As PowerPoint Images

I've written many times in the past on how the quality and formatting of your work can separate you from the rest of the pack when creating presentations. Our cultural is becoming more and more focused on graphic design and it has been proven to increase your audience's ability to understand the data you are presenting. 

Read More

How To Password Protect Opening An Excel File

How To Password Protect Opening An Excel File

There are often files within an organization that need to be restricted from certain people due to the sensitivity of it's contents.  As I have discussed in my article Understanding Excel's Password Security Methodology, Excel's file protection is by far the most secure level of protection (versus Workbook and Worksheet protections) as it uses an AES encryption algorithm.  

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