Excel 2021 - Intermediate

Focused View

Intellezy Trainers

3:08:37

0 View

1. Introduction

1. Introduction.mp4

02:35

2. Linking Workbooks and Worksheets

1. Linking Workbooks and Worksheets.mp4

06:00

2. Linking Worksheets with 3D References.mp4

04:18

3. Understanding the Consolidate Feature.mp4

04:15

3. Working with Range Names

1. Understanding Range Names.mp4

02:18

2. Creating Range Names in the Name Box and Define Name Feature.mp4

03:54

3. Creating Range Names from a Selection.mp4

03:24

4. Sorting, Filtering, and Subtotaling

1. Understanding Sorting versus Filtering.mp4

02:43

2. Sorting Lists.mp4

03:50

3. Filtering Lists.mp4

03:17

4. Creating Subtotals.mp4

03:35

5. Analyzing and Organizing with Tables

1. Understanding and Creating Tables.mp4

05:09

2. Understanding the Elements of a Table.mp4

03:21

3. Formatting a Table.mp4

02:59

4. Sorting Tables.mp4

01:52

5. Filtering with Slicers.mp4

03:56

6. Calculating with Tables.mp4

04:18

7. Removing Erroneous Table Data.mp4

01:52

8. Exporting, Refreshing, and Converting Tables.mp4

01:57

6. Using Conditional Formatting

1. Working with Conditional Formatting.mp4

02:51

2. Highlighting Cells and Finding Top & Bottom Values.mp4

04:00

3. Applying Conditional Formatting Data Bars, Icon Sets, and Color Scales.mp4

08:02

4. Using Custom Fonts and Colors.mp4

02:21

5. Using Custom Conditional Formatting.mp4

04:57

6. Modifying or Removing Conditional Formatting.mp4

03:55

7. Displaying Data Graphically

1. Understanding Charts.mp4

02:09

2. Creating Charts.mp4

04:43

3. Working with Chart Elements.mp4

06:32

4. Changing and Moving Charts.mp4

03:48

5. Filtering a Chart.mp4

03:36

6. Formatting Charts.mp4

05:39

7. Formatting Numbers.mp4

03:35

8. Creating Dual Axis Charts.mp4

03:16

9. Forecasting with Trendlines.mp4

03:50

10. Creating a Chart Template.mp4

03:07

11. Displaying Trends with Sparklines.mp4

02:47

8. Understanding PivotTables, PivotCharts, and Slicers

1. Introducing PivotTables.mp4

03:52

2. Creating a PivotTable.mp4

03:04

3. Working with the PivotTable Fields Pane.mp4

05:22

4. Formatting PivotTables.mp4

03:32

5. Creating a PivotChart.mp4

05:27

6. Modifying and Formatting a PivotChart.mp4

03:58

7. Working with Slicers and Timeline Slicers.mp4

04:33

9. Working with Advanced PivotTables and PowerPivot Features

1. Using the PivotTable and PivotChart Wizard.mp4

02:40

2. Adding a Calculated Field.mp4

02:20

3. Adding a Calculated Item.mp4

01:58

4. Applying Conditional Formatting to a PivotTable.mp4

02:57

5. Using Filters in a PivotTable.mp4

02:11

6. Creating Filter Pages for a PivotTable.mp4

01:42

7. Enabling the PowerPivot Add-In.mp4

09:06

10. Conclusion

1. Course Recap.mp4

01:14

11. Excel 2021 Intermediate Assessment

1. Excel 2021 Intermediate Assessment.html

Description

Expand existing Excel 2021 knowledge

What You'll Learn?

Link Workbooks and Worksheets
Work with Range Names
Sort and Filter Range Data
Analyze and Organize with Tables
Use Conditional Formatting
Outline with Subtotals and Groups
Display Data Graphically
Understand PivotTables, PivotCharts, and Slicers
Advanced Use of PivotTables and PowerPivot

Who is this for?

Anybody wanting to expand on their Excel 2021 beginner experience.

What You Need to Know?

None

More details

Description
Unlock the full potential of Excel 2021 and transform your data handling skills with our Intermediate course. Designed for users who are familiar with the basics and ready to explore more complex functions, this course takes you beyond the surface into the depths of Excel's capabilities. In this comprehensive guide, you will delve into advanced formatting techniques, discover the power of functions and formulas, and learn how to link workbooks and worksheets effectively. By mastering these tools, you will be able to streamline your workflows, enhance your analytical abilities, and make data-driven decisions with confidence. Gain hands-on experience with real-world scenarios to apply what you learn immediately. Whether you're managing large datasets, performing complex calculations, or creating sophisticated reports, this course provides the expertise you need to use Excel more efficiently. Enhance your proficiency with Excel's tools to maintain large datasets, ensuring data integrity and accuracy. Learn to utilize advanced features such as conditional formatting, pivot tables, and macros to save time and automate repetitive tasks. By the end of this course, you will not only be equipped with intermediate skills but also understand how to harness Excel to its full potential, making you an asset in any data-intensive role. Join us to bridge the gap between basic knowledge and advanced Excel mastery, paving the way for professional growth and success.
Who this course is for:
Anybody wanting to expand on their Excel 2021 beginner experience.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Intellezy Trainers

Instructor's Courses

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.