Calendar

Feb
20
Wed
HFMA Region #1 Excel Webinar Series – Better Together (Power Query & Power Pivot) (Advanced)
Feb 20 @ 12:00 pm – 1:00 pm

Excel Webinar Series Back by Popular Demand – Jeff Lenning!
The Region 1 HFMA Chapters are excited to offer two tracks
Advanced and Intermediate

Better Together (Power Query and Power Pivot) (Advanced) – Wednesday, February 20, 2019

Excel users have prepared reports the same way for decades … formulas and PivotTables. Typically, we export data from an
accounting system, copy and paste it into an Excel workbook, clean and prepare it for use, and then use PivotTables and/or
functions such as VLOOKUP and SUMIFS. But, that workflow is manual and slow. In this session, we’ll use Power Query and
Power Pivot to improve our workflow. Specifically, we’ll use Power Query to get and shape external data. We’ll send the query
results into the data model. We’ll use Power Pivot to organize tables and create measures and then use them as the source for
PivotTable reports. If you frequently build formula-based or PivotTable reports, join this session to learn how Power Query and
Power Pivot can help. Learning objectives: (1) identify which tool in Excel helps to import and transform data; (2) state the
process for relating tables in Power Pivot; and (3) recall a benefit of using Power Query and Power Pivot when building
PivotTables.

Members: $25/ea.
Nonmembers: $50/ea.

Registration Details Coming Soon!

 

Feb
26
Tue
HFMA Region #1 Excel Webinar Series – The Two Most Important Excel Functions for Accountants (Int)
Feb 26 @ 12:00 pm – 1:00 pm

Excel Webinar Series Back by Popular Demand – Jeff Lenning!
The Region 1 HFMA Chapters are excited to offer two tracks
Advanced and Intermediate

The Two Most Important Excel Functions for Accountants (Intermediate) – Tuesday, February 26, 2019

We’ll discuss two Excel functions that provide incredible efficiency to accountants. One has been around for decades and is often
cited as the most popular Excel function. It is the VLOOKUP function. VLOOKUP is indeed a favorite of many accountants.
After exploring the details of VLOOKUP, we’ll examine a relatively new alternative. We’ll compare these two functions and see
which performs lookup tasks more effectively. It will be a competition, an epic battle between two of the most important Excel
functions. Who will win?
Members: $25/ea.
Nonmembers: $50/ea.

Click below for registration link:
http://www.cvent.com/d/mbq7ws?RefID=summary18

Mar
7
Thu
CTHFMA’s Winter Symposium Featuring Telemedicine @ Sheraton Hartford South
Mar 7 @ 8:30 am – 3:30 pm

REGISTER NOW!
CT HFMA’s Winter Symposium featuring TeleMedicine
with a Revenue Cycle/Business Operations Track as well as a Legal Track

NEW DATE!!!!
When:
Thursday, March 7, 2019
8:30am – 4:00pm
Hartford Sheraton South – Rocky Hill, CT

Agenda:
8:30am – 9:15am                            Registration & Breakfast

9:15am – 9:30am                            Welcome & Introductions

9:30am – 10:45am                          Keynote Presentation
Caroline Piselli & Dr. Abhi Sharma – GuideHouse

10:45am – 11:00am                        BREAK

11:00am – 12:30pm                        Morning Educational Tracks

Revenue Cycle/Business Operations Track
Track #1: Lee Ann Dangelo, VantagePoint
Track #2:Ron Emerson, AMD Global Telemedicine
Legal Track
Track #3: Telemedicine Legal & Compliance Update
Attorney Vincent Carranante, Shipman & Goodwin

12:30pm – 1:30pm                         LUNCH

​1:30pm – 3:00pm                           Afternoon Educational Tracks

Revenue Cycle/Business Operations Track
Track #1: Lee Ann Dangelo, VantagePoint
Track #2:Ron Emerson, AMD Global Telemedicine
Legal Track
Track #3: HIPAA Privacy & Security Telemedicine Update
Attorney Dennis Williams, Kirkland & Ellis

3:00pm – 4:00pm                      Closing Remarks Attendee Networking 

Registration Details:

Pricing
CT HFMA Member: $115.00
CT HFMA Board/Certified/Retired $85.00
Non – Member $145.00

Registration Fee includes: Hotel Parking, Session Materials, Credits, Breakfast and Lunch.
Refunds: Registration will be refunded only if cancelled before February 5, 2019.

REGISTER NOW

SPONSORSHIP OPPORTUNITIES AVAILABLE:
2019 CT HFMA Telemed Sponsor Reg Form

 

Mar
26
Tue
CT HFMA’s Annual Women in Leadership Event @ Saint Clements Castle
Mar 26 @ 8:00 am – 4:30 pm

CT HFMA’s Annual Women in Leadership Conference

Tuesday, March 26, 2019
8:00am – 4:30pm
St. Clements Castle – Portland, CT

Agenda:
8:00am – 8:30am
Registration & Breakfast

8:30am – 8:40am
Welcome & Introductions 

8:40am – 10:10am
Session I – Pursuing Your Passion
Bridget Oei, Miss Connecticut 2018
Sarah Barr, CEO & Founder of Washashore Writing
Stacey Lombardi, Director of Operations, HHC Bone & Joint Institute at Hartford Hospital
Kathleen A Pajor, MS, LNHA, FHFMA, FACHCA, Managing Partner, Pajor Consulting Group

10:10am – 10:30am
BREAK

11:00am – 12:30pm
Session II – Women Supporting Women, putting your health first
April Beaman, Founder, CEO, Certified Thermography Technician
Amy Cote, MS, RDN, CSO, CD-N, Clinical Nutrition Manager, Saint Francis Hospital and Medical Center
Jillian Chase, Wellness Advocate and Health Coach

12:00pm – 1:00pm
LUNCH

​1:00pm – 3:05pm
Session III – Wonder Women in the World Today
Anne Diamond, President & CEO of Day Kimball Hospital
Cassandra Mitchell, Regional Vice President of Revenue Cycle, Prospect Medical Holdings, Inc.
Juby George – Vaze, CEO & Chief Innovation Officer, Globex Health
Jennifer Schneider, Vice President, St. Francis Hospital and Medical Center
Taylor Kinzler, Host of NBC CT Live, NBC
Erin Stewart, Mayor of New Britain

3:05pm – 4:30pm
Closing Remarks/Wine Tasting/Networking 

Registration Details:
Pricing                                                Early Bird (by 2.17.19)         Regular Rate (after 2.17.19)
CT HFMA Member                            $150.00                                $170.00
CT HFMA Board/Certified/Retired     $120.00                                $120.00
Non – Member                                    $180.00                                $210.00

Registration Fee includes: Parking, Session Materials, Credits, Breakfast and Lunch, Networking.
Refunds: Registration will be refunded only if cancelled before March 5, 2019.

Sponsor NOW! CTHFMA 2019 Womens Event Sponsor Brochure

 REGISTER HERE