Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
Excel SUM anomaly
Excel can’t add up reliably and it never has. It’s an important limitation of computer software that everyone needs to be wary of. Phil N sent us an interesting Excel worksheet. He’s simply adding a column of numbers starting with a negative number then positive numbers – the total should be ‘a wash’ – that […]
PowerPoint Cameo gets an important upgrade with Placeholders
PowerPoint’s ‘camera in slide’ feature ‘Cameo’ is getting a welcome boost, if not an essential piece of Cameo. Cameo placeholders can be added to Slide Masters. Cameo is Microsoft’s name for putting a live camera image into a PowerPoint slide presentation. It’s ideal for online presentations. That was fine but the cameo video had to […]
A new way to reach Outlook and Office in a browser
Microsoft has added new web links to access Microsoft 365 mailboxes in a browser as well as some other unpublished new domains to reach Office apps in a browser. The web links are https://Outlook.cloud.microsoft or https://Outlook.microsoft Use one of those links and login to your Microsoft 365 mailbox (e.g. Business, Enterprise or other plan). It […]
All about the Windows 10 Emoji Panel
All about the Windows 10 Emoji Panel, a fast way to type emoji 😁, symbols §⁜✓, emoticons 🙂 and kaomoji (❁´◡`❁) into any Windows app, document, slide, email or message. This is how it appears in Windows 10. If you have Windows 11, the Emoji Panel works differently, see Get the most from Windows 11 […]
Get the most from Windows 11 Emoji Panel
The Windows 11 Emoji Panel is a quick way to type emoji 😁, symbols §⁜✓, emoticons :), kaomoji (❁´◡`❁) and even animated GIF’s into any Windows app, document, slide, email or message. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows 11 when you press Win + . (Windows key plus period/fullstop) […]
A ‘Yes Minister’ Christmas card
A scene from a famous UK sitcom could also be used as a unique and overly literate Christmas card. ‘Yes Minister’ is a famous UK sitcom set in the British Public Service and politics. Sir Humphrey Appleby (played to perfection by the late Sir Nigel Hawthorne) gave amazingly convoluted explanations for the simplest things. This is […]
Five snowflake ❄ symbols in Word, Excel, PowerPoint and Outlook
Five ways to add a Snowflake ❄ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There are three snowflake symbols plus two Office icons. Snowflake ❄ symbols are normally used to show, well, a snowflake or generally to indicate cold or snow. Maybe also as a […]
Oversold mystery typography changes in Word and Outlook
Microsoft is changing the way Word’s Read Mode and Outlook’s Reading Pane looks but it’s hard to know what they’re doing because there’s a lot of oversold hype but little detail. These changes were announced more than two weeks ago and still haven’t appeared on any of our test machines. That’s important because Microsoft’s blog […]
Fix the kerning settings in Microsoft Word and Office
How to use the font kerning settings in Microsoft Office, Word and PowerPoint and fix the default setting for Heading styles in Word. Kerning letters makes a difference as the letters get larger so the setting is more important for headings and titles in Word and PowerPoint. Here’s common Arial font without and with kerning […]
Visual Emphasis makes text more attractive and engaging in Word Online
Word online has a simple, quick way to add emphasis and a little engaging styling to text you’d like to highlight. It’s only in Word online but can be used in other versions of Word. It’s called ‘Visual Emphasis’ and is only available in the browser-based version of Word. At first the feature might seem […]
Try out the Meta image maker – Imagine
Meta has joined the ‘text to image’ AI race with Imagine. Here’s how to use it to make interesting pictures quickly and bypass its current limits. There are so many AI tools out there, in particular ‘text to image’ makers, Microsoft has ‘Generate Image’ in Designer and a separate Image Creator as well as the […]
Debug to understand and fix Excel formulas
Excel Labs has just added a nice formula Debug option that helps you understand the steps inside a formula and fix errors. There are already three ways to look inside a formula; Evaluate Formula, F9 to calculate part of a formula and the recent Visual Preview. Now Microsoft’s Excel Labs Advanced Formula Environment has a […]
Check these Excel Power Query settings before it’s too late
There are two important changes coming to Get & Transform (Power Query) in Excel. Both changes are probably already covered by the current setup but you should check any external data links now to avoid an unwanted surprise. These changes apply from 11 March 2024. Microsoft is a little vague about one of them (TLS […]
Secret shortcuts in Microsoft Designer
Microsoft Designer has secret key shortcuts to quickly insert shapes and text boxes without jumping to the side menus. All you need to do is press a single letter key to insert one of these shapes: R – Rectangle (inserts a square) C – Circle L – Line T – Text Each of these shortcuts […]
Notes vs Comments, understand the difference in Excel
Microsoft messed about with Notes and Comments in Excel 365. Here’s what’s happened, name changes, overlapping functionality and how Excel has gone from ‘Notes’ to ‘Comments’ and now back to ‘Notes’ again! There are now two different ways to add text notes or comments into an Excel 365 cell. The choice of Comments or Notes. […]
How to add notes inside Excel formulas
Here are three ways to add an explanation or note within an Excel formula itself, instead of separate notes. The ‘Achilles Heel’ of Excel or any spreadsheet program has always been explaining or commenting of cell formulas. Adding comments is an important part of any code including Excel’s VBA but it’s MIA from formulas themselves. […]
