Ryan Jesperson

INSTRUCTOR

4.8 (19 ratings)

"

My training philosophy is all about understanding the big picture. It’s not enough to know which buttons to push, you need to understand why and how the system works in total. As an instructor I focus on helping students understand how and why the system works the way it does, and once that is understood, it makes every program that follows a little less intimidating. I enjoy showing students a command that will save them untold amounts of time and watching their eyes light up in recognition.

"

Ryan Jesperson is an Applications Trainer who joined New Horizons in 2010. He has been a teacher for 10 years, and has taught every age and ability – from Youth Summer Camps to the college level. He first fell in love with computers in the fifth grade, and whether it was writing DOS as a child or HTML in college, he has constantlymaintained a passion for technology. His teaching is heavily theoretical and integrates blended modalities – from the traditional classroom to Online LIVE virtual learning and On-sites. As a New Horizons instructor, Dr. Jesperson has been in constant demand, travelling across the country to deliver training for clients such as Novartis,The Bill and Melinda Gates Foundation, ESPN, Hamilton Sunstrand, UTC, Harvard University, Kayak.com, Allied World, and UMass Amhearst. Ryan is also an accomplished musician and composer, and has performed across the country as a jazz pianist.

CREDENTIALS

Microsoft Certified Sharepoint Specialist Microsoft Office Specialist Master Certification (MOS) Microsoft Word, Excel, PowerPoint Adobe InDesign, Photoshop, Dreamweaver

courses with Ryan Jesperson

Intermediate 04 Hrs 40 Min Ryan Jesperson

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

Last Release: 02/04/19
Intermediate 04 Hrs 31 Min Ryan Jesperson

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

Last Release: 01/21/19
Beginner 02 Hrs 14 Min Ryan Jesperson

This course is designed to introduce students to the new features of Office 365. Students will review the common changes across the suite of products such as co-authoring, icons, Microsoft translator, inking tools, new chart types, and the accessibility checker. Students will review the individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access.

Last Release: 01/10/19