Microsoft is replacing the current ‘My Office’ gateway app with a new ‘Office’ app for Windows 10. The Office app is a gateway to your Word, Excel, PowerPoint documents plus Outlook, OneDrive and SharePoint. Source: Microsoft The official Microsoft blurb: ” Quickly switch between apps. See all your Office apps
If you’re looking for 2019 calendar options, open up Microsoft Excel. Excel has a wide range of calendar templates to choose from. Go to File | New and type ‘calendar’ into the search box. There’s a proverbial embarrassment of riches. Pick a year All the Excel templates apply to any
Musicians with Excel skills might like to try Excel MIDI an Excel file with a simple sequencer that plays MIDI music. Made by ruiseixas from Portugal, Excel MIDI is an Excel worksheet downloadable from SourceForge. It’s an .XLSM file so you’ll have to enable VBA content to let it work.
Office Watch reader, Meredith M. asks a question we’ve heard many times before. Why can’t you buy individual Office programs instead of paying for an Office bundle with programs you don’t need? “My issue: I need ONLY Word, Excel and Access–but I NEED them. I know that I cannot buy
Our article Track the largest companies Market Caps in real time got a lot more interest than we expected. Maybe because Apple and Microsoft are so close in value at the moment. So we’ve made the worksheet available for Real Time Excel readers. Market Capitalizations.xlsx also includes an example of the
It’s been five years since the Word, Excel, PowerPoint and other Office icons were given a new look. Now they’ve been announced and, frankly, we could not care less. New look icons don’t make any difference to anyone’s daily use of Office. It’s like supermarket groceries that boast ‘New Packaging’
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
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.
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
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
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
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
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
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 ).
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.
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.
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
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
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
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
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
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
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
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
