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
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
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
Create your own Microsoft Teams backdrop using PowerPoint
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
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
Using Microsoft Teams with internal and external people, it can be a challenge to determine which features we can use with whom.
By combining OBS Studio and Stream Deck for Mobile, I’ve built some useful set ups that are helping me with virtual training delivery that I wanted to share with fellow MCTs as well as anyone else delivering webinars and virtual training/teaching.
Trainer/Teachers, do you need a scene switcher? Consider the mobile app version of Stream Deck. Here's how I set it up for testing.
A star wars themed video demo about meeting recordings in Microsoft Teams
Using Forms with SharePoint and Power Automate to send a custom response to training course feedback, including reference links.
There are some great articles out there on building your own automated "Do not Disturb" lights and also some great products, but I decided that I needed one that was a little more manual, but still a bit geeky.
Are you a member of a Team across more than 1 organisation/M365 Tenant? I use Channel Notifications to help me keep on top of the less well used teams.
List of useful resources for using Teams to work from home.
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
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
Do you have a question for me or a suggestion for a blog topic? Please feel free to submit it as a comment to this post or tweet me @sfennah
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
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
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