Business Assist – Forecast is a new Excel add-in from Microsoft which forecasts future volumes based on past data. How to use the add-in, if you can and understand its limitations. From the promotion, Business Assist – Forecast sounds like a useful tool but it’s a different story when we tried the add-in for ourselves. […]
The Microsoft Designer home page has a major update that highlights some of its hidden features. These changes aren’t just cosmetic, but are a welcome boost to the functionality and usability of the opening page. The new Designer home page is in two parts: Get Started and My Projects. Get Started Get Started has links […]
Here’s how roaming email signatures work (supposedly) in Outlook 365, Outlook 2021 and 2019 for Windows including the traps and pitfalls for the unwary. What is a roaming Signature? For most of Outlook’s history, Email Signatures were saved on each computer/device only. If you have multiple computers with Outlook, you setup signatures on each device. […]
Here’s the Excel trick to grab a recent stock price or currency exchange rate using a single cell. It bypasses the multiple steps needed for the Stock/Currency data type and the annoying lack of configuration in the standard stock/currency data type. The single cell trick makes for more compact and workbook plus letting you select […]
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 […]
