Productivity tips & tricks

To insert blank rows in an Excel spreadsheet is a relatively straightforward process, as is inserting a block of consecutive rows, but what if you need to insert them alternatively? If it’s a small spreadsheet, than that’s fine, you can work your way down it, but what if the spreadsheet has already got lots of […]

When formatting your Excel spreadsheet (changing colours, backgrounds, gridlines, alignment, etc) how you do it can have a massive impact on its file size. What’s more you may even be unaware of the impact (being honest, how many of us actually check file sizes on a regular basis?). Fortunately, there’s a way to help reduce […]

In the past couple of tips, we’ve looked at how to create Tables & use the tools that then become available (such as Filters and Slicers) to begin to extract information from the data that we hold. We’re now going to look at how to take this much further by looking at Pivot Tables. What […]

PowerPoint has a really useful feature: being able to save Presentations as “Shows”. These allow people without PowerPoint on their computer to still watch the presentation. The downside is that they’re not, on the face of it, editable. And that was the problem that a colleague in the networking group that I attend (https://www.bforbnorthwest.com/) contacted […]

I’m sure that we’ve all sat there captivated bored by a PowerPoint presentation that consists of slide after slide of bullet points where a little thought and use of SmartArt could completely change the look & feel of the whole presentation allowing the presenter to re-engage with their audience. So, what is SmartArt? A SmartArt […]

In last month’s tip we created some Sections within our Presentation to pull together slides into logical groupings, we’re now going to make use of those, via a Zoom slide in PowerPoint to create an interactive menu Here we can see 5 of the sections in our presentation… Using a Zoom Slide As we’re going […]