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 constantly￼maintained 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.
Microsoft Certified Sharepoint Specialist Microsoft Office Specialist Master Certification (MOS) Microsoft Word, Excel, PowerPoint Adobe InDesign, Photoshop, Dreamweaver
courses with 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
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
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
This course is an introduction to Office 365 Sites. Upon completion of this course, users will have a basic understanding of Sharepoint Sites and Sites structure, navigation, libraries, searching, newsfeeds, views, permissions, and organization. Students will learn the differences of Libraries and Lists and how to create different kinds of Libraries and Lists, add files to Libraries, add items to Lists, learn to use the Newsfeed to keep abreast of action on the site, and create and customize Views. In addition, students will explore Site and content organization, understand navigation of sites, search for content, and learn the basics of Permissions.Last Release: 05/01/18
This course will cover the Office 365 program Power BI. Power BI is a powerful business intelligence tool for analyzing your data and presenting it visually. This course will cover both the Power BI web app as well as the Power BI Desktop app. Topics covered include getting started with Power BI, connecting to data, visualizing data, publishing your visualizations in dashboards and reports, and connecting to other apps like Excel.Last Release: 05/01/18