Excel Webinar Series
Excel Webinar Series

​The Indiana Hospital Association is pleased to partner with Melissa Esquibel to offer a five-part Microsoft Excel webinar series. Over the past several years, Melissa has been a great resource for IHA staff and our members. As a Microsoft Certified Trainer (MCT) with more than 25 years in business application technology, Melissa has a unique ability to make learning programs enjoyable AND valuable.  

Each 90-minute webinar in the series will include assignments which will prepare the learner for the next webinar. Regardless of whether a learner attends a single webinar or the entire series, there will be files prepared for each level which will represent the completed assignment.

Part One: Foundations 

For those that are not comfortable in Excel beyond filling out worksheets that someone else prepared. This session goes over the basics of building lists and basic formulas, as well as formatting techniques and creating templates.

Class Materials

Handout

Test File

Webinar Recording

Play-Excel Foundations.mp4


Part Two: Formula Workshop

For those comfortable with SUM, AVERAGE and other basic functions, but who need to up their game by including logical (IF, AND, OR, SUMIF) and lookup (VLOOKUP, INDEX, MATCH, LOOKUP) functions. In this session, we learn how functions are built and combined to allow Excel to do most of the heavy lifting with lists and calculations. You'll learn not only how to use these powerful functions, but what to do when they don't work.

Class Materials

Handout

Test File

Webinar Recording​

Play-ExcelFormulas.mp4


Part Three: Pivot Tables

One whole session on one of Excel's most powerful tools. Whether you have worked with them or not, this session will have even your largest datasets tamed and telling you what you want to know. This session is appropriate for those with little or no experience in Pivot Tables, as well as those who have worked with Pivot Tables, but who have little formal training.

Class Materials

Handout

Test File

Webinar Recording​


Part Four: Charts and Graphs

Creating charts can be a challenge. Creating ones that update themselves and continue to communicate clearly can be frustrating, until you know the tricks the pros use to do the hard work only once. This session not only covers the how-to of charts, but the “how do I get them into my documents and presentations?" part. 

Class Materials

Handout

Test File

Webinar Recording​

Play-Charts and Graphs


Part Five: Advanced Excel List Tips & Tools

Are you importing data from other systems and spending way too much time whittling into the shape you need to work with it? This session focuses on taking bad lists and turning them into powerful information resources. You'll learn the right ways to import data into Excel and how to fix common errors and misalignments. Finally, you'll learn how to make short work of having to do it all again, by learning how to record and run a macro.

Class Materials

​Handout

Webinar Recording​

Play-Advanced Tips and Tools

Featured Speaker

Melissa Esquibel​ specializes in transforming those confused by technology into empowered users of their software tools. As a Microsoft Certified Trainer (MCT) with more than 25 years in business application technology, Melissa has a unique ability to make learning programs enjoyable AND valuable.

Whether teaching how to crunch numbers with Excel, deliver compelling presentations in PowerPoint or generate business-winning proposals and reports with Word, Melissa impresses clients with her knowledge and instruction.

Melissa's consulting career spans banking, manufacturing, telecommunications, energy and insurance, which allows her to provide real-world examples and applications. She has enabled everyone from rocket scientists to real estate brokers to put the “productive" back in office productivity software.

Melissa graduated summa cum laude from Strayer University with a Bachelor of Business Administration, majoring in Legal Studies.

CATEGORIES:
Member; Patient Safety; HR; Operations; Workforce

FEATURED

  • 2021-03-08 00:00:00Webinar Series: Healthcare Environments - Trends That Make an ImpactTopics include design considerations and trends, legalities, tax implications, regulatory requirements and financial questions that different types of care sites can pose to hospital leaders. https://www.ihaconnect.org/member/professional-development/Pages/Trends-in-Physical-Care-Sites.aspx
    WEBINAR

    Webinar Series: Healthcare Environment...

    Topics include design considerations and trends, legalities, tax implications, regulatory requirements and financial questions that different types of care sites can pose....

  • 2019-10-24 00:00:00Annual Membership MeetingOct. 24-25, 2019https://www.ihaconnect.org/member/professional-development/Pages/Annual-Membership-Meeting.aspx24-25 OCT 2019
  • 2018-10-10 00:00:00Perinatal Substance Use: Supportive Care for Infants, Mothers and StaffInnovative, supportive care approaches designed to improve outcomes for families and avoid staff burnout for those caring for this vulnerable population. https://www.ihaconnect.org/member/professional-development/Pages/Neonatal-Abstinence-Syndrome-Summit.aspx10 OCT 2018
    WEBINAR

    Perinatal Substance Use: Supportive Ca...

    Innovative, supportive care approaches designed to improve outcomes for families and avoid staff burnout for those caring for this vulnerable population.

  • 2018-10-05 00:00:00Minute Taking Made Simple WorkshopThe training is immediately applicable and designed for people at any skill level, from the inexperienced through very experienced minute takers. https://www.ihaconnect.org/member/professional-development/Pages/MinuteTaking10518.aspx5 OCT 2018

    Minute Taking Made Simple Workshop

    The training is immediately applicable and designed for people at any skill level, from the inexperienced through very experienced minute takers.