Excel 2019 Intermediate
Intermediate
5h
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 2019 Intermediate Introduction1 min
2. Linking Workbooks and Worksheets
2.1 Linking Worksheets and Workbooks7 min
2.2 Linking Worksheets with 3D References5 min
2.3 Understanding the Consolidate Feature6 min
3. Working with Range Names
3.1 What are Range Names6 min
3.2 Creating Range Names Using the Name Box and Define Name6 min
3.3 Creating Range Names Using Create from Selection3 min
4. Sorting and Filtering Range Data
4.1 Understanding the Differences Between Sorting and Filtering3 min
4.2 Sorting Lists7 min
4.3 Filtering Lists6 min
4.4 Creating Subtotals5 min
5. Analyzing and Organizing with Tables
5.1 Creating Tables and Understanding the Benefits6 min
5.2 Understanding the Elements of a Table5 min
5.3 Formatting a Table5 min
5.4 Sorting and Filtering Tables4 min
5.5 Filtering with Slicers7 min
5.6 Calculating with Tables6 min
5.7 Removing Erroneous Table Data5 min
5.8 Exporting, Refreshing, and Converting Tables5 min
6. Using Conditional Formatting
6.1 What is Conditional Formatting3 min
6.2 HIghlight Cells and Top Bottom Rules6 min
6.3 Data Bars, Icon Sets, and Color Scales6 min
6.4 Using Custom Fonts and Colors3 min
6.5 Using Custom Conditional Formatting5 min
6.6 Modyfing or Removing Conditional Formatting4 min
7. Displaying Data Graphically
7.1 What are Charts6 min
7.2 Creating Charts5 min
7.3 Understanding Chart Elements5 min
7.4 Modifying Chart Elements5 min
7.5 Changing and Moving Charts3 min
7.6 Filtering a Chart4 min
7.7 Formatting Charts13 min
7.8 Adjusting Numbering6 min
7.9 Creating Dual Axis Charts5 min
7.10 Forecasting with Trendlines5 min
7.11 Creating a Chart Template4 min
7.12 Displaying Trends with Sparklines8 min
8. Understanding PivotTables, PivotCharts, and Slicers
8.1 What is a PivotTable5 min
8.2 Creating a PivotTable7 min
8.3 Working with the PivotTable Fields Pane10 min
8.4 Basic Data Organization and Analysis with PivotTables8 min
8.5 Formatting PivotTables5 min
8.6 Creating a PivotChart4 min
8.7 Modifying and Formatting a PivotChart4 min
8.8 Using Slicers and Timeline Slicers8 min
9. Working with Advanced PivotTables andPowerPivot Features
9.1 Using the PivotTable and PivotChart Wizard3 min
9.2 Adding a Calculated Field4 min
9.3 Adding a Calculated Item4 min
9.4 Applying Conditional Formatting to a PivotTable4 min
9.5 Creating Filter Pages for a PivotTable4 min
9.6 Enabling the PowerPivot Add-in11 min
10. Conclusion
10.1 Excel 2019 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