Python in Excel adds lots of new possibilities to Excel including a new way to the latest UTC time. Here’s the full code, how it works and a fix for an annoying problem. Knowing the UTC / GMT time is important for comparison with the ‘Last Trade Time’ data from
There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are important with the Stock and Currency data type in Excel 365 but also other situations. Normally Excel will update itself when you change a cell value. These days there are situations where cells
Insert the Water Pistol or Gun emoji 🔫 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. AND how to make the ‘gun’ point to the right. Water Pistol 🔫 symbol is the only ‘gun’ style symbol in the emoji collection. It’s officially
There are at least ten ways to ‘reverse’ ‘mirror’ or ‘flip’ text or images in a Word document. Horizontal, vertical, reversed, combined or any angle you like. When people say those terms they can mean different things so we’ll look at many options and how to do them. Also along
Modern PowerPoint has made an ‘improvement’ to slide linking in PowerPoint which hides an important feature that’s been in PPT for years … linking to slides or web pages. Sometimes Microsoft gets so enthusiastic about some innovation they forget the basics that customers use on a daily basis. Insert |
Vale Dennis Austin, one of the original creators of PowerPoint has died at the age of 76. Back in 1987 Mr Austin and Robert Gaskins developed ‘Presenter’ for the Mac with some then unique features. A “direct manipulation interface”, what we now call WYSIWYG and take for granted in modern
Inspect without color is one of the more interesting and useful Accessibility tools in PowerPoint 365. It shows a slide in ‘black and white’ or ‘greyscale’ which is useful for more than helping color blind people, Inspect without Color can help improve the readability and design of any slide. Inspect
All about the “Lifetime” or “Lifetime Subscription” Microsoft Office that many web sites are selling. Is it a legitimate, legal version of Office? “Lifetime” Office is NOT a word that Microsoft uses to describe any Microsoft Office product and for good reasons we’ll explain. Lifetime Office is used by other
Microsoft 365’s mail service had troubles on Monday 4th for almost 24 hours. Or did it? Microsoft’s reporting of the incident has been inconsistent and had more than the usual self-serving blather. The Microsoft 365 email outage started on Monday 4th September about noon UTC (early morning in the US)
An undocumented surprise for Office 2021 and Office 2019 customers. The new Aptos fonts are automatically installed in Office 2021/Office 2019 even though Microsoft insists they are for Microsoft 365 only. However, there’s a crucial difference and strange anomaly between how Aptos fonts work in Office 2021/2019 vs Microsoft 365.
Type the fun Eyes 👀 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eyes 👀 symbol / emoji is a bit of fun for documents and PowerPoint slides. How Eyes 👀 looks in different fonts. Eyes is available in symbols fonts like
Microsoft 365 / Office 2021 Cloud Fonts are only available in Office programs … that’s the official line unless you know the trick to make the fonts available in other Windows or Mac apps Cloud Fonts can be selected and installed for Word 365/2021, Excel 365/2021, PowerPoint 365/2021, Outlook 365/2021
A few years ago, Microsoft quietly added a little Word trickery to make it easier to Insert Symbols and not get the dreaded blank box or box with question mark. Here’s what Word does and how to workaround the, sometimes unhelpful, fix. Back in the olden days of Word 2007
Google unveiled a little update designed to streamline the experience for Outlook enthusiasts. Outlook meeting organizers will now appear as that in Google Calendars. According to the Google Workspace blog, Google introduced a subtle yet notable modification in the integration between Calendar and Outlook. The update clarified: Previously, if a
Insert the Ballot Box with Ballot 🗳 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ballot Box with Ballot 🗳 symbol can be used for any situation around voting or choice. For example to decorate this PowerPoint slide. How Ballot Box
What are the legal limits on fonts supplied by Microsoft in Windows or Microsoft Office? Is there anything special for the Microsoft 365 only Aptos fonts? A few readers have asked us about the font license rules that apply to fonts provided by Microsoft. Can the fonts be embedded in
There are now four ways to get your Threads account appearing on your Windows or Mac desktop. Yes we have a Threads account (follow us @officewatch) . All our new articles are posted on Threads, as well as Twitter and Facebook. Web Page The new Threads social media now has a
Insert the Statue of Liberty 🗽 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. “Lady Liberty” has symbol/emoji plus stock images, SVG icons or 3D models. How Statue of Liberty 🗽 looks in different fonts Two standard Windows fonts have the Statue
There are a lot more Office Icon or SVG graphics available than the ones in Microsoft 365, Office 2021 or 2019. Jazz up your documents, emails or presentations with a wider range of graphics than the (overused) ones that come with modern Word, Outlook or PowerPoint. Microsoft 365, Office 2021
Word and PowerPoint have options to embed a font into the document, so why doesn’t it work? In theory you can select the ‘Embed fonts’ option for a document / presentation and all the necessary fonts will be included in the document. That means the fonts will appear, as the
Inside the Microsoft Office (Word and PowerPoint) embedding fonts feature within documents. Font embedding adds the font into the document/presentation file itself so that anyone reading will see the same text as the creator. Normally fonts are installed on the computer and used by whatever programs need them. If the
A ‘side by side’ comparison of the current Office default font for headings (Calibri Light) and the new default Aptos Display. Aptos Display has thicker strokes/lines than Calibri Light and is, perhaps, more prominent as a heading font. See the slider below to compare the two heading fonts. See New
Here’s a ‘side by side’ comparison of the current Office default font (Calibri) and the new default Aptos. There’s not a lot of difference between Aptos and Calibri fonts to the unpracticed eye. See the slider below to compare the two. See Heading fonts in Office, new and old side-by-side
It seems possible that Office 2021 is really installing Microsoft 365 with the license details controlling what features are available. In some cases, it’s an important difference to keep in mind. A few bits of information suggest that there’s more commonality between Office 2021 and Microsoft 365 than you might
