BREAKOUT SESSION IV

17 Sep 2018
3:00 pm - 3:50 pm

BREAKOUT SESSION IV

BizNet: Creating Excel Data Connections for Reporting Part 1

Data is everywhere but how can you connect to external data and work with it in Excel? We’ll show how you can easily manage a multitude of connections, edit, delete and even refresh external data connections within the Microsoft Excel world. Part 1 of Creating Excel Data Connections for Reporting will demonstrate how to connect to the top external data connections and discuss their individual distinctions.

Charting & Data Visualizations in Excel

Learn how to create perfect charts in one keystroke. Take a tour of the data visualization tools such as Data Bars, Color Scales, and Icon sets. Create tiny, cell-sized charts with Sparklines.

Do You Know Your Customers?

BizNet Guest Speaker

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