Maya has been a contributor to Office Watch since 2017. She's an experienced Technical Writer working in the gaming, entertainment and financial industries. Boasts a Master of Arts (M.A.) in English Language and Literature. After a stay in Sydney, she speaks both English and Australian . ‘Making a difference’ is her motto in life.
A PowerPoint action button is a shape you can add to your slides, allowing you to hyperlink to another slide or webpage, play a sound, or trigger other actions. It’s an easy way to add interactivity and navigation to your presentation with very little effort. It’s also a way
In-cell charts in Excel provide a powerful method to visualize data trends and patterns. They allow you to quickly derive insights within a worksheet, making information interpretation more straightforward without fussing about with full charts. We’ll explain how to make in-cell charts and then go further and show how to
Excel’s PowerQuery has many clever tricks, one of them is merging and matching data from multiple tables into a single table. Combine, clean, and transform data from multiple sources into the single format you need; a table, PivotTable or PivotChart It’s a simple relational database with relations set to match
Make your own jigsaw puzzle in PowerPoint to gradually reveal a photo or logo hiding underneath. We’ll show how to make the pieces plus a download sample PowerPoint file for our loyal subscribers. You can use a jigsaw puzzle PowerPoint slide as a powerful storytelling tool, ideal for illustrating how
Gantt chart for project management or event scheduling are possible in Excel. Here’s the step-by-step help plus a complete sample worksheet for our subscribers. Gantt chart can be widely used in project management for visualizing project schedules. They break down a project or event into tasks or activities as horizontal
Immersive Reader in Microsoft Word 365, available on Windows, Mac, iPad, and Teams, offers a unique way to view documents. It provides tools to enhance reading skills, pronunciation, and fluency, while minimizing visual distractions to improve focus for users of all ages and abilities. Immersive Reader can declutter your text.
Excel PivotTable can show a count of unique items if you know where to look. Handy to see the number of customers, products or students from a long data list. What is the count of unique customers who made purchases in each region? How many unique products were sold in
There’s a way to link someone to view a specific slide in a PowerPoint presentaion which is a lot faster than hunting through a big slide deck. Providing a direct link to a specific part of your slideshow not only streamlines the process of receiving feedback but also enables them
Outlook for Windows has both automatic and manual options to translate incoming messages into a language you understand. We’ll explain the choices available and the Outlook settings that are in a strange order. Microsoft Translator supports over 100 languages, enabling users to translate text across a diverse array of linguistic
Excel has some nice choices for clearing out cells quickly. You can remove the contents, the formatting only or both contents and formatting plus choices for deleting just notes, comments and cleaning up links. As you can see the drop-down menu Home | Editing | Clear offers options such as:
There are two options for changing the default fonts in Excel, either for new blank workbooks or existing spreadsheets. Maybe you prefer another font. Perhaps the old default font until mid-2023, Calibri. Or a spreadsheet specialist font like Goldman Sans. Maybe your organization or client has a preferred font? Go
Here’s the simplest way to switch from Aptos fonts in Excel 365/2021/2019 to either the previous font (Calibri) or some other font. In Excel, Aptos Narrow is the new (mid-2023) default font style with a font size of 11, Black. What if you don’t like the new default font? Aptos
Selection Pane is essential in Word, Powerpoint and Excel to hide or display the objects or to change the order, rename objects, group / ungroup, and delete objects. If you’re using images, graphics, Text Boxes, charts, SmartArt or other objects, the Selection Pane is a must. So, let’s start with
To my horror, I encountered something strange while working on a Word document with “strung out” or ‘stretched’ text on the last two lines with huge gaps of space between them. Here’s the two ways it can happen and the four fixes available. A stretched-out line in a Word document
If you want a list of numbered items using only odd or even numbers; how do you do that? Are you thinking of Word’s automatic numbering feature? The answer is “Yes” if you add little Word trickery. What exactly you need to do is use the Numbering features but leave
By Mayurakshi Mohapatra Adding a picture to an Outlook contact is a good way to make the contact more identifiable. If you are bored seeing the initials or boring graphic next to the Outlook contact name, no worries, at all. Outlook lets you add, change or remove an existing picture
