Microsoft’s Excel’s Stock data type is premature
Microsoft can’t help itself from releasing a product or feature before it’s ready. They’ve done it again with a premature public release of Excel 365’s Stock and Geography data types. Excel 365’s Linked Data Types feature promises to be a great innovation. At long last there’s a simple way to get current financial information into […]
Refinitiv financial and markets data to be integrated with Microsoft applications and services
It’s not specified in this press release but the announcement means a change in the financial data source for Excel 365’s Stock data type. ” 16 October 2018 Collaboration brings financial data to the masses with simple, direct access to trusted financial data within Microsoft Excel, MSN Money and Bing. Refinitiv, formerly the Financial and […]
Excel 365’s Stock data type, watch the ticker code!
We like Excel 365’s new Stock data type but it’s far from perfect. It’s vital that you make sure you’re tracking the correct stock and exchange by checking the ticker code. Microsoft has been having a difficult time ‘data wrangling’. They rely on outside contractors to supply the price and stock information from about 60 […]
Getting Started with Excel 365’s Stock Data Type
Give Stock or Geography linked data types a try in Excel 365 for Windows. It really is a great innovation and will be better once Microsoft sorts out the data issues. Getting started At its simplest, type in the name of a company and click on Data | Data Types | Stocks Excel goes off […]
Excel 365 Stock data type – how to report problems
Excel 365’s new Stock data type has the potential to be really great. Here’s how to report problems to Microsoft so they can fix them. Real people read the bug reports, especially for a new and developing feature like Linked Data Types. The bug reports help Microsoft staff identify problems and also give them a […]
Stock and Geography for Excel is live, give it a try
A truly interesting new Excel feature is now going public. Stock and Geography are the first two Linked Data Types (LDT) that bring stock prices and geographic info direct into Excel 365. Stock data type gives you information on stocks and indexes from over 60 global stock exchanges. No messing about with PowerQuery, ‘Get and […]
Online Video hack now ‘in the wild’ and Microsoft won’t do anything
A previously theoretical way to misuse Office documents to infect your computer is now ‘in the wild’ and Microsoft isn’t interested in stopping it. Last week we told you about a new way for Office documents to get malware onto your computer. Cymulate discovered that the Online Video feature could be manipulated to download malware […]
Replacing text or separators in selected Excel cells
A little side-trick for converting text dates to Excel dates is replacing the text separator. Excel lets you replace text within the selected cells only. If the text dates are in the correct order (e.g. m/d/y ) but use the wrong separator for your Windows regional setting (e.g. m-d-y ). Excel’s Replace function will replace […]
Online Video now a risk for Office users
Cymulate is reporting how embedded video in Word or other Office documents are another way for criminals and hackers to infect your computer. It’s yet another example of how Word, Excel or PowerPoint documents can be used to get malware onto computers to steal data, becomes bots or other nasties. This trick uses the relatively […]
Convert Excel formula into fixed values or text
Changing an Excel formula into the values is amazingly easy. It’s just a copy and special paste. Another way to think of it is deleting the formula but leaving the results in the cells. Select the cells. In this case from our article on converting text cells into Excel dates. Copy them, using Ctrl + […]
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 […]
