MONDAY – BREAKOUT SESSIONS I

16 Sep 2019
9:40 am - 10:30 am

MONDAY – BREAKOUT SESSIONS I

Dynamic Array Formulas

Brilliant new SORT, FILTER, and UNIQUE formulas have been added to Excel that dramatically simplify some of the most difficult formulas in Excel. If you’ve ever seen a 300-character formula used to Filter and extract Unique values, you will love these new functions in Excel.

Build Stunning Dashboards with Power BI (Part 1)

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.

15 Power Query Quick Tips

This session will hit 15 small but MIGHTY Power Query tips so you can get more BANG when working with multiple and complex queries.  In this session we’ll focus on 15 important tips to help maximize your Power Query experience.

Jet Budgets: Control and Transform Your Fiscal Planning Process in Excel

Excel is a familiar tool, but disparate spreadsheets can’t be regulated, and trying to reconcile them during the budgeting process becomes a full-time job. Manual input on numerous worksheets is rife with errors and inconsistencies that are nearly impossible to resolve in the end.

Join this session to learn how you can eliminate the ‘Excel-mania’ that leads to time-consuming mistakes during the fiscal planning exercise and get fast, accurate, controlled budgets that can be imported to Microsoft Dynamics, seamlessly.

BizInsight 7 Greatest Hits: Volume 1

BizInsight 7 will provide you with a comprehensive understanding of working with your data and best practices in report writing.  Volume 1 of the greatest hits is designed to provide you with a comprehensive understanding of report setup, and best practices in report writing.

Not only will Volume 1 highlight and demonstrate 5 of greatest hits of BizInsight 7, but if you stick around, you can personally Meet the Experts (MTE BizInsight 7) for hands on experience in your environment.  Walk away with the knowledge and the power of BizInsight 7 in this two-part performance!
Features: BizInsight 7 Navigation, Query Editor,Exploring Tables/Lists, Creating Functions.

MTE For BizInsight 7

Knowledge + Power = BizNet Experts
This 30 minute open session is intended for hands on instruction of the features demonstrated at Excelapalooza and/or any general questions about your BizNet software.