Rochester - HFMA Central New York Chapter



Free to Members WebinarsNon Members $15 per sessionAdvance Your Microsoft Excel SkillsPresented by Mike Gera, Managing Partner Healthcare Computer Training GroupNew to Excel? – HYPERLINK "" \o "Click here to register for the Beginner Course" Join us December 3, 2019 at 10 AM (EST)Overview of Microsoft Excel functionality and Worksheet Understanding the fundamentals of using formulasUnderstanding the proper way to Save an Excel spreadsheetFundamentals of spreadsheet terminology3 tracks geared towards your skill levelJoin us December 4th and 18th, and January 8th and 22nd Beginner (A1), Intermediate (A2) & Advanced (A3)The tracks will be held: A1 at 10 AM; A2 at 1 PM; A3 at 3 PM (EST)See page 2 for detailsTHE AGENDAS FOR THESE 1.5 HOUR WEBINAR PRESENTATIONS ARE OUTLINED ON PAGE 2ABOUT THE SPEAKER:Michael Gera is the Managing Partner of the Healthcare Computer Training Group. For the past 35 years, Mr. Gera has worked in the healthcare industry in technical, administrative and consulting capacities for various organizations. Mr. Gera is a graduate of Montclair State University (BA) and Florida State University (MSW and MS). Mr. Gera is adjunct faculty for the City University of New York (CUNY), where he conducts professional development seminars for a number of programs, including the on-line program in Health Information Management. Mr. Gera is a long time user of Microsoft Excel, and he is looking forward to sharing some ideas and approaches that will help you to improve data quality, while also increasing your ability to turn your raw data into actionable information. _____________________________________________________________________________Registration is FREE to HFMA members, $15 for non-members; CPE Credits: 1.5 per sessionTo receive CPE credit for this session, you will be required to register and log on to the event individually.______________________________________________________________For more information contact Celia Allen at CAllen@mra. or 615-905-2903NYS Education Department Sponsor License # 000337HFMA Metro New York Chapter is approved as a New York State CPE Provider in the area of specialized Knowledge and applications. In accordance with the standards of the National Registry of CPE Sponsors, the total credits have been rounded down. CPE credits have been granted on a 50-minute hour.TRACK A1 Beginner Microsoft Excel Users 10 AM (EST)DateThemeAgendaDec 4 2019Data Organization Technique 1. Fundamentals of Data Organization and Sorting 2. Fundamentals of Data Formatting 3. Understanding and Working With Dates & CurrencyDec 18 2019Filtering Data & Data Validation 1. Basic Data Filtering Techniques 2. Basic Data Validation Techniques 3. Designing Data Entry Forms Using Data ValidationJan 8 2020Cleaning Up Data Dumps from IT 1. Working With Imported Text Data 2. Simple Data Parsing Techniques 3. Basic Data Analysis of Imported DataJan 22 2020Harnessing the Power of VLOOKUP / HLOOKUP 1. Basic Concepts of VLOOKUP and HLOOKUP 2. Simple LOOKUP Templates and Examples 3. Applying LOOKUP Logic to Data AnalysisTRACK A2 Intermediate Microsoft Excel Users 1 PM (EST)Dec 4 2019Data Organization Techniques 1. Simplifying Complex Data Layout Situations 2. Working With Data on Multiple Worksheets 3. Working With Named RangesDec 18 2019Filtering Data & Data Validation 1. Review of Basic Data Filtering Techniques 2. Performing Quality Review Using Data Validation 3. Filtering Data in PlaceJan 8 2020Cleaning Up Data Dumps from IT 1. Importing Data With Embedded Spaces and Characters 2. Complex Data Parsing Techniques 3. Deleting Unwanted Data (Headers/Footers, for ex.)Jan 22 2020Harnessing the Power of VLOOKUP / HLOOKUP 1. Understanding the Structural Components of LOOKUP logic 2. Applying LOOKUP Logic to Financial Data Analysis 3. Applying LOOKUP Logic to Revenue Cycle Data AnalysisTRACK A3 Advanced Microsoft Excel Users 3 PM (EST)Dec 4 2019Data Organization Techniques 1. Organizing Complex Datasets 2. Using Logical Formulas to Clean Up Data 3. Data Export Cleansing TechniquesDec 18 2019Filtering Data & Data Validation 1. Overview of Advanced Data Filtering Techniques 2. Filtering In Place and Copy To Other Location 3. Combining Filtering With Data ValidationJan 8 2020Cleaning Up Data Dumps from IT 1. Deleting Unwanted Data (Headers/Footers) 2. Addressing Embedded Spaces and Characters 3. Using Access to Cleanse Excel DataJan 22 2020Harnessing the Power of VLOOKUP / HLOOKUP 1. Advanced Financial Templates Using VLOOKUP and HLOOKUP 2. Combining VLOOKUP Logic with Pivot Table Functionality 3. Using VLOOKUP to Analyze Key Performance Indicators (KPI) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download