Since the release of Excel 2016 for Mac, customers have given great feedback about its ease of use and the benefits of the new features. We want to highlight the Excel 2016 for Mac features that customers rave about and share some tips and tricks that could save you a ton of time using the most powerful spreadsheet and data analysis tool on the Mac platform.
Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk through all the new and cool options for building PivotTables with a Date/Time column and show how to surface time-based insights in your data.
Recently, we told you about the exciting new features and improvements in Excel 2016 that expand the business analytics capabilities available to you and your company. Today we will tell you about the changes we have made to help you get access to the features that fit your unique needs, including more Office plans that offer advanced analytics functionality.
Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We’re excited to let you know that your get-data experience in Excel is about to change forever. —Read on to learn about how Excel 2016 has integrated Power Query technology into the Data ribbon.
Excel 2016 and Power BI are a portfolio of tools that is unique in the industry. Together, they provide a broad set of capabilities that allow business analysts to more easily gather, shape, analyze and visually explore their data. —Read more for an overview of how these tools work together to solve your analytics needs.
We introduced you to our new chart types across Office 2016 and dove deeper into a few of them. We showed the effectiveness of Waterfall charts in visualizing financial statements and how hierarchical charts show complicated data with multiple levels and categories. Now, we’ll take a closer look at the last set of chart types: statistical. —Read about Histogram, Pareto and Box and Whisker charts in Office 2016 for Windows.