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 18 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
7:30 am - 8:30 am
MONDAY – BREAKFAST
Housekeeping / Informational Updates
8:30 am - 9:30 am
MONDAY – KEYNOTE
Meet Eric Patterson, Senior Program Manager with Microsoft Excel!
9:40 am - 10:30 am
MONDAY – BREAKOUT SESSIONS I
Dynamic Array Formulas
Build Stunning Dashboards with Power BI (Part 1)
15 Power Query Quick Tips
BizInsight 7 Greatest Hits - Volume 1
Build Stunning Dashboards with Power BI (Part 1)
15 Power Query Quick Tips
BizInsight 7 Greatest Hits - Volume 1
10:40 am - 11:30 am
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
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
11:45 am - 12:45 pm
1:00 pm - 1:50 pm
MONDAY – BREAKOUT SESSION III
BizInsight 5 Greatest Hits - Volume 1
Live from Microsoft
Detecting and Preventing Worksheet Errors
Power Query Joins: Merging and Segmenting Data
Live from Microsoft
Detecting and Preventing Worksheet Errors
Power Query Joins: Merging and Segmenting Data
2:00 pm - 2:50 pm
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
Countdown with VBA
Can Excel Really Report, Upload and Distribute all My Data (Hint: The Answer is Yes!)
Powerful Reporting w/ Cube Formulas
3:00 pm - 3:50 pm
MONDAY – BREAKOUT SESSION V
Artificial Intelligence and Data Types
Build Stunning Dashboards with Power BI (Part 2)
BizBroadcast Greatest Hits : Volume 1
Dynamic Arrays: The Joy of Spilling Data Everywhere
Build Stunning Dashboards with Power BI (Part 2)
BizBroadcast Greatest Hits : Volume 1
Dynamic Arrays: The Joy of Spilling Data Everywhere
4:00 pm - 4:50 pm
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
The WOW! factor with Advanced VBA
Save Time with Automated Reporting…All in Excel Spreadsheet Server
Introduction to the Excel Data Model
7:30 am - 8:30 am
TUESDAY – BREAKFAST
Housekeeping / Informational Updates
8:30 am -9:30 am
TUESDAY – KEYNOTE
Excel MVP Round Table
9:40 am - 10:30 am
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
Collaboration in Excel TUESDAY ONLY
BizInsight 5 Greatest Hits - Volume 2
Storytelling with Data
10:40 am - 11:30 am
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
Build Stunning Dashboards with Power BI (Part 2)
Using Power Query to Drive your Dashboards
Power Query Joins: Merging and Segmenting Data
11:45 am - 12:45 pm
1:00 pm - 1:50 pm
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
Introduction to the Excel Data Model
BizBroadcast Greatest Hits - Volume 2
Thinking like a Dashboard
Dynamic Arrays: The Joy of Spilling Data Everywhere
2:00 pm - 2:50 pm
TUESDAY – BREAKOUT SESSION IV
PivotTables 101
Countdown with VBA
15 Power Query Quick Tips
Countdown with VBA
15 Power Query Quick Tips
3:00 pm - 3:50 pm
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
MrExcel's Favorite Tips & Tricks
BizInsight 7 Greatest Hits - Volume 2
The WOW! factor with Advanced VBA
Visualizing Data without Charts
4:00 pm - 4:30 pm
TUESDAY – BREAKOUT SESSION VI
MTE for BizInsight 7
6:00 pm - 8:00 pm
Blue Mesa
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!
7:30 am - 8:30 am
WEDNESDAY – BREAKFAST
Housekeeping / Informational Updates
8:30 am - 9:30 am
WEDNESDAY – KEYNOTE
insightsoftware: Vision into the Future
9:40 am - 10:30 am
WEDNESDAY – BREAKOUT SESSION I
Dynamic Array Formulas
Can Excel Really Report, Upload and Distribute all My Data (Hint: The Answer is Yes!)
Storytelling with Data
MTE for BizInsight 5
Can Excel Really Report, Upload and Distribute all My Data (Hint: The Answer is Yes!)
Storytelling with Data
MTE for BizInsight 5
10:40 am - 11:30 am
WEDNESDAY – BREAKOUT SESSION II
MrExcel's Favorite Tips & Tricks
Save Time with Automated Reporting…All in Excel Spreadsheet Server
Thinking like a Dashboard
MTE for BizInsight 7
Save Time with Automated Reporting…All in Excel Spreadsheet Server
Thinking like a Dashboard
MTE for BizInsight 7
11:45 am - 12:45 pm
1:00 pm - 1:50 pm
WEDNESDAY – BREAKOUT SESSION III
Using Power Query to Drive your Dashboards
Excel Can Do Even More than You Think: Empower your Reporting with GL Wands
Excel Can Do Even More than You Think: Empower your Reporting with GL Wands
2:00 pm - 2:50 pm
WEDNESDAY – BREAKOUT SESSION IV
Visualizing Data without Charts
MTE for BizBroadcast
MTE for BizBroadcast