Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features:
– Edit the name’s comment
– Filter Lambda names
https://jkp-ads.com/officemarketplacenm-en.asp
Here’s a screen-shot:
Regards,
Jan Karel Pieterse
Hi There,
It’s been a while since I last posted here. Today I have released an update of my RefTreeAnalyser utility.
The tool now allows you to add a Table Of Contents to your workbook which contains lists of all sheets, all charts and all Pivottables:
In addition I have added a Feedback button to enable my users to send their complaints -I mean compliments- directly to me! So as of now, if you have ideas for improvements or suggestions for additions or a bug to report, use that feedback button!
Be safe!
Jan Karel Pieterse
Hi there. Hope you and yours are well in these difficult times!
This is just a very short announcement that I’ll be doing an on-line version of my Excel VBA Masterclass.
The training is scheduled for May 18, 20, 26, 28, June 2, 4 and I’ll be using Microsoft Teams to deliver it to your homes!
Regards,
Jan Karel Pieterse
It’s been a great competition and now it is time to announce the winners.
Check out my new Excel challenges page to find out which solutions I received and who won the prize for best solution!
I hope you enjoyed this challenge. If you have more ideas for challenges, let me know!
Regards,
In case you’re bored stiff during your holiday, here’s a nice Excel challenge for you all.
In my newsletter for May 2019 I showed you a trick to get all possible combinations of two lists. This time I have a related problem. Suppose I have 10 ballot tickets. My job is to draw 5 random tickets from that set of 10 repeatedly until I have drawn all possible combinations:
The challenge I would like to give you all:
Please use any technique in Excel to list all possible unique combinations of ticket numbers drawn this way. Note that the order in which the tickets are drawn makes no difference and that each number can only be drawn once per set of 5. This means that a draw of (1, 2, 3, 4, 5) is considered the same as (5, 4, 3, 2, 1) or (2, 1, 3, 4, 5).
What’s in it for you?
The 5 best submissions will receive:
Send your solutions to info@jkp-ads.com using this subject line: “JKPADS Combinations Challenge”
Submission ends on September 9, 2019
Do you want to be able to rename your Excel tables and columns without breaking existing PowerQuery queries? Do you always change the default name of a new table? Want to have quick navigation to your tables in your workbook?
Use my free TableTools add-in
Enjoy!
Jan Karel Pieterse
jkp-ads.com
Great news for anyone who would like to combine visiting the beautiful city of Ljubljana and learn about Excel VBA coding techniques!
On Novermber 5th, 2018 I’ll be teaching the Excel VBA Masterclass in Ljubljana.
In short I’ll be addressing:
There are still some seats available, so hurry up and register soon!
Jan Karel Pieterse
PS: There are two other very interesting masterclasses on that same day, so if you are not into VBA (I can’t imagine you aren’t) there are alternatives!
Hi Excel lovers,
Wanted to draw your attention to our fifth
June 7 and 8 , 2018
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 June 7 and 8 2018!
Jan Karel Pieterse, Tony de Jonker
