Agenda

Register Today for Excelapalooza 2019!

Join BizNet Software for Excelapalooza 2019! This year’s conference will feature more Excel MVPs than ever before! With 4x certified Excel MVPs we’re boasting some the greatest available Excel training in a single conference ever. Did we mention you can earn up to 19 CPE credits along the way?
 
Not only will you walk away with 100s of tips and tricks, but you’ll have a new understanding for VBA & Macros, data visualizations, building extraordinary dashboards, and finally an appreciation for the latest technology in Excel.
 
 

2019 Excelapalooza Agenda

*Sessions are subject to change. Learn more about the sessions by clicking the schedule title.
Day 1
16 Sep 2019
Day 2
17 Sep 2019
Day 3
18 Sep 2019

MONDAY – BREAKFAST

Housekeeping / Informational Updates

MONDAY – KEYNOTE

Meet Eric Patterson, Senior Program Manager with Microsoft Excel!

MONDAY – BREAKOUT SESSIONS I

Dynamic Array Formulas
Build Stunning Dashboards with Power BI (Part 1)
Jet Budgets: Control and Transform Your Fiscal Planning Process in Excel
15 Power Query Quick Tips
BizInsight 7 Greatest Hits - Volume 1

MONDAY – BREAKOUT SESSIONS II

VBA: The Right Stuff
Putting your Excel data on the web with Power BI
Excel Can Do Even More than You Think: Empower your Reporting with GL Wands
PivotTables 101

MONDAY – BREAKOUT SESSION III

BizInsight 5 Greatest Hits - Volume 1
Live from Microsoft
Compare All Jet Products
Detecting and Preventing Worksheet Errors
Power Query Joins: Merging and Segmenting Data

MONDAY – BREAKOUT SESSION IV

VLOOKUP In Depth
Countdown with VBA
Can Excel Really Report, Upload and Distribute all My Data (Hint: The Answer is Yes!)
Powerful Reporting w/ Cube Formulas

MONDAY – BREAKOUT SESSION V

Artificial Intelligence and Data Types
Build Stunning Dashboards with Power BI (Part 2)
Jet Budgets: Control and Transform Your Fiscal Planning Process in Excel
BizBroadcast Greatest Hits : Volume 1
Dynamic Arrays: The Joy of Spilling Data Everywhere

MONDAY – BREAKOUT SESSIONS VI

Formula Auditing with Excel
The WOW! factor with Advanced VBA
Save Time with Automated Reporting…All in Excel Spreadsheet Server
Introduction to the Excel Data Model

TUESDAY – BREAKFAST

Housekeeping / Informational Updates

TUESDAY – KEYNOTE

Excel MVP Round Table

TUESDAY – BREAKOUT SESSION I

Build Stunning Dashboards with Power BI (Part 2)
Collaboration in Excel TUESDAY ONLY
BizInsight 5 Greatest Hits - Volume 2
Storytelling with Data

TUESDAY – BREAKOUT SESSIONS II

VBA: The Right Stuff
Build Stunning Dashboards with Power BI (Part 2)
Using Power Query to Drive your Dashboards
Power Query Joins: Merging and Segmenting Data

TUESDAY – BREAKOUT SESSION III

VLOOKUP In Depth
Introduction to the Excel Data Model
BizBroadcast Greatest Hits - Volume 2
Thinking like a Dashboard
Dynamic Arrays: The Joy of Spilling Data Everywhere

TUESDAY – BREAKOUT SESSION IV

PivotTables 101
Countdown with VBA
15 Power Query Quick Tips

TUESDAY – BREAKOUT SESSION V

Detecting and Preventing Worksheet Errors
MrExcel's Favorite Tips & Tricks
BizInsight 7 Greatest Hits - Volume 2
The WOW! factor with Advanced VBA
Visualizing Data without Charts

EXCELAPALOOZA CELEBRATION

Join us on Tuesday night as we celebrate Excelapalooza 2019. Put your brain and calculations to the test with our Casino Night and Trivia. Dinner, drinks, and giveaways included. Don't miss out!

WEDNESDAY – BREAKFAST

Housekeeping / Informational Updates

WEDNESDAY – KEYNOTE

insightsoftware: Vision into the Future

WEDNESDAY – BREAKOUT SESSION I

Dynamic Array Formulas
Jet Budgets: Control and Transform Your Fiscal Planning Process in Excel
Can Excel Really Report, Upload and Distribute all My Data (Hint: The Answer is Yes!)
Storytelling with Data
MTE for BizInsight 5

WEDNESDAY – BREAKOUT SESSION II

MrExcel's Favorite Tips & Tricks
Compare All Jet Products
Save Time with Automated Reporting…All in Excel Spreadsheet Server
Thinking like a Dashboard
MTE for BizInsight 7

WEDNESDAY – BREAKOUT SESSION III

Using Power Query to Drive your Dashboards
Jet Budgets: Control and Transform Your Fiscal Planning Process in Excel
Excel Can Do Even More than You Think: Empower your Reporting with GL Wands

WEDNESDAY – BREAKOUT SESSION IV

Visualizing Data without Charts
MTE for BizBroadcast