Excel 2019 Intermediate

From workbooks to sparklines...

4.65 (11 reviews)
Udemy
platform
English
language
Other
category
28
students
5 hours
content
Aug 2022
last update
$19.99
regular price

What you will learn

Learn the building blocks of Intermediate Excel 2019 functionality.

Link Workbooks and Worksheets.

Work with Range Names and Sort and Filter Range Data.

Analyze and Organize with Tables.

Use Conditional Formatting and Display Data Graphically.

Outline with Subtotals and Groups.

Understand PivotTables, PivotCharts, and Slicers as well as Advanced Use of PivotTables and PowerPivot.

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.

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.


This course aligns with the CAP Body of Knowledge and should be approved for 4.5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Content

Introduction

Introduction

Linking Workbooks and Worksheets

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

Working with Range Names

What are Range Names?
Using the Name Box and Define Name
Using Create from Selection

Sorting and Filtering Range Data

Differences Between Sorting and Filtering
Sorting Lists
Filtering Lists
Creating Subtotals

Analyzing and Organizing with Tables

Creating Tables and Understanding the Benefits
Understanding the Elements of a Table
Formatting a Table
Sorting and Filtering Tables
Filtering with Slicers
Calculating with Tables
Removing Erroneous Table Data
Exporting, Refreshing, and Converting Tables

Using Conditional Formatting

What is Conditional Formatting?
Highlight Cells and Top Bottom Rules
Data Bars, Icon Sets, and Color Scales
Using Custom Fonts and Colors
Using Custom Conditional Formatting
Modifying or Removing Conditional Formatting

Displaying Data Graphically

What are Charts?
Creating Charts
Understanding Chart Elements
Modifying Chart Elements
Changing and Moving Charts
Filtering a Chart
Formatting Charts
Adjusting Numbering
Creating Dual Axis Charts
Forecasting with Trendlines
Creating a Chart Template
Displaying Trends with Sparklines

Understanding PivotTables, PivotCharts, and Slicers

What is a PivotTable?
Creating a PivotTable
Working with the PivotTable Fields Pane
Data Organization and Analysis with PivotTables
Formatting PivotTables
Creating a PivotChart
Modifying and Formatting a PivotChart
Using Slicers and Timeline Slicers

Working with Advanced PivotTables and PowerPivot Features

Using the PivotTable and PivotChart Wizard
Adding a Calculated Field
Adding a Calculated Item
Applying Conditional Formatting to a PivotTable
Creating Filter Pages for a PivotTable
Enabling the PowerPivot Add-in

Conclusion

Course Recap

Assessment

Excel 2019 Intermediate Assessment

Screenshots

Excel 2019 Intermediate - Screenshot_01Excel 2019 Intermediate - Screenshot_02Excel 2019 Intermediate - Screenshot_03Excel 2019 Intermediate - Screenshot_04

Reviews

Solomon
October 11, 2023
I enjoyed the course. I like the pace; not too fast and not too slow. The instructor kept it simple which made it easy to understand.

Charts

Price

Excel 2019 Intermediate - Price chart

Rating

Excel 2019 Intermediate - Ratings chart

Enrollment distribution

Excel 2019 Intermediate - Distribution chart

Related Topics

2187672
udemy ID
1/31/2019
course created date
11/22/2019
course indexed date
Bot
course submited by