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
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:
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:
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:
Improve your Power Query skills
Learn how to Customize the ribbon for your workbooks and add-ins.
Get insight how to Build Excel models based on ranges and positions.
Understand how to create involved Array Formulas
Get advice on Best practices in Power pivot.
See how to use VBA to customize charts
Receive Tips & Tricks, documentation and lots of valuable files
The Excel Charting And Dashboard Masterclass
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 Tony de Jonker and communication & visualization expert David Hoppe unveil the secrets of creating powerful and flexible dashboards.