Hi!
It’s been quite a while, but finally I got round to publishing a new article on my site.
It is a nice trick to make full use of the Data Validation’s Input message option, without the popup message covering your sheet.
So not like this:
But like this:
Have a look at the article on my website
Based on an idea by fellow Excel MVP Frédéric le Guen I have created a new small Excel add-in which makes your life using tables in Excel slightly easier. It sports a ribbon tab which contains a drop-down containing all tables in your worksheet so you can quickly jump to them and another one which displays all columns in the current table. Both items are also available in the cell right-click menu. The former when you right-click on a cell not in a table, the latter when you click on a cell within a table.
It also has an enhanced “Insert table” dialog which enables you to enter the name of the table and has the Headings checkbox turned on by default no matter what:
Check out a slightly more elaborate description and a download link
Enjoy!
Hi Excel lovers,
Wanted to draw your attention to our fourth
April 18 and 19, 2017
We’ve worked hard to get an exciting line-up of speakers presenting on a wide variety of Excel subjects during our two-day conference.
So if you’re an Excel power-user, this is one of those one-of-a-kind conferences you cannot afford to miss!
Hope to see you in Amsterdam on April 18 and 19 2017!
Jan Karel Pieterse, Tony de Jonker
Hi everyone,
Long time no see!
It seems the busier one is, the more work gets done. I’ve published a nice article today, in which I explain how I created a Wheel Of Fortune made entirely in Excel some years ago. This is what it looks like:
Enjoy!
Jan Karel Pieterse
Hi Everyone!
We’ve opened registration for our third annual
May 26, 2016
Join us in Amsterdam to learn how to Excel from our Experts (all MVPs):
Jon Peltier, Bob Umlas, Roger Govier, Henk Vlootman, Oz du Soleil, Tony de Jonker, Jan Karel Pieterse.
Attend this comprehensive training event and you will:
May 27th 2016
The Amsterdam Excel summit also features a post-conference training. Attend this one-day masterclass and:
Excel MVP and charting Guru Jon Peltier teaches you how to visualize your numerical information in the most effective way.
Excel MVP and financial expert at najlepsze strony bukmacherskie Tony de Jonker and communication & visualization expert David Hoppe unveil the secrets of creating powerful and flexible dashboards.
So head over to our website to register or to signup to our mailing list so we can keep you posted!
Regards,
Jan Karel Pieterse
Hi everyone,
Due to a change in domain registrar my site jkp-ads.com is temporarily unavailable. I expect it to be back online within the next couple of hours.
Regards,
Jan Karel Pieterse
September 30, 1985 Excel was launched and I therefore wish Excel a very happy birthday and many healthy years to come!
Debra Dalgleish over at the contextures blog has gathered a nice set of stories on how people first “met” Excel.
To celebrate this great event, I’m offering a 30 percent discount on my products for 30 days.
Redeem your discount on RefTreeAnalyser and The Excel File Remediation tool by entering this coupon code: EXCEL30
So have a piece of cake with your coffee today and have one of those “those were the days” moments.
Jan Karel Pieterse
Hi there!
Now that summer has arrived I’ve planned a summer sale. From July 1st up to July 10th I offer a 25% discount on both products I sell:
RefTreeAnalyser
and
The Excel File Remediation Utility
To get your discount, just go through the purchasing process and enter this coupon code to redeem your discount:
JKPADS-Summer2015
Regards and have a great summer!
Jan Karel Pieterse