The amazing Excel hacks will make you realize that most of what you do manually can be done automatically.

This post covers these techniques to help you execute tasks quickly and become more productive. #MSExcel #Microsoft365 #Office365

https://www.kunal-chowdhury.com/2023/09/time-saving-excel-tips.html

Enable the MailItemsAccessed Event for Exchange Online Mailboxes

Recent details released about the Storm-0558 attack on sensitive U.S. agencies revealed the importance of the MailItemsAccessed event for forensic investigations. Luckily, after Microsoft was a tad embarrassed by the recent Storm-0558 attack, tenants with Office 365 E3 or Microsoft 365 E3 licenses can capture the MailItemsAccessed event for mailboxes without having to pay for Microsoft Purview Audit Premium. But you might have to do a little work to ensure that the right audit configuration is used for all mailboxes.

https://office365itpros.com/2023/09/11/mailitemsaccessed-event-important/
#Microsoft365

How to 𝗰𝗼𝗻𝘃𝗲𝗿𝘁 𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗰𝗼𝗹𝘂𝗺𝗻 𝗶𝗻𝘁𝗼 𝗮 𝗰𝗼𝗺𝗺𝗮 𝘀𝗲𝗽𝗮𝗿𝗮𝘁𝗲𝗱 𝗹𝗶𝘀𝘁 in 1-2-3 steps? → https://www.kunal-chowdhury.com/2017/01/convert-excel-column-into-comma-separated-list.html?utm_content=buffer73c8b&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

Let's learn how to quickly and easily copy a column of data to a comma separated list.

#Microsoft365 #Office365 #Spreadsheet #Excel

Update to #365AutomatedLab

Now you can add the 3 different types of #Sharepoint sites using an excel workbook in one #PowerShell cmdlet! The remove is coming shortly 🙂

Thanks to @blackboxcoder for the help!

#it #microsoft365 #automation

https://github.com/DevClate/365AutomatedLab

Controlling Who Receives Invitations to Teams Channel Meetings

Teams channel meetings belong to a channel, but who receives the invitations for these meetings? The answer is “it depends” – on group settings and options. The underlying Microsoft 365 group might have a subscriber list of users who want to receive email for new events like meetings or the user might choose to send invitations to everyone. We discuss the mechanics and explore a way to schedule meetings in shared and private channels too.

https://office365itpros.com/2023/09/08/teams-channel-meeting-invites/
#Microsoft365

4:30am seems like the right time to do an outline for a video on #365AutomatedLab a fun and useful #PowerShell #Microsoft365 Module

Storm-0558: Understanding How Microsoft Failed to Protect Itself

Storm-0558 is a China-originated attack against sensitive Exchange Online mailboxes. The attack exposed several flaws in Microsoft's processing of data. Microsoft says that the holes are now closed, but it's still a good idea to check that your tenant is not being attacked in the same way.

https://practical365.com/storm-0558-snafus/
#Microsoft365

Microsoft Adds Code Blocks to Loop App

A recent update for the Loop app allows users to create and collaborate on code blocks. The editor is very simple and doesn’t check syntax, but it could be a way for people (within a tenant) to collaborate and sketch out potential code solutions to problems. You can create Loop components from code blocks and use those components with Teams chat and Outlook messages, if you remember to stay within your tenant.

https://office365itpros.com/2023/09/05/loop-app-code/
#Microsoft365

Bulk License Assignment with the Microsoft Graph PowerShell SDK

A reader asked how to use a CSV file for bulk license assignment with the Microsoft Graph PowerShell SDK. We didn't have one to hand, so we wrote a new script to illustrate the principles of how to process license assignments for a set of user accounts (which don't necessarily have to come from a CSV file). We even included some error handling!

https://practical365.com/bulk-license-assignment-with-the-microsoft-graph-powershell-sdk/
#Microsoft365

Microsoft Strikes Deal with European Commission to Unbundle Teams

Microsoft has moved to resolve anti-competitive problems around bundling of Teams in Office 365 and Microsoft 365 product by introducing new Microsoft 365 and Office 365 EEA licenses that don’t include Teams. Existing customers aren’t affected and can continue to use Microsoft 365 and Office 365 licenses that include Teams. At the same time, Microsoft promises to make it easier for third parties to integrate apps with Teams and the Microsoft 365 apps. We’ll see how that turns out in the future.

https://office365itpros.com/2023/09/04/microsoft-365-eea-license/
#Microsoft365

Office 365 for IT Pros Launches 99th Monthly Update

The September 2023 update for the Office 365 for IT Pros eBook (monthly update #99) is available for subscribers to download. Details of the update are available in our change log. However, sometimes the change log doesn’t tell the full story about the updates we make to content. A chapter author might forget about a change they make, or maybe we rewrite something and don’t mention it. The point is that the book is in a state of constant change to keep up with the updates Microsoft ships across the Microsoft 365/Office 365 ecosystem.

https://office365itpros.com/2023/09/01/office-365-for-it-pros-99/
#Microsoft365

#Microsoft announces changes to #Microsoft365 and #Office365 to address European competition concerns - 🇪🇺 https://bit.ly/3PkMC9K

Microsoft Removes Reuse Files Feature from Word

Microsoft has decided to remove the Reuse Files feature from Word. They haven’t said why this is happening, but 8t might be linked to the launch Copilot for Microsoft 365. “AI-Lite” features like Reuse Files don’t add a huge amount of value and possibly cloud the message about AI in Microsoft 365. The truth is that we don’t know why Microsoft is removing Reuse Files from Word. Will they do the same in Outlook and PowerPoint?

https://office365itpros.com/2023/08/31/reuse-files-word/
#Microsoft365

EntraExporter Tool Exports Details of an Entra ID Tenant

The EntraExporter toolis a PowerShell module that generates details of objects in an Entra ID tenant configuration (like groups, policies, and users) and creates JSON files. It’s a great way to capture point-in-time information about Entra ID (Azure AD) configuration. Although you can’t replay the captured data to recreate objects, having all the information available is a great start if you need to restore or replay anything.

https://office365itpros.com/2023/08/24/entraexporter-tool/
#Microsoft365 #AzureAD #EntraID

Use Message Trace Data to Analyze Email Traffic

This article describes how to use PowerShell to extract and analyze Exchange Online message trace data to figure out the volume of traffic to outbound domains and from inbound domains. You might think that this is the same information as available in the Exchange admin center mail flow report, but it’s not. Once again, the value of PowerShell in retrieving and using data is evident.

https://office365itpros.com/2023/08/23/message-trace-analysis/
#Microsoft365

https://office365itpros.com/2023/08/21/sensitivity-label-publishing/

Secure Interactive Access to the Microsoft Graph PowerShell SDK

The Microsoft Graph PowerShell SDK uses a default enterprise app to hold its permissions. Over time, the SDK can accrue many permissions, so it's important to control interactive access to it. In this article, we review how to lock down the SDK app and how to create new registered apps for use with the Graph SDK.

https://practical365.com/secure-internet-access-microsoft-graph-powershell-sdk/
#Microsoft365 #PowerShell

Find Out Where Users Get Sensitivity Labels From

A question about finding out which sensitivity label policy makes a label available to a user requires some PowerShell to figure out the answer with some human-friendly results. The outcome is a script that analyzes sensitivity label policies to find where a user gets their labels from. It’s another example of how useful PowerShell can be.

https://office365itpros.com/2023/08/21/sensitivity-label-publishing/
#Microsoft365

Surprised Johns death is not acknowledged on the front of #Apple website, since #Adobe was critical to the success of the Macintosh through #Postscript #DTP, #Laserwriter and last I checked, the reason most creative professionals buy high end #Mac is to use one Adobe's pro apps. His death is such irony considering the removal of Type 1 fonts from #Microsoft365. https://news.adobe.com/news/news-details/2023/Adobe-Co-Founder-Dr.-John-Warnock-Passes-at-82/default.aspx

#Microsofts analysis of #Storm0558 techniques for unauthorized email access #office365 #microsoft365 #infosec

https://www.microsoft.com/en-us/security/blog/2023/07/14/analysis-of-storm-0558-techniques-for-unauthorized-email-access/?WT.mc_id=M365-MVP-6771

@anders_von_hadern Wäre beim nächsten Mal auf jeden Fall einen Versuch wert, bevor ich Microsoft wieder Geld in den Rachen werfe. #Microsoft365