CP034: Advanced Excel Essentials book talk with Jordan Goldmeier

In the 34th session of Chandoo.org podcast, Let’s hear from Jordan Goldmeier – my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book – Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.

CP034 - Advanced Excel Essentials book talk with Jordan Goldmeier

What is in this session?

In this podcast,

  • Introduction
  • What is this book all about
  • Sample chapter review – User forms
  • Design principles for creating advanced user interactions
  • How to become advanced Excel user – pathway recommended by Jordan
  • More info about Jordan
  • A secret for you

Show pop-up calendar upon right click [Excel VBA]

There are times when we are entering dates into several columns and would like to select a date from a popup calendar instead of manually typing.

Today, lets understand how we can set up a pop-up calendar in Excel so that your users can easily input dates by right clicking on a cell and inserting a date.

pop-up calendar vba excel