How do I delete all of a slide content but its title with VBA?

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?

How do I show the Slide ID of a single slide?

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?

How do I only delete certain slides in a presentation?

One thing you're likely to discover when developing a robust approach for automatic updates is that you might have to come up with a way of scrapping the previous update and replacing it with the latest one. At least that's what I came to painfully realize a month after I fully coded my PowerPoint slides … Continue reading How do I only delete certain slides in a presentation?

How do I quickly save a presentation under a new name and file extension?

A few of you asked me if there was anything specific in the separate saving procedure I would call at the end of my PowerPoint slides consolidation routine as well as what my reasoning for its inclusion in the code in the first place was. Well, I had several requirements: (1) The date when the … Continue reading How do I quickly save a presentation under a new name and file extension?

How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?

As a reporting analyst, part of my responsibilities involved compiling the monthly review slide deck for senior management Whilst it was not a difficult task, it was a pretty boring and time consuming one. Every month, I had to to compile 10 decks, each consisting of 70 slides, which had to be updated to show … Continue reading How do I quickly compile a single PowerPoint presentation from slides saved in multiple files?

How do I quickly add extra characters to a cell?

Has any of you used JIRA as an analysis documentation tool? My team has decided that apart from managing the regular sprint planning, we're also going to be keeping track of changes made to Tableau datasources in JIRA. This also meant that all additional calculations that had been added to a datasource on top of … Continue reading How do I quickly add extra characters to a cell?

How Can I Quickly Zap the Formulas in a cell range?

When I was working as a Reporting Analyst, I was responsible for generating the monthly EMEA Delivery Management scorecards, whose results would get discussed in a day-long meetings between all senior management members One of the major issues with these scorecards when I inherited them was that there was no consistent way of regularly feeding … Continue reading How Can I Quickly Zap the Formulas in a cell range?