The Office Deployment Tool (ODT) has been around for many years now, although you may be unfamiliar with how...
Tag Archive for: office
4sysops - The online community for SysAdmins and DevOps
Deploying Microsoft Office with Intune

Microsoft Intune provides fairly robust app deployment features that allow businesses to manage and control applications on remote clients...
ONLYOFFICE review: Co-edit documents (DOCX, XLSX, PPTX) in real time using a browser, desktop apps, or mobile devices

In a market dominated by Microsoft, Ascensio System SIA positions its applications as alternatives to MS Office in several...
Protect Microsoft Office using security baseline GPOs

The MS Office applications are complex and have grown over many years. In particular, some older features are no...
Microsoft Lists: Smart information tracking

Microsoft Lists is the latest offering in the Microsoft 365 package. It has been touted as "Smart Information Tracking"...
Zoom alternative BigBlueButton: Free video conferencing tool

Are you looking for an open-source alternative to commercial video conferencing tools such as Zoom? We look at BigBlueButton,...
Configuring meeting security in Microsoft Teams

With an increase in remote working, the security of workers and data is becoming even more important. Part of...
Microsoft 365 Business: Configure macro security settings via group policies

One of the biggest limitations of Microsoft 365 Business (formerly Office 365 Business) is that you cannot control Word,...
Microsoft Application Guard for Office: Protection against ransomware

Ransomware is extremely dangerous to your data. Hackers often use malicious Microsoft Office documents as a means to infect...
Office 2019, Office 365, and Microsoft 365 in comparison: Products included, editions, licensing, and support

If companies want to purchase Microsoft's Office package today, the manufacturer offers them a variety of options. Customers not...
Configure spam filter in Exchange Online Protection (EOP) using PowerShell

You can easily configure the multilevel protection of Office 365 against spam, viruses, and other unwanted messages via the...
Install only selected Office applications using the Office Deployment Tool

When you start the setup of Office 2016 or 2019, it installs all the applications based on some predefined...
Evernote backup on a Mac to Dropbox

With the tiny SyncAny for Dropbox app you can easily create a Evernote backup data on Dropbox and essentially...
Automate out-of-office messages in Outlook with Visual Basic for Applications (VBA)

The VBA script I built allows you to automate out-of-office (OoO) messages. Depending on the day of the week...
Control Outlook AutoDiscover using registry and PowerShell

Controlling the behavior of Outlook AutoDiscover using the registry is not a new idea. Indeed, it has been around...
Excel Get & Transform – Extract information from Active Directory

Using Excel 2016 to query Active Directory (AD) directly is my personal favorite Get & Transform feature. Excel 2010...
Excel Get & Transform – Connect to data sources

With Get & Transform in Excel 2016, you can easily connect to various data sources such as Active Directory,...
Read and write Excel spreadsheets with the ImportExcel PowerShell module

Doug Finke's PowerShell module offers a variety of cmdlets that allow you read and write Excel spreadsheets easily without...
Create Word macros with PowerShell

Not long ago I explained how to work with Microsoft Excel spreadsheets using PowerShell. Today, I'll show you how...
Excel macros with PowerShell

Almost everything you can do in the Microsoft Excel GUI can be done with PowerShell. Thus, you can use...