In partnership with
Hey everyone — it’s John from On The Pulse.
How are you all doing this week?
In this edition of On The Pulse, we’ll show you how to create a community in Viva Engage, along with some useful tips for Word and Excel.
This week’s topics include:
🌐 Translate Selected Text in Word Online
🗑️ Remove Duplicates Easily in Excel
👥 Create a Community in Viva Engage
Let’s Go!👇
Also — I’d love to hear what you think of On The Pulse. Whether you love it or hate it, or there’s something new you’d like to see included, hit “reply” and share your thoughts!
👥 Create a Community in Viva Engage
Thanks to @mikefon1530 for this week’s video suggestion.
We hope this helps!
👋 Video Requests
What video content would you like to see? Leave us a comment on our YouTube community page and we’ll give you a shout-out if we select your video suggestion!
Looking for unbiased, fact-based news? Join 1440 today.
Upgrade your news intake with 1440! Dive into a daily newsletter trusted by millions for its comprehensive, 5-minute snapshot of the world's happenings. We navigate through over 100 sources to bring you fact-based news on politics, business, and culture—minus the bias and absolutely free.
🕒 TIME-SAVING TIPS
🌐 Translate Selected Text in Word Online
You don’t need to use add-ins or Google to translate text in Microsoft Word. Just follow these simple steps:
Select the text you want to translate. (1)
Go to the “Review” tab at the top. (2)
Click the “Translate” icon. (3)
Ensure the correct language is selected in the “To” select box. (1)
Click the “Insert” button. (2)
🗑️ Remove Duplicates Easily in Excel
If you need to remove duplicate values in Excel when data cleansing, just follow these simple steps:
Press Ctrl + A (Windows) or Command + A (Mac) to select the data.
Go to “Data” at the top. (1)
Click “Data Tools” in the ribbon. (2)
Select “Remove Duplicates.” (3)
Note: When removing duplicates, Excel will delete entire rows where the selected columns contain identical values.
For example, if the “ID” column contains two rows with the same ID, removing duplicates will keep only the first occurrence of that ID, and all other rows with the same ID will be deleted.
If you only want to remove duplicates within specific columns, uncheck the box next to “Select all columns.” (1)
Select the columns you want to check for duplicates if required. (2)
If your table has headers, check the box next to “My data has headers.” (3)
Click “OK” to finish. (4)
Click “OK” in the dialog box.
Two instances of “#007” were found in the selected column, in rows 2 and 6. As a result, row 6 was deleted, while the first occurrence in row 2 was preserved.
✅ WRAPPING UP!
That’s all for this edition of On The Pulse.
Thanks for reading and see you soon! 👋