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


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 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.

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.