Monthly and Yearly Date Arithmetic with Edate() in Excel
Adding or subtracting months in Excel is easier with the Edate() function. As you probably know, Excel uses whole numbers to calculate dates. Add 1 to an Excel date adds a day. How to add a whole month? How to make Excel jump a whole calendar month? For example from 1 January to 1 February […]
Office for iPhone/iPad gets Icons or SVG graphics
Office for iOS (iPhone / iPad ) is getting the Icons or SVG support already available in Word 365 for Windows. Icons now available to Office iOS Insiders on the Insert tab. There are 500 to choose from … Source: Microsoft Available in the Word, Excel and PowerPoint apps for Android. Icons are really SVG […]
Excel gets Insert data from Picture
Excel for Android is getting the ability to insert numbers and text from a picture. Insert | Data from Picture is now available to Office for Android Insiders and will rollout to the public in coming months. It’s OCR (Optical Character Recognition) specialized for Excel. Source: Microsoft You can get a similar result by taking […]
More Real Time Excel, out now
We’ve added more to Real Time Excel, our comprehensive guide to adding the latest information into Excel easily and automatically. Real Time Excel already has in-depth coverage of Linked Data Types, a new and truly interesting addition to Excel for Windows. On 15 October 2018 we added a bit more to the already expansive coverage: […]
Office apps for Windows 10 get sidelined
Word, Excel, PowerPoint and other Office apps for Windows 10 have been sidelined by Microsoft with no new features planned. Bad news for anyone still using a Windows Phone. The Windows 10/Mobile apps will continue to work but no more features are planned. This ‘no more features’ decision appears to apply to Word, Excel, PowerPoint, […]
Office 2019 starts public release
Office 2019, the new non-cloud version of Office for Windows and Mac, is now available to volume licence and commercial customers. This is the ‘cloud free’ or, as Microsoft call it the ‘on-premises’ version of Office desktop. It has no cloud related features and is ‘feature fixed’ with no future enhancements. There’ll be security and […]
Excel’s Stock data type gets wonderful update
Insiders (Fast or Slow) will start seeing a major change to the date information they get from the Excel Stock Data type. All Excel for Windows ‘Insiders’ can try out the Stock and Geo data types. They are a new way to get external information into Excel without the hassle of data connections. Date Format […]
Exploring the Office clipboard
The Windows clipboard is quite limited but there’s a better one hiding inside Microsoft Office for Windows. It can collect more items, paste in any order and be cleared when you like. We’ll also show how to keep the sometimes annoying pane out of the way. You’re about to hear more about the clipboard because […]
Office hacks come faster than ever before
A new report from Sophos shows how hacking via Office documents has changed of lot in 2018 with new attacks coming much faster than in the past. Microsoft’s assurances that a security bug (sorry ‘exploit’) hasn’t been used ‘in the wild’ doesn’t mean a lot. Office document hacks made in bulk The people who find […]
Significant improvements in Office 365 Home, Personal and University
Microsoft has announced some truly important improvements in what you get with Office 365 Home, Personal and University plans. The Home plan will be available for six family members instead of five. How Microsoft calculates use of Office software is changing and for the better. All these changes apply from 1 October 2018 onwards for […]
UK residency or Statutory Residence Test (SRT) – an Excel worksheet
After our recent Excel worksheet for visitors to Europe we were asked for a similar one to help people stay onside with the UK Statutory Residence Test (SRT). This is a test to decide if someone is a UK resident for tax purposes. Depending on the situation, a person can be in the UK for […]
August 2018 security fixes for Office and Windows
“More of the same” in August 2018’s round of security fixes for Microsoft products including Windows, Office, Word, Excel and PowerPoint. Overall there a sixty security flaws fixed this month alone, including two ‘zero-day’ bugs not previously known to the public. We’ve all become accustomed to this never-ending stream of security fixes for known exploits. […]
Big Word 2016 update in the August 2018 updates for Office
There are a dozen bug fixes for the Windows versions of Word 2016 buried among the non-security updates for Microsoft Office this month. And an extra feature for PowerPoint 2016 and 2013 for Windows. We’ll look at this important Word 2016 update first before listing the other bug fixes for Office 2016 and Office 2013 […]
New name for ‘Office 2016’ for Windows and maybe Mac too
Microsoft seems to be moving towards a name change for ‘Office 2016’. They haven’t announced anything directly, but their documentation is changing for Windows and perhaps Office for Mac as well. If you’re confused, don’t feel bad because Redmond isn’t making it easy. They are moving gradually towards naming Microsoft Office as a service instead […]
Make a custom ribbon tab for Word, Excel, PowerPoint or Outlook
Here’s how to make a custom ribbon tab in Word, Excel, PowerPoint or Outlook and how Microsoft has left customers shortchanged for the last decade. We’ve already talked about customizing the Quick Access Toolbar (QAT) for certain documents. You can make the QAT adapt according to the document you’ve opened. Alas, that’s not possible […]
Excel Stock and Geography features reach ‘Slow’ Insiders
The truly interesting Excel live Stock price and Geography data feeds have reached the next release stage, ‘Monthly Channel (Targeted)’ better known as ‘Slow’ Insiders. Stock and Geo data types are now in Excel 2016 for Windows, Office 365 subscribers who have chosen the ‘Monthly Channel (Targeted)’ Insiders release. Version 1807 (Build 10325.20030) or later. Stock […]
