Small but useful feature added to Teams. During Teams meetings when the desktop is shared, the communication option windows used to stay on the screen. This windows often overlapped important areas of the screen. The only way to avoid that interference was to manually move it to the bottom right corner (or some such inconspicuous area).
Now the problem is solved. There is a nice Minimize button. The window disappears. Job done.
How to get it back? Look at the Taskbar and click on the Teams app icon. There is another window visible. Click on it to get the window back.
This applies to the Desktop Teams App only.
Word bullets can trouble you a lot. If there is wrong bullet formatting – that too for just ONE bullet, it can be very frustrating to handle. This happens with numbering as well as shown here.
But it is not a bug. There is a method behind the madness. And of course, there is a simple solution to it.
The problem with wrong bullet formatting
The formatting for the bullet itself is stored in the last character of the paragraph – the paragraph mark itself. It is usually invisible but it is still selectable. So all that you have to do is to select it and then press CTRL Spacebar – which resets the formatting. Problem solved.
To select the invisible character, go to the last character (the period in this case), press right arrow and then press Shift Right Arrow. Now the invisible paragraph mark is selected.
When this is done press Ctrl Spacebar which resets the formatting to default. Here the formatting of the paragraph mark was also red that is why number 3 was shown in red colour. When formatting is reset, the problem is solved.
While saving files we see these two options: This PC and Browse. What is the difference?
If it is a local file, Save or Save As – there is no difference. It opens the standard file save dialog showing local PC files.
If this is a OneDrive, SharePoint or Teams file, there is a difference. For saving these files for the first time, we choose OneDrive or Sites (Teams). Therefore, the Browse and This PC does not come into picture.
However, when you are saving a copy of such files, there is a difference. Note that for online files, there is NO Save As option, it is a Save a Copy option.
If you choose This PC, it will still show the standard File Save dialog showing the default folder (typically Documents).
But if you choose Browse, it browses the current file save location – which is OneDrive or Teams or SharePoint.
The old comments are now called “Notes”. The New Comments are actually discussion threads – like in Word. You can type a comments and others can reply to it. Spend 4 minutes to learn about the new comments.
New Comments look like this… a pink sign in the top right corner.
Continue reading New Comments in Excel
WhatsApp is simple, convenient and popular. Due to this, it is used for official work as well. Whether you like it or not, you have to accept it. Attempts to control it fail miserably. That is where Kaizala comes in. It provides all the convenience of WhatsApp plus all the security and governance you need for managing official work and data. It is a no brainer. But still, let us see WhatsApp vs Kaizala comparison from a business collaboration point of view.
Reading time 6 min
Continue reading WhatsApp vs Kaizala
Just using a login id and password is dangerous. For best protection we must use two factor login – password + OTP. But this is inconvenient and irritating. Now we have a new option – Password-less login – for Office 365. This is secure as well as convenient. See how easy it is and ask your IT team to enable it for you. (5 min reading time)
This requires you to download Microsoft Authenticator app on your mobile and configure it once. You must enable the Phone Sign-In option.
Once this is done, you do NOT need to type in your password at all during login. Here are the steps.
- Go to the login page Office.com and click Sign In
- Enter the login name and click Next
- Now, instead of asking for your password, it will just display a number
- At the same time, you will receive a notification on your mobile. This notification shows three numbers.
- Choose the correct number from the mobile notification and choose Approve
- If the phone was locked at the time of receiving this notification, you will have to enter unlock code or use fingerprint or face sign-in
- That’s it. Now your login is done … without entering the password.
What happens if there is no internet connection
For the Password-less login to work, the Microsoft Authenticator app requires internet connection on the mobile. If there is no internet connection, you can click on the Use your password instead option.
In this case, you can type the password as usual. You will NOT receive a notification on mobile. But the Microsoft Authenticator app will still show the code for your account. Type that code and the login will work. The codes are automatically generated every 30 seconds. This does not require an internet connection on your mobile.
Ask IT to enable Password-less login
This is an Azure AD feature. Ask your IT team to refer to this article for details. It is just a single PowerShell command as of now (Dec 2018). Soon it will be available as an option in Azure AD portal user interface as well.
Quick guide for Office 365 MFA. Includes admin and user tasks in brief.
Admin: Enable Office 365 MFA
- Go to Admin Portal
- Users – Select the user
- Select user(s) again and click the Enable button
- That’s it. Now it is the user’s turn to take the next steps
User: Enable Office 365 MFA – first time only
- You must go to a browser – incognito / InPrivate / private mode
- Go to https://portal.office.com
- Login as usual.
- Click Next in the Additional Information dialog
- Now there are many options and this can be a confusing step
- Open the dropdown choose Mobile App and Choose Receive Notifications for verification option
- Click the Set Up option. After some processing, it will show a QR code
- Now it is time to download and install the Microsoft Authenticator App on mobile (Android and iOS)
- Open the app and from the top right menu, choose Add Account – Work or School Account
- Scan the QR code
- Now it will register the account on the mobile and you will see a 6 digit code which keeps changing every 30 seconds (does not require internet connection)
- Now click Next on the browser side.
- You will now receive an notification on the mobile phone.
Choose the Approve option.
- Now the MFA is configured.
Please note, the displayed 6 digit number is NOT REQUIRED to be entered anywhere. This is because, we are using the Receive Notification for Verification option.
- In the next step, it will ask another number for verification in case you lose your mobile. Add a different number here. Click Next.
Special password for Outlook and Skype for Business
Outlook client and Skype FB does not support MFA. Your regular account password will stop working as soon as MFA is configured. Outlook will keep asking for your password and your regular password will not work. Now you have to use a special password.
That is the one shown to you in the next dialog as Step 4. Copy that password and use the same password it for Outlook and SFB. Use one password for laptop and one for desktop / mobile, etc.
If you use any ActiveSync client on mobile, that will also require a password. Technically you can use this password, but it is better to create another one.
How to do that? Go to Portal.Office.com, click on your photo, go to My account – Security – You will see a Create App Passwords option. Create a new one from there and use it.
User: Regular Office 365 MFA login
Now onwards, MFA is enabled. Now login using two steps
Step 1: Login using UID PWD as usual.
Step 2: Immediately, you will receive the Approval notification on mobile.
Chances of your account being hacked reduced by 99% now.
Share this with everyone you love and make their digital lives also safer.
Very short blog. Speedtest.net or dslreports.com are commonly used for checking Internet speed. Here is https://fast.com as a quick and ad-free alternative. Try it out. I find it to be the best Internet speed test out there.
It is created by Netflix. They wanted users to have a quick way to check bandwidth with no bloatware around it. It also performs what is called as a “Loaded latency” test – a modified Ping test.
Click Settings to adjust how long it tests the speed. This is useful if you expect fluctuation in the speed over time.
Here is a list of Macros I have written for various Office tools. Usually we feel that any repetitive task requires a macro. That is a wrong concept. Typically, repetitive tasks indicate that the method you are using is inefficient. Usually there is an efficient way to do the same job – which eliminates the repetition.
Continue reading Macros Knowledge Pack
Recently a customer asked me to compare SharePoint vs. Teams. Customer found my reply clear and concise explanation of the key points. Therefore, I am posting it as an article. (Reading time 4 min) Continue reading SharePoint vs. Teams