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
OneNote for Windows can straighten handwritten, digital ink, text so it’s nicely even across the screen. We tested Straighten to see how it really works … and it’s not bad. Microsoft doesn’t provide a working example of straighten just a mockup with grey lines and nothing like the real OneNote
Word, PowerPoint and OneNote 365 for Windows have digital ‘ink to text‘ feature to not only handwrite into documents but also edit text and add bullet or numbered lists. Ink to Text requirements Before we explain the new feature, we’ll detail the specific requirements of the new ‘Ink to Text’
A strange case of letter spacing with a Microsoft font showing differences between Word and PowerPoint. Here’s the anomaly with three possible fixes for it and similar situations. Office Watcher Paul B noticed this peculiar spacing between a fullstop/period and digit 1 with the Tenorite font. In PowerPoint, the two
Computers are being infected with at least eight different viruses in an attack that uses steganography to hide nasty code in images linked from Word and Excel documents. But there’s good news for most Office users. Steganography is a way to hide text or code in an image or object.
Quickly switch accounts while using Microsoft Office 365, Office 2019 and Office 2021 for Windows and even have different logins in separate programs. Many people wear different ‘hats’ while using Office. There’s a Work ‘hat’ or ‘hats’ with more than one job. Plus your personal or home role. Sometimes even
The File Open and Save dialog boxes in Office have many not-obvious features which let you do a lot of file management and housekeeping on the spot. You try to save a document and realize you need a new sub-folder. Or open a document and want to move it to
Pictures in Word, Excel, PowerPoint and Outlook can make the file sizes at lot larger than you expect. Here’s how to make images smaller (in file size) for Office documents without changing the look of the document, slide etc. The images in a document are what take up a lot
Microsoft has announced ‘extras’ for Microsoft 365 Basic but we can’t see anything new that wasn’t promised over a year ago and delivered six months ago. It’s a just a simple PR stunt that worked. The ‘Microsoft 365 Basic’ plan has just 100GB of OneDrive storage plus a 50GB Outlook.com
The world can be divided in many ways — how about by paper sizes? Letter/Legal/US sizes vs A4/Metric. Microsoft Word makes it easy to cope with both even with different paper sizes in one document. There’s a very handy way to rescale between Letter <> A4 for printing. Amazing Maps
How to insert the Coin 🪙 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Coin 🪙 looks in different fonts Only Segoe UI Emoji font has the coin symbol in standard Windows. Coin 🪙 codes These are the
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
Teams app is being forced out of the Microsoft Office bundle. It’s a compulsory divorce with a side-benefit for anyone who doesn’t use Teams or doesn’t use it often. Microsoft has now decided (under duress) to stop selling their Teams app as part of Microsoft Office / Microsoft 365 bundles
Pivotby() is a new and easy way to make PivotTables in Excel. It’s one of two new ‘aggregation functions’ but we prefer to call them fast summary powers. We’ll dig into the detail of what PivotBy() can do. Excel has been able to group or combine data for many years
For many readers being able to edit incoming Outlook messages is just a handy feature, but for anyone in the legal or corporate world it could have ‘interesting’ consequences. In Outlook for Windows, open the email in a full window (not the Reading Pane) then go to Message | Move
What’s the story behind the “Update Licence” option that’s appearing in Microsoft 365 apps? What does it mean and when to use it? In Microsoft 365 for Windows you might see a new item on the bottom of the File menu called “Update Licence”. It’s strangely prominent and misleading, based
There’s a useful but niche Excel warning about date with two digits for the century. That’s a useful precaution but sometimes the warning is wrong! Those of us around at the turn of the century will remember the Y2K problems and possible mistakes with a date that has only two
Copilot AI makes writing Excel formulas a lot easier but you still need to check the results to make sure Copilot has understood want you want and gives the right answer. There’s a lot of hype and promises about how AI can help make work easier. That’s not as true
Drop in some Easter flavor to your documents, slides or emails from right inside Word, PowerPoint, Outlook and Excel. Either religious (Ascension, Crucifix etc) or secular (eggs, chocolate, bunnies) images and graphics are available. Modern Office, especially Microsoft 365 have stock images and icons from a large collection compiled by
There’s more than one Credit Card 💳 image available in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Credit Card 💳 looks in different fonts. Only two standard Windows fonts have the credit card symbol; Segoe UI Emoji and Segoe UI Symbol.
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows
The new Outlook (in preview) did seem to be enforcing a Microsoft 365 software license in a way that other Outlook software has never done before. Happily that’s been fixed. Here’s what happened, to explain and debunk stories still going around. Outlook (new) is the preview web app that Microsoft
Microsoft has announced some of their plan for the changeover to the newer, totally rebuilt, Outlook for Windows. The changeover plan will be in four stages; Opt-in, General Availability, Opt-out and finally Cutoff. There are no specific dates given, just a broad structure but the whole switch from ‘classic Outlook’
