Events Calendar

Subscribe to RSS Feed

February 2019

Feb 20

Excel Series 5 - Better Together (Power Query and Power Pivot) (Advanced)

Wednesday
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.
Event Link


Feb 26

Excel Series 6 - The 2 Most Important Excel Functions for Accountants (Intrmdt)

Tuesday
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. The Two Most Important Excel Functions for Accountants (Intermediate) - 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? lookup tasks more effectively. It will be a competition, an epic battle between two of the most important Excel functions. Who will win?
Event Link


March 2019

Mar 7

Physician Practice Management

Thursday
Optimize Billing and Gain Organizational Efficiencies

Maine Hospital Association, Auburn, ME

Save the Date!


April 2019

Apr 4

Northern New England HFMA Leadership Conference

Thursday 04/4/2019 - 04/5/2019
Program Objectives:
We are. HFMA has proven to be an indispensable source of education for healthcare finance professionals. We are pleased to bring together a faculty for this Leadership Conference who will inspire, motivate and encourage you to lead. Lead in your personal lives and in your role as a healthcare professional in an industry that is changing at such a rapid pace.
Day 1
Achievement NOW!
Bending the cost curve, a call for community action
Living with a courageous heart
Social media and personal branding
Workforce evolution (work from home, generational, etc.)
Networking event at the hotel

Day 2 (half-day)
The Power of Optimism
Your choice of two separate educational tracks focused on hot topics in either Accounting/ Auditing or Revenue Cycle

Who Should Attend:
Early Careerists, CEOs, CFOs, Board Members, Reimbursement, Finance, Revenue Cycle, Managed Care and Government Relations Professionals

CPE Credits: 11.75 credit hours
DCMS Education Credit: 9.75 hours
Date: Thursday, April 4 and Friday April 5, 2019
Location: Mountain View Grand Resort & Spa, Whitefield, NH

Event Details


May 2019

May 2

Spring Symposium

Thursday
Hot Topics, Accounting, and Regulatory / Reimbursement

Freeport, ME

Save the Date!


May 21

HFMA (Region 1) 18th Annual Healthcare Conference

Tuesday 05/21/2019 - 05/22/2019
Imagine Tomorrow

Mohegan Sun Uncasville, CT

Save the Date!