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
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
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
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
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
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
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
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,
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
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.
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
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
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
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.
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
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
Office for Mac has quite different and extensible color selection options for text, shapes, pages etc. that are the envy of Office for Windows. We’ll explain them all, eyedropper, swatch, color wheel or sliders, palettes and even pencils. Choose from the same range of colors as Windows, but in many
Here’s all the match colors, color picking or color grab tools in Microsoft Office for Windows or Windows itself. While Office for Mac users have it a lot easier with one central ‘eyedropper’ to choose a color from the screen. Naming the color picking tool isn’t consistent in Microsoft Office,
Google Sheets can now support Python code in a similar but cheaper way than Python in Excel 365 Neptyne has released a Python Add-on for Google Sheets which works in much the same way at the newly released Python extension to Excel 365. The add on includes ‘spilling’ results to
Need a Halloween emoji or symbol? Here’s a quick and searchable list of more than 30 spooky, scary emoji for documents, sheets, slides, emails or messages that you can use or copy. In Microsoft 365, Office 2021 and Office 2019 there are also Halloween icons and symbols for Word, Powerpoint
Office has various options for graphics or images of skeletons or skulls – perfect for Halloween or other gory, scary uses in Word docs, PowerPoint slides or Outlook emails. We can’t offer a 12-foot skeleton, complete with creepy glowing eyes. For this 3.56 meter monster you have to hunt through
Excel 365’s PowerQuery has many wonderful features but occasionally there are common needs that it can’t easily handle. One of those surprising complexities is removing older duplicates but retaining most recent row for each. We’ll explain the simplest solution then why it works. Here’s some sample data on the left
One of the most commonly used and confusing Excel functions is much better in Excel 365 and Excel 2021. Vlookup() has a new, better and easier replacement Xlookup(). It’s a truly good and useful addition to Excel, some might call it a godsend. Xlookup is available in Excel 365 for
A British medical office has made a right mess of selecting trainee anesthetists by the misuse of Excel. Let’s look at what happened and some ways you can avoid similar mistakes. As told in The Register, the UK Anesthetic National Recruitment Office (ANRO) had the job of selecting candidates from
