Getting rid of Money in Excel
Money in Excel shows up on the Home tab once you’ve opened the Microsoft template. Here’s how to remove its button from the ribbon or completely remove the add-in from Excel. As soon as you open and use Money in Excel, it adds itself to the Home tab on the extreme right. Microsoft probably thinks […]
Money in Excel goes public
Microsoft has gone public with their Money Excel template to import and manage financial transactions from bank accounts. There are some undocumented tricks available and an important security recommendation that Microsoft overlooks. Money in Excel can import transaction details (US bank accounts only) and show current balances. And convert that into snapshot views to see […]
Exchange Rate support in Excel 365
The latest global exchange rates can go directly into Excel 365 for Windows and Mac. No plugins or extras are necessary because it’s in Excel 365 though it’s hiding away. Foreign exchange rates are part of the Stock data type. They weren’t part of the original Stocks data feed but have been added very quietly. […]
What’s new in Office for Windows – May 2020
Some useful new features have now been rolled out to the public versions of Microsoft 365 (Office 365) for May 2020. Word, Excel, PowerPoint and Outlook all have improvements. Two we’ve already told you about, the other is new. Stock Images, Cutout People and Stickers Or what Microsoft calls “New images to bring your documents […]
Recovering lost Word for Mac documents
If you’ve lost or accidently deleted a Word for Mac document (or Excel or PowerPoint) there are various places to look for it some might not occur to you. This article is also helpful if you’re trying to find and delete any files or documents that must be removed for privacy reasons. Time Machine MacOS […]
‘Tell me’ help now in Mac Office 365 with the same limitations
‘Tell me’ help box is now in Microsoft/Office 365 for Mac as a way to find features on the ribbon. However it continues to have the same limitations that are in the Windows version. Look for the lightbulb and ‘Tell me’ box beside the ribbon tabs. Type in a phrase and Office will show relevant […]
Fantasy Football ranking and analysis in Excel
Microsoft Excel is the perfect tool to analyze and rank your fantasy football ranking. This article explains how to import players, other rankings and add your own opinion. How to Build Your Own Fantasy Football Rankings “There is no reason to re-invent the wheel by typing out all of the players, positions, teams, and analyst […]
Pinned Save folders in Microsoft 365
Word, Excel and PowerPoint 365 for Windows are getting better control over what appears on the new-style Save dialog. Folders can be ‘pinned’ to always be show up in the list and a quick way to share a document. But a major annoyance remains unchanged. On the ‘Save this file’ dialog under Choose a location […]
Coronavirus global statistics, Excel workbook update
A friend of Office Watch has enhanced our latest COVID-19 global statistics workbook and offered to share it with all our readers Phil Y from Sydney is interested in the number of active Coronavirus cases and how many new cases. That data was in the external connection so he made a different worksheet with the […]
Combined Drawing Tools in Word 365 and other Office programs
The Drawing Tools in Word 365 is now larger with separate tools like Lasso and Eraser now in a single combined gallery. There are other changes and new limitations on the Drawing Tools gallery, some of them undocumented. Compare that to the old Draw tab where the Lasso, Eraser and Add Pen were separate from […]
Get in line for Money in Excel
Microsoft is testing a new feature or template, Money in Excel. You can apply to be one of the first to try it. Money in Excel is a separate Excel ‘premium’ template that will connect with bank accounts, import transaction information and display as charts and lists. Transactions Bank accounts can be linked into Excel […]
X Æ A-12 in Microsoft Word and Office
Elon Musk and partner have named their child X Æ A-12 (no kidding) how do you type Æ in Microsoft Word and Office generally. The child’s name doesn’t trigger any spelling or grammar errors in Word. No squiggly lines. What is Æ ? Æ or æ is a a-e ligature that was used in English […]
Workbook Statistics finally in Excel
A long last, Excel is getting a quick summary of the workbook statistics including the bounds of the sheet, tables, formulas and external connections. Look on Review | Proofing | Workbook Statistics in Excel 365 for Windows or Mac. There are details for the currently selected sheet and the whole workbook. It’s similar to the […]
Excel worksheet with global COVID-19 stats – update
We’ve updated our workbook that imports the latest COVID-19 statistics and combines with population data through Excel 365’s Stock Data Type. No technical changes in the workbook but we’ve added a few more ‘interesting’ or outlier countries. Plus some repeat help tips. Download COVID-19 Global Statistics workbook there’s also a limited Excel 365 for Mac […]
Moving Average in Excel Charts
Adding a moving average line to an Excel Chart is very easy, just a few clicks, with many options. Any chart with a series of values over time will benefit from a trendline like a moving average. What is a moving average? An average / mean is a single value representing a list of numbers. […]
Search My Files is the better way to find files, PDF and Office documents
Nirsoft’s SearchMyFiles has received a major boost. It can now search inside Office documents and PDF’s. SearchMyFiles is the Windows search tool that should be included with Windows. It’s interface might be old-fashioned but all the options are visible, including some not available in Windows. Some of the highlights in Search My Files ‘Use Windows […]
