Select Page

# Education & Events

Feb
27
Tue
Excel Webinar Series @ Online Webinar
Feb 27 @ 12:00 pm – 1:30 pm

The NH-VT and Maine Chapters are excited to bring this Excel webinar series to the other Region I HFMA chapters. Jeff Lenning has provided Excel training to our chapter members for the past two years with rave reviews. Don’t miss the opportunity to get nine hours of Excel training for financial professionals for just \$150 (HFMA member rate)! For those who attended our Excel webinar series these past two years, you know t his is an incredible value! The training will be offered in six stand-alone webinars 90 minutes each over lunch time beginning in December and running through February. Each participant will receive a set of Excel templates, as well as a PDF summary handout for future reference. The webinars are \$25 each for members and \$50 each for non-members. Please refer to the detailed described of each webinar below.

Please note that these webinars are not recommended for beginner users. The material offered is for intermediate to advance level users. Webinars will begin at noon and end at 1:30 pm EST and will not be recorded for future use. Separate registration for each webinar is required so that you can sign up for one or all. Links to the registration are noted below:

12/5/2017 – Excel Series 1 – How Do You Do This in Excel
1/9/2018 – Excel Series 2 – Mapping Tables
1/17/2018 – Excel Series 3 – Excel PivotTables
1/25/2018 – Excel Series 4 – Transform Data in Excel Without Formulas or Macros
2/13/2018 – Excel Series 5 – Excel Budget Ideas
2/27/2018 – Excel Series 6 – The Two Most Important Excel Functions for Accountants

How Do You Do This in Excel – How do you get from your house to the store? Do you walk? Ride a bike? Drive a car? All of these methods will get you there, but, some are faster than others. The same is true in Excel. There are often several ways to accomplish any given task in Excel. But, not all options provide the same efficiency. For example, let’s say you need to compute a report subtotal, such as the fixed assets subtotal. How do you do this in Excel? Do you use the SUM function? If so, it may surprise you to learn that there is a more efficient option.  In this session, we’ll examine several common Excel tasks and then discuss our options.

Mapping TablesWhen 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.

Excel PivotTables – In this session, we’ll explore the fundamentals of creating PivotTable reports. We’ll examine the report layout areas and how to update source data. We’ll also examine report layout options so that you can obtain just the right formatting and structure for your report. We’ll talk about how to group your report into monthly columns and how to filter PivotTables as well. By the end of the session, you’ll understand how to create basic PivotTable reports.

Transform Data without Formulas or Macros – If you haven’t played with the Get & Transform commands in Excel 2016 for Windows, they are probably worth checking out. Formerly available as the Power Query add-in, the Get & Transform tools built-in to Excel 2016 for Windows are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. These tools provide new ways to approach tasks that were previously manual and time-consuming. In this session, we’ll apply these tools to 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 a Get & Transform query to streamline your work.

Excel Budget Ideas – Budget methods are the key to allowing department managers to prepare their budget in Excel efficiently. A budget method may be, for example, spread prior year actuals or match prior year actuals, or match prior year actuals less 10%.  In this webcast, we’ll explore how to allow the users to pick a budget method from a drop down list for each account, and then have Excel perform different math depending on the budget method selected. We use several features and functions at the same time to accomplish this, including data validation and a combination of functions. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

The Two Most Important Excel Functions for AccountantsWe’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?

Your attendance may qualify for 1.8 hours of Continuing Professional Education (CPE) credits for each session. We have computed the education credits based on an equivalent of 50 minutes for each education credit hour. You are responsible for maintaining adequate records and determining if the content of this program meets the professional licensing requirements of your state.

Mar
1
Thu
Certification Webinar Series – Free to Member!
Mar 1 @ 12:00 pm – 1:00 pm

Six chapters have joined forces to present a joint certification coaching course to be presented as a 4 part series of webinars presented by Christoph Stauder. The six chapters are: CT, MA/RI, ME, NH/VT, SC and WI.

One webinar covers exam 1 and testing strategies. Three webinars will present two case studies from one of the three environments. These webinars will help you apply business judgement to case studies that describe various situations, opportunities and challenges that one might confront as a provider, payer or physician group.

How do you teach strategic thinking? We have Christoph Stauder to help develop business judgment by observing decisions of others and what would have been better or different.

2/1/2018:

CHFP Exam Series 1 – The Business of Health Care

2/8/2018 :

CHFP Exam Series 2 – Preparing for the Operational Excellence Exam PART I

3/1/2018:

CHFP Exam Series 3 – Preparing for the Operational Excellence Exam PART II

3/29/2018:

CHFP Exam Series 4 – Preparing for the Operational Excellence Exam PART III

Registration Information:

The webinars are free for members. Please refer to the detailed descriptions of each webinar below. CT HFMA Members must register for each webinar separately. Priority registration will close at 5 p.m. on 1/25/18. Registration is a two-step process: (1) register through CVent; and (2) once your confirmation email is sent you will receive a link which requires you to register on GoToWebinar to obtain the unique link needed to participate in the webinar.

All Webinars are from 12:00pm – 1:00pm EST.

Mar 1 @ 4:00 pm – 9:00 pm

Brought back by popular demand after last year’s first annual women’s event, this program will showcase several compelling first-hand accounts of climbing the corporate ladder as a woman leader.  It will include a motivational keynote speaker, as well as six local women leaders to serve on a panel discussion.  These accomplished women will share their personal stories of how they landed in their current roles, offer insight regarding the obstacles they encountered along the way and will provide advice on how they overcame those obstacles and have succeeded as a result.

Event Information

4:00pm – 5:00pm

Registration, Appetizers & Networking

5:00pm – 5:15pm

Welcome & Introductions

5:15pm – 6:00pm

Keynote Speaker
Sherry Stewart Deutschmann, CEO Sunset Ventures and Founder, LetterLogic

6:00pm – 6:30pm

Dinner Stations

6:30pm – 9:00pm

Panel Discussion/Coffee & Dessert

Panelists Include:

Andrea Balogh, Senior Vice President & General Counsel, WHUSA

Kirsten Jones, Market President Hartford Healthcare – GoHealth Urgent Care

Cassandara Mitchell, Regional VP, Revenue Cycle, Connecticut Market, Prospect Medical Holdings, Inc.

Laura Redinger, Senior Vice President, Director, Commercial Segment Enterprise Strategy, KeyCorp

Korrine Roth, Administrative Director of Quality, Safety & Satisfaction, Western Connecticut Health Network

Jennifer Willcox, Vice President, Legal Services, Yale New Haven Health

Event Pricing

Member:                                                   \$85

Non Member:                                         \$105

Board/Certified/Retired:                    \$60

Mar
29
Thu
Certification Webinar Series – Free to Member!
Mar 29 @ 12:00 pm – 1:00 pm

Six chapters have joined forces to present a joint certification coaching course to be presented as a 4 part series of webinars presented by Christoph Stauder. The six chapters are: CT, MA/RI, ME, NH/VT, SC and WI.

One webinar covers exam 1 and testing strategies. Three webinars will present two case studies from one of the three environments. These webinars will help you apply business judgement to case studies that describe various situations, opportunities and challenges that one might confront as a provider, payer or physician group.

How do you teach strategic thinking? We have Christoph Stauder to help develop business judgment by observing decisions of others and what would have been better or different.

2/1/2018:

CHFP Exam Series 1 – The Business of Health Care

2/8/2018 :

CHFP Exam Series 2 – Preparing for the Operational Excellence Exam PART I

3/1/2018:

CHFP Exam Series 3 – Preparing for the Operational Excellence Exam PART II

3/29/2018:

CHFP Exam Series 4 – Preparing for the Operational Excellence Exam PART III

Registration Information:

The webinars are free for members. Please refer to the detailed descriptions of each webinar below. CT HFMA Members must register for each webinar separately. Priority registration will close at 5 p.m. on 1/25/18. Registration is a two-step process: (1) register through CVent; and (2) once your confirmation email is sent you will receive a link which requires you to register on GoToWebinar to obtain the unique link needed to participate in the webinar.

All Webinars are from 12:00pm – 1:00pm EST.

May
23
Wed
HFMA Region 1 Annual Conference @ Mohegan Sun Resort
May 23 – May 24 all-day

SAVE THE DATE!!!!

The Region 1 Conference returns to Mohegan Sun!!!