Agenda

Register Today for Excelapalooza 2018!

Join BizNet Software for Excelapalooza 2018! This year’s conference will feature not only the Excel tips and tricks you’ve come to expect, but also a variety of tracks to assist in your reporting and analytics.
 
While you will still learn how to navigate and use Excel better, we’re aiming to teach companies and users the most common KPI and metrics they should consider tracking. We’ll show you how to connect data from a wide range of sources to calculate these numbers and trends, but more importantly illustrate what Excel tools your company should use in each situation.
 
By combining your team’s data to build compelling reports utilizing more powerful tools, we’ll then train your team to present these findings to the business with leadership training. This holistic approach will elevate your team and your business in three fun and educational days in Dallas, TX.
 
Sessions are not final and are subject to change.

agenda-outline

2018 Agenda

Day 1
17 Sep 2018
Day 2
18 Sep 2018
Day 3
19 Sep 2018

OPENING SESSION

George McMann

BREAKOUT SESSIONS I

BizInsight 7 Introduction: Report writing with BizInsight 7
BizInsight 5 Introduction: Fundamentals of Creating Financial Reports
Introduction to the Excel Data Model
Mapping your Geographic Data

BREAKOUT SESSIONS II

BizNet: Dashboards with BizInsight
Financial Metrics
Power Query: The bridge to External Data
Pivot Table Data Crunching

AFTERNOON SESSION

Guest Speaker (TBD)

BREAKOUT SESSION III

BizInsight 7 (Standalone): So Much Data, So Little Time? Spinning the Data Wheel
BizBroadcast Introduction:
Excel Tables – Database Technology Comes to Excel
Artificial Intelligence in Excel

BREAKOUT SESSION IV

Do You Know Your Customers
Pivot Tables 101
Charting & Data Visualizations in Excel
BizNet: Making a Data Connection with Excel Part 1

BREAKOUT SESSION V

BizInsight 7 Advanced: Report Writing with Connected and External Data
Powerful Reporting w/ Cube Formulas
Cleaning Data with Power Query
BizNet: Making a Data Connection with Excel Part 2

MORNING SESSION

Guest Speaker

BREAKOUT SESSIONS I

BizInsight 7 Advanced: Report Writing with Connected and External Data
BizInsight 5 Advanced: Dynamic Reporting with BizInsight
Introduction to the Excel Data Model
Charting & Data Visualizations in Excel

BREAKOUT SESSIONS II

Do You Know Your Customers
Power Query: The bridge to External Data
Mapping your Geographic Data
BizNet in the Cloud

AFTERNOON SESSION

Guest Speaker (TBD)

BREAKOUT SESSION III

Information Rights Management / Security
Pivot Tables 101
Artificial Intelligence in Excel
BizBroadcast Introduction

BREAKOUT SESSION IV

BizNet: Making a Data Connection with Excel Part 1
Financial Metrics
Excel Data Combination & Consolidations Comes to Excel
MrExcel's Favorite Tips & Tricks

BREAKOUT SESSION V

BizBroadcast Advanced
BizNet: Making a Data Connection with Excel Part 2
Excel Tables – Database Technology Comes to Excel
Forecasting with Excel

EXCELAPALOOZA CELEBRATION

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

MORNING SESSION

Guest Speaker

BREAKOUT SESSIONS I

BizInsight 7 Introduction: Report writing with BizInsight 7
BizInsight 5 Introduction: Fundamentals of Creating Financial Reports
BizNet Champions Invitation Only Event
Forecasting with Excel

BREAKOUT SESSIONS II

BizInsight 5 Advanced: Dynamic Reporting with BizInsight
Pivot Table Data Crunching
BizNet in the Cloud

AFTERNOON SESSION

Guest Speaker (TBD)

BREAKOUT SESSION III

BizNet: Dashboards with BizInsight
BizBroadcast Introduction:
BizBroadcast Advanced:
MrExcel's Favorite Tips & Tricks