Check your Camera before a Teams Meeting

Did you want to check your camera and background before a Teams meeting and ended up trying to join a meeting early to do so, or worse joining a meeting late as you needed to adjust your settings and it took too long, or worst still what about joining a meeting and bringing up a … Continue reading Check your Camera before a Teams Meeting

Solving Problems with Meeting Options in Teams

Do you ever get a message telling you you can't change the meeting options for a meeting you set up? It's probably due to what you were doing the last time you used the Teams web app (aka Teams in your web browser). These messages changed a little while ago to show you who is … Continue reading Solving Problems with Meeting Options in Teams

Thoughts on Click & Collect for small business

So this blog is a bit of a departure for me and results from (virtual) conversations with friends and family. As I write on Nov 1st 2020, England is about to go into a new lockdown (whatever, it's officially called) and "non-essential" shops are required to close but can still offer click & collect services. … Continue reading Thoughts on Click & Collect for small business

Using the Learn Community in the Tech Community

The new Microsoft Learning community in the Tech Community is live along with the new blog. The tech community is quite simple to navigate but I wanted to take this opportunity to share a few tips. Thanks to my fellow MCTs for their help with these too, especially Julian Sharpe, Denise McLaughlin and Rolf McLaughlin. … Continue reading Using the Learn Community in the Tech Community

Extending the Feedback Form into PowerBI

A little while back I wrote a blog on my training feedback form and the flow I had built to send delegates the useful links. See https://m365train.co.uk/2020/04/14/training-feedback-personalised-with-forms-and-power-automate/ Well today I have built a PowerBI report from the SharePoint list which stores the feedback data. As this is the first ever PowerBi report I've written from … Continue reading Extending the Feedback Form into PowerBI

Arrange Windows on Screen

Multitasking is much easier when you can have multiple windows on screen at the same time.  These techniques work in both Windows 7 and 8. To tile windows (any windows version): Open the applications you want to see on screen (do not minimise) Right click in a blank area of the task bar Select Show Windows … Continue reading Arrange Windows on Screen

Calculating Employee Holiday Allowance in Excel

This article looks at managing holiday using Excel 2010 and making use of the following Excel features: INDIRECT function NETWORKDAYS function Format as Table Conditional Formatting The finished file is available here (Holidays). However this article explains how to use the finished article and how to create it, so read on (or bookmark me for … Continue reading Calculating Employee Holiday Allowance in Excel

Simple Formulas and Functions in Excel

Creating Simple Formulas Formulas can be used to perform simple calculations such as addition and subtraction, or more complicated applications such as complex financial functions and statistics. All formulas begin with an equal (=) sign. The equal sign tells Excel that the cell data should be interpreted as a formula. Otherwise, Excel interprets the data … Continue reading Simple Formulas and Functions in Excel

Make Fun of Virtual Meeting Fatigue

Are you sick of virtual meetings and training courses yet? To be honest, I'm not. However I have been looking for ways to ring some changes. It does get dull, always hearing (and saying) the same old phrases, so I've made myself some flashcards. And I gift them to you here - enjoy! You are … Continue reading Make Fun of Virtual Meeting Fatigue

Ignite 2020 – How to Plan Which Sessions to Join

With Ignite 2020 being a virtual event there is even more opportunity for everyone to benefit from attending. But how to you work out what to attend - that session catalogue is vast. After registering, you can add sessions to your personal schedule and your backpack. Your schedule shows only your chosen sessions and your … Continue reading Ignite 2020 – How to Plan Which Sessions to Join