facebook-pixel
$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Excel 2019 Intermediate

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Instructor: Intellezy Trainers

  • Understand and use Excel intermediate level features. 
  • You should have a basic understanding of Excel 2019 Introduction or equivalent knowledge or experience.
  • Learn how to link workbooks and worksheets, work with range names, sort and filter range data, & analyze and organize with tables.

Course Description

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.

What am I going to get from this course?

Understand and use Excel Intermediate level features. 

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Excel 2019 Introduction course or equivalent knowledge or experience.

Who should take this course? Who should not?

Those looking to increase knowledge of Excel 2019. 

Curriculum

Module 1: Introduction

Lecture 1 Introduction

Module 2: Linking Workbooks and Worksheets

Lecture 2 Linking Workbooks and Worksheets
Lecture 3 Linking Worksheets with 3D References
Lecture 4 Understanding the Consolidate Feature

Module 3: Working with Range Names

Lecture 5 What are Range Names?
Lecture 6 Using the Name Box and Define Name
Lecture 7 Using Create from Selection

Module 4: Sorting and Filtering Range Data

Lecture 8 Differences Between Sorting and Filtering
Lecture 9 Sorting Lists
Lecture 10 Filtering Lists
Lecture 11 Creating Subtotals

Module 5: Analyzing and Organizing with Tables

Lecture 12 Creating Tables and Understanding the Benefits
Lecture 13 Understanding the Elements of a Table
Lecture 14 Formatting a Table
Lecture 15 Sorting and Filtering Tables
Lecture 16 Filtering with Slicers
Lecture 17 Calculating with Tables
Lecture 18 Removing Erroneous Table Data
Lecture 19 Exporting, Refreshing, and Converting Tables

Module 6: Using Conditional Formatting

Lecture 20 What is Conditional Formatting?
Lecture 21 Highlight Cells and Top Bottom Rules
Lecture 22 Data Bars, Icon Sets, and Color Scales
Lecture 23 Using Custom Fonts and Colors
Lecture 24 Using Custom Conditional Formatting
Lecture 25 Modifying or Removing Conditional Formatting

Module 7: Displaying Data Graphically

Lecture 26 What are Charts?
Lecture 27 Creating Charts
Lecture 28 Understanding Chart Elements
Lecture 29 Modifying Chart Elements
Lecture 30 Changing and Moving Charts
Lecture 31 Filtering a Chart
Lecture 32 Formatting Charts
Lecture 33 Adjusting Numbering
Lecture 34 Creating Dual Axis Charts
Lecture 35 Forecasting with Trendlines
Lecture 36 Creating a Chart Template
Lecture 37 Displaying Trends with Sparklines

Module 8: Understanding PivotTables, PivotCharts, and Slicers

Lecture 38 What is a PivotTable?
Lecture 39 Creating a PivotTable
Lecture 40 Working with the PivotTable Fields Pane
Lecture 41 Data Organization and Analysis with PivotTables
Lecture 42 Formatting PivotTables
Lecture 43 Creating a PivotChart
Lecture 44 Modifying and Formatting a PivotChart
Lecture 45 Using Slicers and Timeline Slicers

Module 9: Working with Advanced PivotTables and PowerPivot Features

Lecture 46 Using the PivotTable and PivotChart Wizard
Lecture 47 Adding a Calculated Field
Lecture 48 Adding a Calculated Item
Lecture 49 Applying Conditional Formatting to a PivotTable
Lecture 50 Creating Filter Pages for a PivotTable
Lecture 51 Enabling the PowerPivot Add-in

Module 10: Conclusion

Lecture 52 Course Recap
Quiz 1 Excel 2019 Intermediate - Final Assessment
350