![]() The management of the incoming feed is soooo much better. It’s not just SQL Server and primitive web page scraping anymore. The range of data sources is much improved. The data links can be ‘one-off’ or updateable. From there you can work with the data in a standard worksheet, PivotTable, PivotChart etc. 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. Promoting these new features isn’t helped by eye-glazing descriptions like this “… enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured,” And there’s been bewildering name changes, so you’re forgiven for not following developments. It’s happened gradually and not always communicated well to customers. Microsoft has been improving the data connection features in Excel, especially Excel for Windows. Currency Exchange Rates and Stock/Index data can automatically update your Excel worksheets. We’re in the middle of a series on getting live internet data directly into Excel and it’s been a pleasant surprise. Thanks for joining us! You'll get a welcome message in a few moments. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |