Bespoke training design and production
Creating a Quiz in Microsoft Forms is a useful skill… In Forms you can create either a Survey or a Quiz. A Survey is there to gather information – the answers come from the respondents. But a Quiz contains the answers and so this is Read More …
When you have an Office 365 subscription you get a lot of software. Word, Excel, PowerPoint, Outlook – all the stuff you’ve heard of. But this is the hidden gem. Nestling at the bottom of the toolbar, it’s a product that is initially hard to Read More …
To be precise, it’s not really called “Office 365” any more, it’s now Microsoft 365. Microsoft’s best selling software is now more useful than ever. In fact, for the modern home user, it gives you everything you need to do all those important things like Read More …
Sometimes you have presentations with groups of slides in them and now in PowerPoint you can divide your presentation into sections. This is controlled from a single slide that you can use to “zoom” into a section of slides, play them (in a slideshow) and Read More …
Stock imagery is useful, but can be expensive. Luckily, if you have a subscription to Office 365 (now called simply Microsoft 365), you can get your hands on some nice stock imagery directly inside Word, Excel, PowerPoint and even new messages in Outlook. In fact, Read More …
One of the recent additions to Excel has been the “Map” chart type. It enables you to relate your data in your spreadsheet to geographical regions and this gives you a really good graphic that you can share with others. But it’s not just a Read More …
…otherwise known as “Conditional Formatting” Often in a spreadsheet you want to highlight your numbers to emphasise their value. So how do you make the magic happen? With as little work as possible, so this is where Conditional Formatting can help… 1. Highlight Top/Bottom Values Read More …
Sometimes you do want to share things! I’m not just talking about funny cat videos. I’m talking about your Office 365 documents. In Office 365 applications you can use the Share button on any file to give someone else access. Here it is in PowerPoint… Read More …
How do you limit entries to spreadsheet cells? So you have a list of people in your spreadsheet and you want to note their knowledge level on a particular skill. How do you restrict entry to that column to a number between 1 and 5? Read More …
What happens when you have a spreadsheet like this… And you want to split the first column (Full Name) into 2 separate columns, like this… How do you do that, the easy way? First of all, you need to create 2 new columns… Then, name Read More …