The Python Editor for Excel is a welcome innovation of the Microsoft Garage project making editing and debugging Python code in Excel a lot easier. Python Editor add-on for Excel mirrors the functionalities of renowned integrated development environments (IDEs) using the code management system behind Visual Studio Code. Sample code
Microsoft has fixed the big hassle that comes with the otherwise excellent Lambda() feature in Excel 365 with the new Advanced Formula Environment. Office Watch has sung praises over the power that Lambda brought to Excel. It’s the ability to write custom functions within Excel but without VBA macros. Proper
Unfortunately, copying an image made in Designer isn’t as simple as it should be. Here’s how to grab images made with Designer to use in your own Office documents. Don’t wait, start using Microsoft Designer now It’s easy to paste an image into Designer. Just copy the image from your
Here’s how to get the new Microsoft Designer app for iPhone and Android smartphones. Also how to share designs between the mobile app and the full Designer web app. Get the Designer app Go to https://designer.microsoft.com/install and scan the QR code provided on that page That will open the App
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 |
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
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
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
