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
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?
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.
Should there be a minimum set up for remote training delivery?
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.