Category Archives: Excel Tips

AppyWiz Excel tips

Excel and big data

One of the great things about being on the Excel team is the opportunity to meet with a broad set of customers. In talking with Excel users, it’s obvious that significant confusion exists about what exactly is “big data.” Many customers are left on their own to make sense of a cacophony of acronyms, technologies, architectures, business models and vertical scenarios. Continue reading Excel and big data

Faster OLAP PivotTables in Excel 2016

If you work with connections to OLAP servers, your PivotTables are now faster. The June 2016 update contains query and cache improvements to this powerful feature. You could benefit from these improvements, whether you use PivotTables to answer one-off questions or build complicated workbooks with dozens of PivotTables. These updates are available to Excel 2016 users as part of an Office 365 subscription. If you are already an Office 365 subscriber, find out how to get these latest updates. Continue reading Faster OLAP PivotTables in Excel 2016