Calendar

Dec
13
Thu
Winter Revenue Program with AAHAM @ Courtyard by Marriott Cromwell
Dec 13 @ 8:30 am – 4:30 pm

CT AAHAM & CT HFMA WINTER PROGRAM

PROGRAM AT A GLANCE

 

Registration
7:45am – 8:30am        Registration & Continental Breakfast

General Session
8:30am – 8:40am        Welcome, Opening Remarks and National Update
                                    Paul Fitzpatrick, V.P. Business Development, ICSystem

8:40am – 9:45am        MD Panel- High Deductible Plans and Their Effect on Patients Health

9:45am – 10:00am       Break

Patient Access Track
10:00am – 11:00am     Financial Clearance Process

11:00am – 12:00pm    Patient Experience
                                   Anne York- Trinity Health of New England

Revenue/Billing Track
10:00am – 11:00am     Best Practices in Financial Clearance
                                   Evan Dressel- Baker Newman Noyes

11:00am – 12:00pm    Contract Management (Strategic Contract Language, Medical Necessity                                                         Challenges,  Avenue for Appeals)
                                   Cassandra Mitchell- ECHN, Inc.

12:00pm – 1:00pm      Lunch

1:00pm – 2:00pm        Price Transparency
                                   Vincenzo Carannante – Shipman & Goodman

2:00pm – 3:00pm       Denials Management
                                   Leah Milano-HC Program Advisors

3:00pm – 3:15pm        Break

Return to General Session
3:15pm – 4:00pm        Work from Home
                                   Michael Friedberg- Parallon

4:00pm – 4:10pm        Closing Remarks     

4:10pm – 5:00pm        Networking Happy Hour

TICKETS
$100.00           CT AAHAM/CT HFMA Member Ticket
$90.00             Earlybird rate before December 1

$120.00           Non-Member
$110.00           Earlybird rate before December 1

REGISTER NOW!!

Jan
23
Wed
HFMA Region #1 Excel Webinar Series – Power Query Basics (Advanced)
Jan 23 @ 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

Power Query Basics (Advanced) – Wednesday, January 23, 2019

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra
columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single
column. The good news is that many of these transformations can be fully automated with Excel! Power Query is an incredibly
powerful tool that, at a high level, helps us retrieve data from a variety of sources and prepare it for use. In this session, we’ll use
Power Query to help with several common tasks, including flattening data, splitting and combining columns, formatting data,
unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to
another, you will want to understand how to use Power Query to streamline your work. Learning objectives: (1) recall the steps to
create a new query; (2) identify commands that transform data; and (3) state the process to return the transformed data to Excel.

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

Registration Details Coming Soon!

Jan
29
Tue
HFMA Region #1 Excel Webinar Series – Mapping Tables (Intermediate)
Jan 29 @ 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

Mapping Tables (Intermediate) – Tuesday, January 29, 2019

When you need a report that your accounting system doesn’t provide, you probably turn to Excel to create the report. In this
session, we will explore the features, functions, and techniques needed to help automate these types of reports. For example, you
want to export a trial balance and you want Excel to pull the values into the proper lines in a balance sheet, even when the labels
are different and even when many accounts need to roll up to a single report line. By the end of the session, you’ll learn how to
structure your reporting workbook so that your Excel formulas automatically summarize the exported accounting system data.

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

Registration Details Coming Soon!

Feb
12
Tue
CTHFMA’s Winter Symposium @ Sheraton Hartford South
Feb 12 @ 9:00 am – 4:00 pm

SAVE THE DATE!
CT HFMA’s Winter Symposium featuring TeleMedicine

Date:
Tuesday, February 12, 2019
9:00am – 4:00pm

Location:
Sheraton Hartford South – 100 Capital Blvd, Rocky Hill, CT 06067, USA

Registration:
Details regarding registration will be out soon!

 

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.

Registration Details Coming Soon!

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

SAVE THE DATE!
CT HFMA’s Annual Women in Leadership Conference

Date:
Tuesday, March 26, 2019

Location:
Saint Clements Castle – 1931 Portland-Cobalt Rd, Portland, CT 06480, USA

Registration:
Detailed information regarding registration will be out soon!