We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal. Get started today!

Excel 365

Request a Free Trial

Course Overview

Instructor: Ryan Jesperson
Subject: Excel 365
Duration: 04 Hour 31 Minutes
Level: Intermediate
Pre-requisites: Excel 365 Introduction course or equivalent knowledge or experience.
CC Languages: Arabic, Chinese (Simplified) , English, French, German, Hindi, Japanese, Portuguese (Brazil), Russian, Spanish


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.

Introduction0min 46sec
Linking Workbooks and Worksheets Working with Range Names Sorting, Filtering, and Subtotaling Analyzing and Organizing with Tables Using Conditional Formatting Displaying Data Graphically Understanding PivotTables, PivotCharts, and Slicers Working with Advanced PivotTables and PowerPivot Features Conclusion
Course Recap2min 04sec

Ryan Jesperson

Ryan has always been interested in technology, starting in the 5th grade when he learned to code DOS. He went to school for music and English, graduating with degrees in both. After finishing his doctorate, he moved back to Hartford to be with his wife and subsequently began instructing. As a Senior Applications Instructor, he gets to merge his teacher training with his love for technology.

Learn More About Ryan Jesperson