Page 31 - 72nd Annual Conference Brochure

FRIDAY, JULY 18 TH
FRIDAY, JULY 18
TH

9:00 AM - 9:50 AM
2:30 PM - 3:20 PM
9:00 AM - 9:50 AM 2:30 PM - 3:20 PM

711: W
r
ansportation
r
angling T
511: Data W r anglers – Ex cel Tips & 711: Wrangling Transportation
511: Data Wranglers – Excel Tips &
EMERGING PROFESSIONALS SESSION AGENDA
EMERGING PROFESSIONALS SESSION AGENDA
T
ricks
Tricks Reporting with ADE
eporting with ADE
R
Saddle up the Data Wrangler’s are coming This presentation reviews the updated guid-
to town! In this 50-minute rodeo session ance and the ADE Connect Transportation
we will go over Excel Tips & Tricks including application. We will focus on addressing fre-
extracting and combining elements, adding quently asked questions and common issues
together numbers in a range, various ways related to reporting. Provide a comprehen-
to use Conditional Formatting, and how to sive overview of the transportation reports
utilize VLOOKUP and Pivot functions. Don’t and how to identify any issues before the re-
forget your saddle (laptop) if you want to fol- porting window closes.
low along! Presenters
Presenters Monica Paz - Arizona Department of
Alex Cooksey - HeinfeldMeech Education
Ken McGovern - Pima County JTED

3:40 PM - 4:30 PM
3:40 PM - 4:30 PM
811: R eviewing Financial
811: Reviewing Financial
Statements – The Basics
Statements – The Basics
Out on the procurement frontier, the right
A draft of your financial statement report is
ready for you to review… now what? Where
do you start? In this session, we'll provide a
general overview of what is included in the
report, discuss what you are responsible for,
and provide tips on how to review the report.
Presenters
Josh Jumper - HeinfeldMeech
Lizette Huie - Sahaurita Unified
School District

Page 31