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
External & Guest Communication in MS Teams
Using Microsoft Teams with internal and external people, it can be a challenge to determine which features we can use with whom.
Using OBS and Stream Deck for Virtual Training
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.
Virtual Training – Elgato Stream Deck Mobile
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.
Star Wars Day – Record a Meeting in Microsoft Teams
A star wars themed video demo about meeting recordings in Microsoft Teams
Training Feedback Personalised with Forms and Power Automate
Using Forms with SharePoint and Power Automate to send a custom response to training course feedback, including reference links.
Using Flic and Hue to build a Do Not Disturb light
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.
Channel Notifications
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.
Resources to help you work from home
List of useful resources for using Teams to work from home.
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
Questions?
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
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
Microsoft Lists are coming, but what about my SharePoint Lists?
As exciting as the announcement of Microsoft Lists at Build 2020 was, it did leave me wondering what the future of the humble but useful SharePoint list was. Today I finally got around to reading this blog post from 19th May 20. Two sections stood out to me: Millions of SharePoint users have benefitted from … Continue reading Microsoft Lists are coming, but what about my SharePoint Lists?
Farewell Teamwork Administration Qualification
Microsoft are retiring Teamwork Administrator certificate (exams MS-300 & MS-301). The announcement points people to the Teams Administrator (exam MS-700) instead. Having done both the Teams and Teamwork qualifications and with most of my training delivery focused on SharePoint and Teams, this concerns me concerns me on a number of levels.
Remote Training Set up
Should there be a minimum set up for remote training delivery?
Copy Your Stream Deck Mobile to a New Mobile Device
After I set up Stream Deck Mobile on my phone, I decided it would be better on my tablet. I was worried I'd have to set it all up again, but actually it was really simple to copy the config from one device to another.
