This month’s Power Query for Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.
In the Office 2016 Public Preview, we have provided a set of new charts to give you innovative ways to explore data and tell rich stories across Excel, Word and PowerPoint. Say hello to Waterfall, Histogram, Pareto, Box & Whisker, Treemap and Sunburst—six powerful chart that help you quickly visualize common financial, statistical and hierarchical data in more intuitive ways.
In the May 2015 update of Office 365 we are proud to introduce a new core feature to Power Map: Custom Regions. The Custom Regions feature allows data to be mapped to the regions that matter most to you, even if they are not the traditional zip code, county, state or country regions. Custom regions are useful for plotting data on sales districts, school districts, congressional districts, land lot development,…
Today, businesses are required to understand a growing amount of data to drive effective business decisions and remain competitive. Many specialized business intelligence and analytics solutions are entering the market to take advantage of this trend with most requiring installation of new data systems or new training of employees to learn new tools. Excel may already have the business analytics tools you need to drive the information analyses and data-driven…
We all know that Excel is packed with tons of powerful features, libraries of formulas and galleries of interesting charts, making it one of the most useful tools for business analysts. I believe that, among the great secrets of Excel, there are several that are easy to use and quickly add value to your work. —Read more about powerful Excel features from Purna Duggirala of chandoo.org
Should a university teach a course on Excel? I have heard this question a lot. But while doing research for my Ph.D. thesis at Delft University of Technology, I noticed the whole world is run by Excel.—Read more from Felienne Hermans, an assistant professor at Delft University of Technology in the Netherlands on teaching Excel to university students.