Education & Events

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.

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

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.

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

Feb
12
Tue
CTHFMA’s Winter Symposium Featuring Telemedicine @ Sheraton Hartford South
Feb 12 @ 8:30 am – 3:30 pm

REGISTER NOW!
CT HFMA’s Winter Symposium featuring TeleMedicine

 

Agenda:

Tuesday, February 12, 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 Jube George – Vaze,Globex Health
Track #3:Ron Emerson, AMD Global Telemedicine
Legal Track
Track #4: 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 Jube George – Vaze,Globex Health
Track #3:Ron Emerson, AMD Global Telemedicine
Legal Track
Track #4: 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

 

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
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!