(1) Shelf calculations (also known as ad-hoc calculations or in-line calculations) are quickies that you can create by double clicking on Marks, Row, Columns and Measure Values Since shelf calculations are not added to your dataset, they're not re-usable between different worksheets in a workbook, which means that they're not a sustainable way of building a … Continue reading 3 Super Handy Tableau Features
Yes, it is handy to be able to automatically delete slides from a PowerPoint presentation There are instances, however, when it might be smarter to delete the content of a slide rather than the whole slide. What you can use in such cases is the VBA snippet below, which will loop through all slides of … Continue reading How do I delete all of a slide content but its title with VBA?
If you've decided that the logic of using Slide IDs to delete (or otherwise update) slides in a presentation is the way you'd like to proceed towards VBA coding your PowerPoint updates, you will undoubtedly need a handy way of deciphering the precise values of those Slide IDs that you have in your presentation. A super … Continue reading How do I show the Slide ID of a single slide?