Excel 365 Intermediate
Intermediate
3h
By: Ryan Jesperson
Overview
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.
Modules
1. Introduction
1.1 Excel 365 Intermediate Introduction1 min
2. Linking Workbooks and Worksheets
2.1 Linking Workbooks and Worksheets5 min
2.2 Linking Worksheets with 3D References4 min
2.3 Understanding the Consolidate Feature3 min
3. Working with Range Names
3.1 What are Range Names2 min
3.2 Creating Range Names using the Name Box and Define Name4 min
3.3 Creating Range Names using Create from Selection3 min
4. Sorting, Filtering, and Subtotaling
4.1 Understanding the Differences Between Sorting and Filtering2 min
4.2 Sorting Lists5 min
4.3 Filtering Lists4 min
4.4 Creating Subtotals3 min
5. Analyzing and Organizing with Tables
5.1 Creating Tables and Understanding the Benefits3 min
5.2 Understanding the Elements of a Table3 min
5.3 Formatting a Table2 min
5.4 Sorting and Filtering Tables2 min
5.5 Filtering with Slicers4 min
5.6 Calculating with Tables3 min
5.7 Removing Erroneous Table Data3 min
5.8 Exporting, Refreshing, and Converting Tables2 min
6. Using Conditional Formatting
6.1 What is Conditional Formatting2 min
6.2 Conditional Formatting-Highlight Cells and Top Bottom Rules5 min
6.3 Conditional Formatting-Data Bars, Icon Sets, and Color Scales6 min
6.4 Using Custom Fonts and Colors2 min
6.5 Using Custom Conditional Formatting4 min
6.6 Modifying or Removing Conditional Formatting3 min
7. Displaying Data Graphically
7.1 What are Charts2 min
7.2 Creating Charts5 min
7.3 Understanding Chart Elements3 min
7.4 Modifying Chart Elements3 min
7.5 Changing and Moving Charts3 min
7.6 Filtering a Chart2 min
7.7 Formatting Charts5 min
7.8 Creating Dual Axis Charts4 min
7.9 Forecasting with Trendlines4 min
7.10 Creating a Chart Template2 min
7.11 Displaying Trends with Sparklines3 min
8. Understanding PivotTables, PivotCharts, and Slicers
8.1 What is a PivotTable4 min
8.2 Creating a PivotTable5 min
8.3 Working with the PivotTable Fields Pane6 min
8.4 Basic Data Organization and Analysis with PivotTables8 min
8.5 Formatting PivotTables4 min
8.6 Creating a PivotChart7 min
8.7 Modifying and Formatting a PivotChart3 min
8.8 Adding Slicers and Timeline Slicers5 min
8.9 Formatting Slicers4 min
8.10 Using the Analyze Data Feature2 min
9. Working with Advanced PivotTables and PowerPivot Features
9.1 Using the PivotTable and PivotChart Wizard3 min
9.2 Adding a Calculated Field4 min
9.3 Adding a Calculated Item2 min
9.4 Applying Conditional Formatting to a PivotTable3 min
9.5 Creating Filter Pages for a PivotTable2 min
9.6 Analyzing Multiple Tables with a PivotTable6 min
10. Conclusion
10.1 Excel 365 Intermediate Recap2 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES