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 Excel’s Stock / Currency data […]
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 change value but Excel does […]
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 called ‘Water Pistol’ but searching […]
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 a curve, but that’s a […]
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 | Link in PowerPoint is one […]
