Ryan Jesperson

INSTRUCTOR

4.9 (27 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

Beginner 03 Hrs 47 Min Ryan Jesperson

This course is designed to teach students an overview of end-user SharePoint interface and functionality. Students will also work with document libraries, work with lists and items, work with various views, update their personal profiles, use the Newsfeed, and learn about SharePoint.

Last Release: 09/20/19
Beginner 02 Hrs 06 Min Ryan Jesperson

This course give students a comprehensive overview of Flow, an office 365 app which allows users to create automated workflows between apps in order to receive notifications, and synchronize files, collect data. In this course, students will review the various types of Flows, learn how to build a Flow, and how to work with actions. They will also learn how to use approvals as well as how to share, import, and export a Flow.

Last Release: 09/20/19
Beginner 04 Hrs 38 Min Ryan Jesperson

This course introduces the user to Microsoft PowerApps, a tool that allows you to create forms and gather data. PowerApps is part of the Microsoft 365 suite and is the successor to InfoPath. In this course, you will learn how to modify SharePoint List Forms using PowerApps as well as how to work with PowerApp formulas. This course will also review some of the more advanced features of InfoPath, such as working with data sources. Finally, you will look at how to distribute your PowerApp, including how to share, embed, and export your app.

Last Release: 07/22/19
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
Beginner 02 Hrs 10 Min Ryan Jesperson

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
Beginner 03 Hrs 08 Min Ryan Jesperson

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