“A practical guide to automatically updating Office with online information with step-by-step instructions, working sample documents and tips from people who’ve used Office for over 20 years.”
Includes the new Stock data type for Office 365 subscribers which easily adds global stock prices and company data right into your worksheets.
Put the latest stock prices, global stock indexes, exchange rates, Bitcoin even weather details automatically into Excel, Word and PowerPoint.
There’s no need to retype details from a web site or (shock!) a newspaper when Office can do the job in the blink of an eye.
Real-Time Excel shows how to get ‘live’ or real-time data automatically into your Office documents.
Getting those details into Excel, Word and PowerPoint is possible and now easier than before.
A whole chapter on the new Linked data types, how they work, the practical details to handle and a look ‘under the hood’ at how it works.
Not only do we show you how to do it, we’ll give you the worksheet, document and presentation files. Open them up and start right away.
In recent years, Microsoft has made great improvements to Office around data importing. A lot of this has been obscured by changed branding (‘Power Query’ is now ‘Get and Transform’) and the marketing geek speak that the company loves so much.
Real-Time Excel blows past all the marketing nonsense, acronyms and tech speak to show how new features can work for individuals and small businesses.
We’ll show how to use the most common data exchange formats used by public web sites:
You can use the same techniques to grab information from other sources and sites.
Uniquely, we’ll also give you the sample documents used to make this book. Open them up in Office and tweak to suit your needs.
Real-Time Excel is a practical book using real data feeds that you can use today – most of them are free.
There are tips on the practicalities of getting live data streams like viewing the ‘raw’ data, getting API keys, security options and Internet privacy.
We’ll show how to drop fresh information into Word documents or PowerPoint slides.
Yes, there are example Word and PowerPoint documents included so you can see for yourself how it’s done.
Some of the tricks we’ll show you aren’t the usual method that Microsoft demonstrates. We tell you what works best.
If you thought that importing data was too hard or have VBA code to make it happen, check out Real-Time Excel. Chances are that Microsoft has caught up with your needs with a simpler and faster solution of Power Query/Get & Transform.
The ‘bottom line’, as they say, is this: you now have a lot more powerful, yet easier, options for getting data from other sources, arranging it and adding to Excel. From there you can work with the data in a standard worksheet, PivotTable, PivotChart etc. The data links can be ‘one-off’ imports or automatically updateable.
We’ll show you how to do it, step-by-step, so you can make your own connections to similar data that best suits your needs.