|Promedica Computer Training
Promedica employees are eligible to enroll for the following classes. Please make sure you have approval from your supervisor to attend class. Minimum number of students to run a class is 3, maximum number is 15.

Microsoft Office Face to Face


Excel Beginner - Archbold
Date: October 19
Time: 8 am – 4:00 pm
Location: Northwest State Archbold
Fee: $179

Course Description


This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting. Lunch and book are included in the class fee.

Excel Beginner - Fostoria
Date: October 21
Time: 9 am – 4:30 pm
Location: Fostoria Learning Center
Fee: $150

Course Description


This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting. Lunch and book are included in the class fee.

Excel Intermediate - Archbold
Date: October 12 or October 27
Time: 8 am – 4:00 pm
Location: Northwest State Archbold
Fee: $179

Course Description


This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks. Lunch and manual are included in course fee.

Excel Intermediate - Fostoria
Date: November 11
Time: 9 am – 4:30 pm
Location: Fostoria Learning Center
Fee: $150

Course Description


This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks. Lunch and manual are included in course fee.

Excel Advanced - Archbold
Date: May 25
Time: 8 am – 4:00 pm
Location: Northwest State Archbold
Fee: $179
Course Description


This, the third level of the Excel training program, explores the advanced features in Excel 2016. Students will cover how to automate worksheet functionality, audit worksheets, analyze data, work with multiple workbooks, export Excel data and import/export XML data. Lunch and manual included in course fee.

Excel Pivot Tables - Fostoria
Date: October 28
Time: 9 am – 12:30 pm
Location: Fostoria Learning Center
Fee: $60

Course Description


New to pivot tables or want to get more out of them? This course is designed to give you a solid understanding of pivot tables. Pivot tables are a powerful tool within Excel that can be used to analyze, sort, filter and present data in an understandable way. Manual included in course fee.

Webinars


Excel Logical and Lookup Functions
Date: October 13
Time: 1:00pm – 2:30pm
Fee: $40

Course Description


In this webinar you will learn more about Excel’s functions to work with data. You will learn to name ranges of cells to help with navigation and aid formulas that reference large tables. Then dive into functions that allow for branching and retrieving data to add power to your spreadsheets.

Excel Streamlining Work with Macros
Date: November 3
Time: 1:00pm – 2:30pm
Fee: $40

Course Description


Excel macros can help you streamline your work both tasks that take many steps as well as those that are repetitive. In this course you will learn about the structure of macros and how to use the macro recorder to begin building your own. Then you will dig deeper into Visual Basic for Applications (VBA) and learn how to edit and write macros with this language.

Getting Started with Microsoft Teams
Date:November 17
Time: 1:00pm – 2:30pm
Fee: $40

Course Description


Learn how to schedule meetings, create functional teams and integration between Teams and the rest of Microsoft Office in this interactive webinar.

Excel Power Query
Date: December 1
Time: 1:00pm – 2:30pm
Fee: $40

Course Description


Excel Power Query is a tool that helps you to query data from a data source to prepare it for use as information. The queried data can be used by Power Pivot, pivot tables and in a spreadsheet. Learn how to query databases and web sources in this webinar.

|Promedica Computer Training Sign up

|F.A.Q.
Can I sign up for several classes at once?
Yes, if your supervisor approves of this.
How are these classes paid for?
You may purchase them yourself and possibly submit for reimbursement or use your department’s pcard. Please make sure you have supervisor approval to take the class.
Deadline to withdraw from class?
Three business days prior to class start date. If you do not withdraw by the withdrawal date you will still be charged for the class. You may transfer your registration to another employee up to the day prior to the class.
What if I get into class and it isn’t the right class for me?
Let the instructor know before/at the first break. You can then transfer your registration to another upcoming class.
What if there not enough students for the class to run?
Registrations will be confirmed two business days prior to class start date.
What is meant by supervisor approval required?
The course fees are payable by the individual or the department, so if you are charging to the department, you will need to be sure you have approval to do this.
I want a class I don’t see offered