Software Skills Training Excel 2021 - Intermediate

Excel 2021 Intermediate Skills & Tips

Excel 2021 - Intermediate

0 seconds of 2 minutes, 35 secondsVolume 90%

00:00

02:35

Overview

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.

Course Playlist

Introduction

1 videos

2 min 35 sec
- Introduction 2 min 35 sec
Linking Workbooks and Worksheets

3 videos

14 min 35 sec
- Linking Workbooks and Worksheets 6 min 1 sec
- Linking Worksheets with 3D References 4 min 18 sec
- Understanding the Consolidate Feature 4 min 16 sec
Working with Range Names

3 videos

9 min 39 sec
- Understanding Range Names 2 min 19 sec
- Creating Range Names in the Name Box and Define Name Feature 3 min 55 sec
- Creating Range Names from a Selection 3 min 25 sec
Sorting, Filtering, and Subtotaling

4 videos

13 min 26 sec
- Understanding Sorting Versus Filtering 2 min 43 sec
- Sorting Lists 3 min 51 sec
- Filtering Lists 3 min 17 sec
- Creating Subtotals 3 min 35 sec
Analyzing and Organizing with Tables

9 videos

27 min 8 sec
- Understanding and Creating Tables 5 min 9 sec
- Understanding the Elements of a Table 3 min 22 sec
- Formatting a Table 2 min 59 sec
- Sorting Tables 1 min 52 sec
- Filtering Tables 1 min 40 sec
- Filtering with Slicers 3 min 56 sec
- Calculating with Tables 4 min 19 sec
- Removing Erroneous Table Data 1 min 53 sec
- Exporting, Refreshing, and Converting Tables 1 min 58 sec
Using Conditional Formatting

6 videos

26 min 9 sec
- Working with Conditional Formatting 2 min 51 sec
- Highlighting Cells and Finding Top and Bottom Values 4 min 1 sec
- Applying Conditional Formatting - Data Bars, Icon Sets, and Color Scales 8 min 2 sec
- Using Custom Fonts and Colors 2 min 22 sec
- Using Custom Conditional Formatting 4 min 58 sec
- Modifying or Removing Conditional Formatting 3 min 55 sec
Displaying Data Graphically

11 videos

43 min 8 sec
- Understanding Charts 2 min 9 sec
- Creating Charts 4 min 43 sec
- Working with Chart Elements 6 min 32 sec
- Changing and Moving Charts 3 min 48 sec
- Filtering a Chart 3 min 37 sec
- Formatting Charts 5 min 40 sec
- Formatting Numbers 3 min 36 sec
- Creating Dual Axis Charts 3 min 17 sec
- Forecasting with Trendlines 3 min 51 sec
- Creating a Chart Template 3 min 7 sec
- Displaying Trends with Sparklines 2 min 48 sec
Understanding PivotTables, PivotCharts, and Slicers

7 videos

29 min 53 sec
- Introducing PivotTables 3 min 53 sec
- Creating a PivotTable 3 min 5 sec
- Working with the PivotTable Fields Pane 5 min 22 sec
- Formatting PivotTables 3 min 33 sec
- Creating a PivotChart 5 min 27 sec
- Modifying and Formatting a PivotChart 3 min 59 sec
- Working with Slicers and Timeline Slicers 4 min 34 sec
Working with Advanced PivotTables and PowerPivot Features

7 videos

23 min
- Using the PivotTable and PivotChart Wizard 2 min 41 sec
- Adding a Calculated Field 2 min 21 sec
- Adding a Calculated Item 1 min 59 sec
- Applying Conditional Formatting to a PivotTable 2 min 58 sec
- Using Filters in a PivotTable 2 min 12 sec
- Creating Filter Pages for a PivotTable 1 min 43 sec
- Enabling the PowerPivot Add-in 9 min 6 sec
Conclusion

1 videos

1 min 15 sec
- Recap 1 min 15 sec

For Business

Give your team access to award-winning training content on the most popular software & business skills. We have options for every budget, with tiered pricing available on user count and multi-year discounts automatically applied.

Intellezy Select 50

Build a custom 50-course library from the Intellezy complete library.

Intellezy Full Library

Access to full library of courses, including 11,000+ video lessons.

Your subscription includes:

The Most-Up-to-Date Contentt

Content Available in 20+ Languages

Course Assessments & Downloadable Files

Deliverability via Your SCORM-Compliant LMS or Our Easy-to-Navigate Platform

And More!

Billed Monthly

$15/month

$180 total annually

Billed Annually

$12.50/month

$150 total annually

Your subscription includes:

11,000+ Video Lessons

Content Available in 20+ Languages

The Most-Up-to-Date Content

Content Available in 20+ Languages

Course Assessments & Downloadable Files

And More!

Excel 2021 Intermediate Skills & Tips

Excel 2021 - Intermediate

Overview

Course Playlist

Intellezy Select 50

Intellezy Full Library

Your subscription includes:

Billed Monthly

Billed Annually

Your subscription includes:

Unlocked Your Course