MONDAY – BREAKOUT SESSION V
Artificial Intelligence and Data Types
See how the new Artificial Intelligence features in Excel have evolved, including the Ideas feature and new Data Types in Excel for Geography and Stocks.
Building Stunning Dashboards with Power BI (Part 2)
According to Gartner, Microsoft’s Power BI is the number one application ecosystem in the business intelligence environment. It contains a large selection of data visualizations, connects to nearly every data source imaginable, includes all the data connection and transformation capabilities of Power Query, and allows completed dashboards to be shared or published to PowerBI.com. Power BI Desktop opens a new era in data analysis and reporting. Don’t miss this opportunity to see this amazing new reporting tool in action.
BizBroadcast Greatest Hits: Volume 1
Deliver data-driven reports in a variety of formats and share them with anyone, anywhere. Not only will Volume 1 of this session highlight and demonstrate the top 5 greatest hits of BizBroadcast, but if you stick around, you can personally Meet the Experts (MTE Broadcast) for hands-on experience in your environment. Walk away with the knowledge and the power of BizBroadcast in this two-part performance!
Features: AutoFilter, User Defined Parameters, Scheduler, Macros, Preserve Formulas.
Dynamic Arrays: The Joy of Spilling Data Everywhere
Did you know that in September 2018 the Microsoft Excel team released 7 new functions and a new calculation engine! This allows you to write a single formula and get results in multiple cells! YES! One formula that spills results into other cells and eliminates the need of dragging formulas around and potentially causing common errors in our worksheets. This session will differentiate between dynamic array functions and normal Excel functions