17 Sep 2019
2:00 pm - 2:50 pm


PivotTables 101

PivotTables are Excel’s most powerful feature and the simplest of PivotTables deliver about 80% of their power. In this session, you will master how to create simple, powerful PivotTables with ease. And best of all, mastering basic PivotTables is the key to improving your personal productivity because they are an essential component of countless financial analyses.

Countdown to VBA

This session will be less about VBA theory and more about VBA macros in practice, showing examples of real-world data management scenarios that can be solved with VBA automation. Session attendees will be given flash drives with copies of every workbook example and the VBA code that is demonstrated in those workbook examples. Included in the demonstrations will be examples of macros, automated event procedures at the worksheet and workbook level, and user-defined functions.

MTE for BizBroadcast

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.

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.