Calendar

Jan
21
Tue
Region 1 HFMA Chapters Excel Webinar Series – Which Lookup Function Should I Use (Intermediate)
Jan 21 @ 12:00 pm – 1:00 pm

Registration Information Coming Soon!
(times are estimated)

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

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

Which Lookup Function Should I Use (Intermediate) – Tuesday, January 21, 2020

While the iconic VLOOKUP function is probably the most popular lookup function, there are times when other options may be a better fit. Depending on the type of workbook, INDEX/MATCH or SUMIFS may offer some benefits. And, depending on the version of Excel you are using, XLOOKUP may be a wonderful option. Join us to learn the pros and cons of the key lookup functions and when to use each.

Jan
23
Thu
Region 1 HFMA Chapters Excel Webinar Series – Better Together (Power Query and Power Pivot) (Advanced)
Jan 23 @ 12:00 pm – 1:00 pm

Registration Information Coming Soon!
(times are estimated)

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

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

Better Together (Power Query and Power Pivot) (Advanced) – Thursday, January 23, 2020

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.

May
19
Tue
Region 1 HFMA Conference 2020
May 19 @ 8:00 am – May 20 @ 5:00 pm

Nineteenth Annual Healthcare Conference
Tuesday-Wednesday
May 19-20, 2020
MGM Springfield, Springfield, MA

Full Details and Registration are Coming Soon!

The HFMA Region 1 Chapters (Connecticut, Maine, Massachusetts-Rhode Island and New Hampshire-Vermont) have scheduled the Nineteenth Annual Healthcare Conference for May 19-20, 2020. We are excited to announce this upcoming Conference will be held at the MGM Resorts Conference Center in Springfield, Massachusetts. The Conference gathers healthcare financial professionals, including CFO’s and senior executives, from New England, New York, New Jersey, Pennsylvania, and other regions with sessions that focus on varying facets of healthcare financial leadership. We expect it to be better then ever!

HIGHLIGHTS FOR THIS YEAR’S CONFERENCE

  • Keynote Address by Dr. Rigsby, President and CEO, Rick Rigsby Communications. He is a former award-winning journalist, college professor and football character coach at Texas A&M University.
  • Conference theme – Financial Leadership
  • We anticipate over 350 attendees.
  • Exhibit hall with 50 industry exhibitors
  • Cocktail reception
  • After-Party with bowling