“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.”
Put the latest stock prices, 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.
Not only do we show you how to do it, we’ll give you the worksheet, document and presentation files. Open them up in Excel for Windows and start right away.
In recent years, Microsoft has made great improvements to Excel for Windows around data importing. A lot of this has been obscured by changed branding 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 Excel’s 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:
How to make a spreadsheet with live updates in Google Sheets and link it into Excel automatically.
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. There are tips on the practicalities of getting live data streams like viewing the ‘raw’ data, getting API keys, Excel’s security options and Internet privacy.
We don’t just stop at Excel. 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 into Excel 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 need.