Great guide to harnessing Python in Excel
In a great development for data analysts and coding enthusiasts, John Lam’s new guide that expertly explains Python programming with Excel from the start to a practical example. Book of Python in Excel goes through the basics like using the XL() function in Python to grab data from an Excel workbook, importing external data and […]
Patch Tuesday â Two November 2023 highlights
Hereâs just a few of the security breaches that caught our eye from a total of 63 security flaws patched in this months dump of fixes from Microsoft. Â Including five âzero-dayâ bugs plus another 20 Edge browser security bugs fixed earlier in November. Weâve included links to more detail and specific patches for each version […]
Eiffel Tower đŒ emoji in Word, Excel, PowerPoint and Outlook
Insert the Tower đŒ (Eiffel Tower, Tokyo Tower) emoji, symbol or stock photo into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The emoji is commonly called âEiffel Towerâ in the west but it was originally intended to show the Tokyo Tower. Thatâs why some emoji are colored […]
Add comments/help to your Office VBA code
ChatGPT is a powerful tool that can enhance your Office VBA code with comments and help. It or Copilot can analyze your code and generate explanations, tips, and examples to make it easier to read and debug One of the modern AI tricks is to help write and understand programming code. We’ve already looked at […]
Trademark âą symbol in Word, Excel, PowerPoint and Outlook
Type the Trademark âąÂ TM symbol as text and icon into Microsoft Word Excel PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Trademark âą TM symbol is, strictly speaking, called the Unregistered Trademark symbol. Its counterpart is the Registered Trademark Âź Trademark in Word and Outlook The Trademark âą sign has an […]
Registered Trade Mark Âź symbol in Word and Office
How to insert the Registered Trade Mark Âź symbol as text or icon into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Registered Trade Mark Ÿ not to be confused with the Unregistered Trade Mark  ⹠ symbol. Registered Trade Mark Âź in Word and Outlook The Registered Trade Mark […]
Care of â symbol in Word, Excel, PowerPoint and Outlook
The Care of â  symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Care of â symbol is one of those useful symbols youâll never see on a keyboard and have to go hunting for. â is used on envelopes and addresses, it refers to […]
Microsoft Office photo editing with Apollo 8’s Earthrise
As a quick example of what’s possible, here’s a quick look at some photo editing options in Microsoft Office, Word, Excel, PowerPoint or Outlook emails. Since it’s Christmas, we’ll use one of the famous Apollo 8 Earthrise images. We’ve already talked about how Apollo 8’s Earthrise, as we know it, is a cropped, rotated and […]
Fast umlaut Ă€ Ă« ĂŻ ö ĂŒ in Microsoft Word and Office
Once you know the âsecretâ shortcuts, itâs easy to type the umlaut vowels Ă€ Ă« ĂŻ ö ĂŒ Ă Ă Ă Ă Ă in Word and Outlook but, alas, itâs not the same in Excel or PowerPoint. There are alternatives in Windows and Mac if youâre not using Word. There’s also a stand-alone š umlaut […]
Satellite Antenna đĄ emoji in Word, Excel, PowerPoint and Outlook
Type the Satellite Antenna đĄ symbol/emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Satellite Antenna or Dish đĄÂ symbol can be used for modern television, radio, GPS or wireless broadcasting generally. Can be used with the Satellite đ° emoji or icon. How Satellite Antenna đĄ looks […]
How to quickly switch between Word and Office windows
Often you need to switch between windows of the same program, so there should be a quick keyboard shortcut to do that. Here are your options in Windows or Mac. Whether youâre moving between Word documents, Excel workbooks or PowerPoint decks or Outlook emails, the need is the same. You want to quickly move between […]
Satellite đ° emoji in Word, Excel, PowerPoint and Outlook
Insert the Satellite đ° emoji or icon into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Satellite đ° looks in different fonts. In Windows fonts only Segoe UI Emoji and Segoe UI Symbol have the Satellite emoji. As usual the Apple version (Apple Color Emoji font) looks […]
Check an Excel option for little performance boost
Thereâs an obscure little Excel option thatâs worth checking to give you a little performance boost. The choice is File | Option | Advanced | Print | âInclude fonts that are stored on the printerâ An obscure option that most people never bother with. âPrinter fontsâ are fonts in the printer itself which Windows can […]
Monospace font makes a difference to Excel formulas
Excel 365 for Windows and web have a different font for the formula bar. The monospace font should be easier to read and understand. For as long as thereâs been Excel, formulas have been shown in a proportional font. Probably to fit as much text into the available screen space. Now screens are larger and […]
Value Preview is coming to Excel formulas
Excel 365 for Windows and Web is getting a great new feature called Value Preview. Youâll be able to see the current value of any formula part just by hovering over it. Itâs simple and most people wonât even notice it except by accident. Just hover the mouse over part of a formula to see […]
Office 2019 & 2016 lose an important part of their support
Microsoft has stopped supporting connections from Office 2019 and Office 2016 to their Microsoft 365 online services. Itâs another âpassive aggressiveâ move to get customers off older versions of Office and onto Microsoft 365. Both Office 2019 and Office 2016 will continue to be supported with bug and security fixes until late 2025 however Microsoft […]