Friday, August 19, 2022
  • Home

Worth Getting Office 2019?

October 18th, 2020 by Jabez Gan [MVP]


Common questions that I receive is, is Office 2019 worth the upgrade? Here’s break it down here.

Table Of Content:

What is Microsoft Office 2019?

Office 2019 is a local version of Office software, rather than cloud-based. It’s a perpetual release, meaning that you purchase the product once and own it forever instead of paying for a subscription or multiple subscriptions to use it.

What Are The Advantages Of Using Office 2019?

With Office 2019 you can use Microsoft’s latest versions of:

Word: Word has a new look and is black themed. However, it has all the features that you’re used to. Plus, Word in Office 2019 has incorporated learning tools, a new text-to-speech feature, and sounds that you can personalize.

Outlook: You’ll like Outlook’s improved user details, its support, and the look of the inbox. Some new features include:

  • Updated contact cards
  • Office 365 Groups
  • @mentions
  • Focused inbox
  • Travel package cards

Excel: The 2019 version of Excel brings in some great new functions like Power Pivot, 2D maps, and Power Query enhancements. You’ll have access to new formulas, new charts (like funnel charts and 2D maps), and you can publish your work from Excel to Power BI.

PowerPoint: The new version improves the way you can manage images. You can even turn them into 3D views. And PowerPoint now comes with enhancements like Zoom and Morph for a more sophisticated and dynamic presentation.

OneNote: This is an entirely new release in Office 2019. It can replace OneNote 2016 (but the 2016 version is still available and supported until 2025). OneNote now has ink-to-text support. This means that you can convert your handwritten words into a typed text.

You’ll like these new features:

Inking: You’ll enjoy the new inking capabilities across all of Office 2019’s apps such as pressure sensitivity, and the tilt effect that adjusts the ink’s thickness depending on the angle of the pen. It even has a roaming pencil case to store and organize your favorite pens, pencils, and highlighters to roam with across your different devices.

Easy Sharing: The new version of Office makes sharing easier. Office 2019 comes with a share button located on each application in the upper right corner of your screen. A document can be shared with just one click. This lets you share documents in different departments and throughout your organization.

Smarter Attachments: In the earlier versions of Office, you had to attach a document to an email to send it to others, and you had to go searching for the file you needed. Now, if the document that you want to share was recently worked on, it will be displayed when you click on the share button in Outlook along with other recently worked on docs.

Improved Version History: Now, Office 2019 comes with a History Section on the File Menu to make sure files are easily accessible.

Delve: This is a new tool that was integrated into Office 2016. It ensures that you have access to every aspect of your stored data. It includes documents shared or created in Office. This makes retrieving documents much easier.

As mentioned, Office 2019 is a standalone program for business users who either don’t want to use the Cloud or cannot access it. Because of this, most of the features included in Office 365 aren’t in Office 2019, such as the collaborative real-time editing features.

Microsoft advises that whether you move to Office 2019 or decide to go with Office 365, you shouldn’t delay. This is because Office 2016 cloud support will be dropped in 2020. And Office 2016 installs will be barred from connecting to Microsoft’s cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020.

What are the different versions of Office 2019

Highlighted below are Office 2019 editions:

  • Home & Student: Includes core applications only.
  • Home & Business: Includes core applications plus Outlook.
  • Standard: Only available through volume licensing channels: includes core applications plus Outlook and Publisher.
  • Professional: Includes core applications plus Outlook, Publisher and Access. Uses Windows Installer method for offline installation.
  • Professional Plus: Only available through volume licensing channels; includes core applications plus Outlook, Publisher, Access and Skype for Business. Uses the Click-to-Run method for online installation.

Microsoft Office 2019 Home and Student

Office Home and Student, is perfect for home use, school use by teachers and students, and it even works well for writers. It also includes OneNote, which is ideal for the student or writers. OneNote allows you to keep detailed notebooks full of research. You can include text, pictures, and audio for the most complete note-taking experience ever.

Microsoft Office 2019 Home and Business

The Home and Business edition of Microsoft office 2019 is very similar to Home and Business. It adds Outlook to the picture, making it an ideal choice for small business owners. All of the core apps are here too. This is a great midpoint between the home and professional business editions of Office, which is why it is perfect for small business owners who are looking for contact management in addition to the core products.

Microsoft Office 2019 Standard

The Standard edition of Microsoft Office 2019 is only available through volume licensing. It is ideal for midsize to large businesses and includes all of the features of smaller editions of Office 2019, but it also includes Outlook for communications and Publisher, which brings simple, professional desktop publishing capabilities to the table

Microsoft Office 2019 Professional

Office Professional 2019 includes core applications plus Outlook, Publisher, and Access. Uses Windows Installer method for offline installation. This is where you get into the power needed for corporations and large businesses. Access is a database management system that provides businesses with the means for storing lots of customer data and more. This is only available in the Professional editions.

Microsoft Office 2019 Professional Plus

You can only get Office Professional Plus 2019 through volume licensing channels. It includes core applications plus Outlook, Publisher, Access, and Skype for Business. Uses Click-to-Run method for online installation.

Microsoft Office 2019 for Mac

Mac users should not feel cheated. For many years, Mac users have always felt that Microsoft left them out of the game, but that’s no longer the case. Now Microsoft gives Mac users an office suite comparable to what PC users have. Office for Mac 2019 comes in three specific editions:

Office for Mac supports Apple’s three most recent versions of macOS.

Microsoft Office for Mac 2019 Home and Student

Microsoft Office 2019 Home and Student for Mac Edition is the perfect combination of apps and features for casual or professional users who don’t need advanced business features but want all the necessary apps for productivity. This version of Office 2019 finally gives Mac users most of the features that many of them feel they have been lacking over previous editions of Microsoft Office releases.

This edition, like the PC edition, gives casual users and students everything they need to be productive. You get the core programs, Word, Excel, and PowerPoint, all updated with the latest features that had been introduced in Office 365 over the previous year. There are some slight variations due to the operating systems, but overall, you get the same great productivity and performance in Office 2019 for Mac as you do with Office 2019 for PC.

Microsoft Excel 2019:
New formulas and features help you better analyze and visualize your data. Leverage features like Analysis Toolpak, Slicers, and Formula Builder to save time, allowing you to focus on the small details. New templates help you get up and running faster.

Microsoft Word 2019:
Create stunning professional documents, term papers, flyers, and more with Word. New features include improved inking, roaming pencil case, and a focus mode that lets you write without any distraction. If you share and work on a document with others, you can take advantage of real-time edits and threaded comments that appear next to the relevant text for more efficient collaboration. Improved research tools let you search for information and apply them without ever leaving Word.

Microsoft PowerPoint 2019:
Create, collaborate, and present your ideas with new slide transitions and Animation task pane that lets you have more control over your presentations. Threaded comments alongside your slides let you incorporate feedback into your presentations. Presenter View displays the current slide, next slide, speaker notes, and a timer on your Mac, all while projecting only the presentation to your audience on the big screen. This lets you know what to expect and lets you get a feel for how your presentation is going.

OneNote 2019:
This impressive digital notebook lets you keep notes, ideas, web pages, photos, and audio and video in one place. Whether at home, in the office, or on the move, you can take everything with you wherever you go while. You can also share and collaborate with others. Great for school assignments, work projects, travel plans, party planning, and more.

Office for Mac 2019 Home and Business

The 2019 Microsoft Office Home Business for Mac. Includes the core applications, Word, Excel, and PowerPoint, and powerful email management with Outlook. This is the same as Home and Student. It includes core applications plus Outlook. The big difference is this one is available for volume licensing, making it perfect for large businesses.

We recommend the latest versions (2016) of Microsoft Office products, but you can save a little by purchasing Office 2010 or 2013. The core applications are in both of these products, which also come in the same basic Home and Student, Home and Business editions. If you choose 2010, you will save money but lose some of the substantial updates. With 2013, you get the best of both worlds — a Microsoft Office product that is inexpensive and still offers most of the power and features of the latest version of Microsoft Office.

Office for Mac 2019 Professional

images CMS PagesThis is the heavy-duty Office for Mac Professional. If you’ve got a corporation or big business of any kind, this is what you need. Includes all of the basic Microsoft applications including Word, Excel, and PowerPoint. Mac Professional 2019 also includes Access and Skype. Publisher, the award-winning desktop publishing software does not come with Office for Mac in any edition, even on 365.

Some of the features included in Office for Mac 2019 include a roaming pencil case and ribbon customizations in all Office apps. There’s a focus mode in Word and Excel adds new data-analysis features and more charts and functions, including CONCAT, TEXTJOIN, IFS, and SWITCH. PowerPoint users can now include Morph transitions, in-click sequence, and 4k video export. For Outlook users, there’s the new focused inbox that allows you to organize your inbox for better productivity.

Where Do We Buy

Here are some links that you can directly purchase it from Amazon:

Disclosure: All opinions remain the writer’s own. There may be paid or sponsored mentions in the above article, but we believe in honesty of relationship, opinion, and identity. We will only recommend services that we have tried and tested ourselves or have done extensive research and find them to be useful recommendations. 

Posted in Microsoft, Office365 | Comments Off on Worth Getting Office 2019?

Office 365 Dirsync: Batch update of AD users, and password sync not working?

January 23rd, 2015 by Jabez Gan [MVP]


Office 365 with Dirsync setup.


After a batch update of users in AD, and assignment of license in Office 365, these users are not able to login to Office 365.

However, if create a single user in AD and assign license in Office 365, the user is able to login to Office 365.


Do a force password sync

Note: You must have Directory Sync tool version 6438.0003 or greater installed in order to perform the process below.

To trigger a full password sync, perform the following steps:

  1. Open PowerShell, and then type Import-Module DirSync
  2. Type Set-FullPasswordSync, and then press Enter
  3. Load Services.msc
  4. Restart the Forefront Identity Manager Synchronization Service Service.

Posted in Office365 | Comments Off on Office 365 Dirsync: Batch update of AD users, and password sync not working?

Azure AD Connect: One simple, fast, lightweight tool to connect Active Directory and Azure Active Directory

December 17th, 2014 by Jabez Gan [MVP]

Back in August I posted a blog announcing the beta release of Azure AD Connect. Since then we have received a lot of feedback and made improvements in AAD Connect and AAD Sync, including multi forest support and password write back.

The biggest thing we’ve learned from you, our customers and partners, is that rather than a bunch of different tools (DirSync, AAD Connect, AAD Sync, ADFS, etc.) you want one simple, integrated tool for connecting your existing Windows Server Active Directory with Azure Active Directory. You’ll be happy to know that we’ve acted on your feedback!

Today we’re releasing a public preview of the “new” Azure AD Connect (you can download it here).

Azure AD Connect is “new” because it is now one integrated tool that includes all the advances of AAD Sync and the features from the beta release of Azure AD Connect into simple, fast & lightweight solution. Azure AD Connect has everything you need to connect your Windows Server AD(s) and Azure AD with only 4 clicks.

Now you can get started using Azure AD in under an hour, no new hardware required!

With this preview you can choose Express Settings or Custom settings just like before, only now you get the latest sync engine and capabilities.

Add one or many Active Directory forests to your connection.

And configure sync options Exchange Hybrid sync, password write back and alternate ID attribute

There are few things I want to let you know about the preview:

  • Because it’s our first combined wizard and it is in Preview status, we are not supporting production deployments for this release. Our next release will be production supported.
  • Our goal is to bring 100% of the previous DirSync functionality into Azure AD Connect. Before we GA Azure AD Connect we will bring all Dirsync functionality in.
  • We’ve received a lot of great feedback from you and have incorporated most it. But that doesn’t mean we’re done. Please keep the feedback coming!

Our goal is to GA Azure AD Connect with additional sync options, seamless migration from Dirsync, and production support in the next 90 days.

Please note there will no longer be separate releases of Azure AD Sync and Azure AD Connect. And we have no future releases of DirSync planned. Azure AD Connect is now your one stop shop for sync, sign on and all combinations of hybrid connections.

Source: Technet Blog

Posted in Office365, Windows Azure | Comments Off on Azure AD Connect: One simple, fast, lightweight tool to connect Active Directory and Azure Active Directory

Exchange Management Console shows mailbox is migrating/migrated from one DB to another DB

October 9th, 2014 by Jabez Gan [MVP]


In an Exchange Hybrid environment (using Office 365).


In Exchange Management Console (EMC), under Move Request, there is some mailbox being moved. This action was not done by the local IT administrators. The mailbox affected are mailboxes already migrated to Office 365.


Run a Get-MoveRequest and if you see something like below, you are actually seeing the database being moved from Exchange Online DB to another Exchange Online DB. This is part of Exchange Online DB maintenance. There is no impact to users.

ExchangeGuid               : 404b747c-d942-4ecc-ba61-9459c234a8d3

SourceDatabase             : APCPR04DG020-db001

TargetDatabase             : APCPR04DG011-db170

SourceArchiveDatabase      :

TargetArchiveDatabase      :

Flags                      : IntraOrg, Pull, MoveOnlyPrimaryMailbox

Posted in Office365 | Comments Off on Exchange Management Console shows mailbox is migrating/migrated from one DB to another DB

Auto Assign Office 365 License based on domain name

October 2nd, 2014 by Jabez Gan [MVP]

Problem: Customer has a few email domain names and are slowly migrating to Office 365. The customer wants to auto assign license for certain domains using PowerShell.

Step 1:

Set the Office 365 tenant password in a TXT file.

The PowerShell Script:

#Modify below YOURPASSWORD to your Office 365 password
$password = “YOURPASSWORD
$password | ConvertFrom-SecureString | Set-Content c:\o365\password.txt

Step 2:

Search based on the valid domains and add license for users that have not been licensed.

The powershell script:

#Valid Domains.
#Modify below and to your own domain that you want to auto assign license.
$validDomains =”*”,”*

$MsolAdmUser = “
$pwd = Get-Content c:\o365\credmsol.txt | ConvertTo-SecureString
$cred = New-Object System.Management.Automation.PSCredential $MsolAdmUser, $pwd

Import-Module MSOnline
Connect-MsolService -Credential $cred

$temp = (get-msoluser -all) | select userprincipalname

foreach ($a in $validDomains){

foreach ($b in $temp){

$validUser = ($b) | where {$b.userprincipalname -like $a}

If ($validUser –eq $null){

} else{

set-msoluser -userprincipalname $validUser.userprincipalname -usagelocation “MY”

set-msoluserlicense -userprincipalname $validUser.userprincipalname -addlicenses “userTenantName:STANDARDWOFFPACK

$validUser = $null





To get the “userTenantName:STANDARDWOFFPACK“, you will need to run get-msolaccountsku.


The above is a script that I quickly developed. Apologies if it isn’t neat as of now 🙂

Posted in Office365 | Comments Off on Auto Assign Office 365 License based on domain name

Office 365 – Unable to remove verified Domain name

June 25th, 2014 by Jabez Gan [MVP]


When you are trying to delete a verified domain name in Office 365, an error pops up saying that some users or Office365 services are still attached to the domain.

Root Cause:

Just like what the error said, some of the Office 365 services or users are still attached/assigned to the domain name that you are trying to remove.


Things to check:

  1. Ensure that no users are associated with the domain that you are trying to delete. You can verify this by going into Users And Groups, and Edit a user. Ensure that the domain you are trying to delete, eg,, is not listed there.
  2. Ensure that no security groups/distribution groups have the accounts attached to Security groups/distribution groups can be access by logging into Office 365, click on Users And Groups, and click on Security Groups.
  3. If you have just deleted the users, or changed the domain for each individual users, you will need to wait for a while (1 min?) as it will need to sync the changes to the different Office365 service settings.
  4. If the accounts are uploaded to Dirsync, you will need to stop the Dirsync synchronization to change the accounts to a Cloud Only account. Then, you will need to do step 1-3 above to delete the Security groups; and/or manually modify the e-mail addresses fields in Office 365, Exchange Online.

Posted in Office365 | Comments Off on Office 365 – Unable to remove verified Domain name

“Insufficient Permission” shown in DirSync’s MIISClient.exe

June 24th, 2014 by Jabez Gan [MVP]

Lately, I had an issue with Office 365’s MIISClient.exe


MIISClient.exe shows that a bunch of user accounts failed to sync with the error “Insufficient Permission”.


Certain permissions needed by MSOL Service Account went missing (for whatever reason!). All we had to do is to recheck back the permissions.

Step 1: Run the Azure Active Directory Sync tool Configuration Wizard

Make sure that the latest version of the Directory Sync tool is installed and that you run the Azure Active Directory Sync tool Configuration Wizard. When you run the wizard, one screen prompts you to enable rich coexistence. Complete the wizard, and then start directory synchronization.

Alternatively, you can run the Enable-MSOnlineRichCoexistence cmdlet after the Directory Sync tool is installed to enable the write-back feature. This cmdlet must be run by using enterprise credentials or should be run by the enterprise admin.

Step 2: Confirm MSOL_AD_Sync_RichCoexistence permissions

If step 1 doesn’t resolve the issue, check that the MSOL_AD_Sync user belongs to the MSOL_AD_Sync_RichCoexistence group and that the group has Allow permissions to the user who is experiencing the issue, where write-back is not working for the following attributes:

  • msExchSafeSendersHash
  • msExchBlockedSendersHash
  • msExchSafeRecipientHash
  • msExchArchiveStatus
  • msExchUCVoiceMailSettings
  • ProxyAddresses

To do this, follow these steps:

  1. In Active Directory, make sure that the MSOL_AD_Sync_RichCoexistence group exists and that the MSOL_AD_Sync user is a member of the group.
  2. In the on-premises environment, use Active Directory Users and Computers to open the user properties for the user who is experiencing the issue.
  3. On the Security tab, click Advanced.

    You must enable advanced features to complete step 3.
  4. Make sure that the MSOL_AD_Sync_RichCoexistence group is listed. If it’s not listed, add the group, and then make sure that the group is granted Allow permissions to write to the attributes that are listed previously.

Note Step 2 may be required if the object does not inherit permissions from the parent. This issue may be resolved by making sure that the object inherits permissions from the parent object.


Source: Microsoft KB 2406830

Hope this helps! 🙂

Posted in Office365 | Comments Off on “Insufficient Permission” shown in DirSync’s MIISClient.exe

Enable Legal Hold by using PowerShell

June 23rd, 2014 by Jabez Gan [MVP]


You have purchased some Office 365 E3 plans and have assigned the Office 365 E3 licenses to the users.

You would like to activate Legal Hold for these users in bulk, using PowerShell.

Script to Activate:

  1. # First you need to be connected to the Exchange PowerShell.
  2. $pagesize = 100# The number of mailboxes per loop
  3. $inc = 0# Start increment value
  4. # Continue until all mailboxes are litigation hold enabled
  5. do {
  6.     Write-Output “Getting mailboxes”
  7.     # Get UserMailboxes that does not have litigation hold enabled
  8.     $mailboxes = GetMailbox Filter {LitigationHoldEnabled -eq $false -andRecipientTypeDetails -eq “UserMailbox”} ResultSize $pagesize WarningAction SilentlyContinue
  9.     if($mailboxes) { Write-Output (“Current mailbox count: {0}” -f ($inc += $mailboxes.Count))}
  10.     # Enable litigation hold
  11.     $mailboxes | SetMailbox LitigationHoldEnabled $true WarningAction SilentlyContinue
  12. } while($mailboxes);


Posted in Office365 | Comments Off on Enable Legal Hold by using PowerShell

Free/busy not working in Hybrid

June 16th, 2014 by Jabez Gan [MVP]

In a Hybrid deployment, lately I had experienced that:

1. On-premise users can see cloud users’ free/busy

2. Cloud users cant see on-premise users free/busy


Note: the below may not solve your problem, but it should lead you to the right way to brute force your way to solve the problem lol


1. Try out the Hybrid Free/Busy Troubleshooting Tool.

2. Check out: User can’t view free/busy information for a remote user in a hybrid deployment of on-premises Exchange Server and Exchange Online in Office 365

3. Did an IISRESET as recommended:

4. Update/Refresh the Federation Metadata. See this blog for more information.

  •  Connect to Exchange Online in PoweShell
  • Execute:
  • Get-FederationTrust | Set-FederationTrust -RefreshMetadata

5. Execute the free/busy test from Microsoft Remote Analyzer

6. Ensure that in all Exchange Servers (including the inactive ones located in the DR sites), the Get-WebServicesVirtualDirectory has the correct ExternalURL: (and is routable from the internet)

Get-WebServicesVirtualDirectory -Identity “ServerName\EWS (Default Web Site)”


Leave a comment if it’s still not working. No promise that I can help you fix, but I’ll try 🙂

Posted in Office365 | Comments Off on Free/busy not working in Hybrid

Office365 – Dirsync not synchronizing fully

April 19th, 2014 by Jabez Gan [MVP]


Directory sync is located in the internal network and is behind a TMG proxy. TMG Proxy has been configured to allow Directory Sync to access HTTPS of the internet.


With Directory Sync installed, the synchronization fails from time to time after a few hours of sync (we have >10,000 objects to be synced to the cloud).

Root Cause:

Directory sync should have direct connection to the internet. It is known to create issues if it is behind a TMG Proxy.

Posted in Office365 | Comments Off on Office365 – Dirsync not synchronizing fully

PowerShell to create Distribution Group in Exchange 2010/Office365

April 14th, 2014 by Jabez Gan [MVP]

When setting up Office365/Exchange 2010, it is very common to assist the customer to create distribution groups.


This is my way to script it to speed up the creation of the distribution groups:.

1. Create a CSV file for each distribution group. For my case, I have _AllStaff.CSV created. See below link for the sample of the file.



2. Use Powershell and run the following:


(The above should be the filename of your CSV file).


New-DistributionGroup -Name “_All Staff” -alias $name -primarysmtpaddress $ -memberdepartrestriction closed

(Modify the bold items to the right Distribution Group name and domain name)


Import-csv “D:\$name.csv” | foreach {add-distributiongroupmember -identity $ -member $_.EmailAddress}

(Point the location to the CSV file, and also specify the correct distribution group name)


What’s your way in creating the distribution group?

Новости и Обзоры Онлайн Игр

Posted in Office365 | Comments Off on PowerShell to create Distribution Group in Exchange 2010/Office365

Additional Microsoft Online Speed Test Links

November 1st, 2012 by Jabez Gan [MVP]

Again, with the importance of having a fast connectivity speed to cloud offerings, there are extra links for you to have a more accurate speed details to the cloud.

Use the following appropriate links to do your own speed test based on your Office365 service location:





For Lync:

Let me know if this helps!

Posted in Office365 | Comments Off on Additional Microsoft Online Speed Test Links

Lotus Dominos Migration to Exchange Online/Exchange using Quest Notes Migrator for Exchange

September 8th, 2012 by Jabez Gan [MVP]

Problem: You are using Quest Notes Migrator for Exchange (NME) to migrate from Lotus Dominos to Exchange Online/Exchange On-premise, and on migrating the user accounts, new emails are no longer entering Lotus Dominos.


Problem Statement: You want to have a copy of the new email stored in Lotus Dominos and have a copy forwarded to Exchange Online/Exchange On-premise.

Solution: To be exact, there is no solution to this, as Quest NME tool doesn’t allow the support to have a copy left on the Lotus Dominos before forwarding it to Exchange Online/Exchange on-premise. However it might be possible (correct me if I’m wrong) to configure Lotus Dominos directly to leave a copy before forwarding it, if NME tool modifies Lotus Dominos parameters directly.

Posted in Office365 | Comments Off on Lotus Dominos Migration to Exchange Online/Exchange using Quest Notes Migrator for Exchange