Excel Intermediate

About Course

In this Excel 2019 Intermediate course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyse and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and spark lines. Additionally, students will also understand PivotTables, Pivot Charts, and slicers and work with advanced PivotTables and PowerPivot features. This course has an assessment which may be required for a certificate to be generated.

Course Content

1. Introduction

1.Introduction

00:00

2. Linking Workbooks and Worksheets

3. Working with Range Names

4. Sorting and Filtering Range Data

5. Analysing and Organizing with Tables

6. Using Conditional Formatting

7. Displaying Data Graphically

7.1 What are Charts

00:00
7.2 Creating Charts

00:00
7.3 Understanding Chart Elements

00:00
7.4 Modifying Chart Elements

00:00
7.5 Changing and Moving Charts

00:00
7.6 Filtering a Chart

00:00
7.7 Formatting Charts

00:00
7.8 Adjusting Numbering

00:00
7.9 Creating Dual Axis Charts

00:00
7.10 Forecasting with Trendlines

00:00
7.11 Creating a Chart Template

00:00
7.12 Displaying Trends with Spark lines

00:00

8. Understanding Pivot Tables Pivot Charts and slices

9. Working with Advanced Pivot Tables and Power Pivot Features

10. Conclusions

About Course

What Will You Learn?

Course Content

1. Introduction

1.Introduction

2. Linking Workbooks and Worksheets

2.1 Linking Workbooks and Worksheets

2.2Linking Worksheets with 3D References

2.3 Understanding the Consolidate Feature

3. Working with Range Names

3.1 What are Range Names

3.2 Using the Name Box and Define Name

3.3 Using Create from Selection

4. Sorting and Filtering Range Data

4.1 Differences Between Sorting and Filtering

4.2 Sorting Lists

4.3 Filtering Lists

4.4 Creating Subtotals

5. Analysing and Organizing with Tables

5.1 Creating Tables and Understanding the Benefits

5.2 Understanding the Elements of a Table

5.3 Formatting a Table

5.4 Sorting and Filtering Tables

5.5 Filtering with Slicers

5.6 Calculating with Tables

5.7 Removing Erroneous Table Data

5.8 Exporting, Refreshing, and Converting Tables

6. Using Conditional Formatting

6.1 What is Conditional Formatting

6.2 Highlight Cells and Top Bottom Rules

6.3 Data Bars, Icon Sets, and Colour Scales

6.4 Using Custom Fonts and Colours

6.5 Using Custom Conditional Formatting

6.6 Modifying or Removing Conditional Formatting

7. Displaying Data Graphically

7.1 What are Charts

7.2 Creating Charts

7.3 Understanding Chart Elements

7.4 Modifying Chart Elements

7.5 Changing and Moving Charts

7.6 Filtering a Chart

7.7 Formatting Charts

7.8 Adjusting Numbering

7.9 Creating Dual Axis Charts

7.10 Forecasting with Trendlines

7.11 Creating a Chart Template

7.12 Displaying Trends with Spark lines

8. Understanding Pivot Tables Pivot Charts and slices

8.1 What is a PivotTable

8.2 Creating a PivotTable

8.3 Working with the PivotTable Fields Pane

8.4 Data Organization and Analysis with PivotTables

8.5 Formatting PivotTables

8.6 Creating a PivotChart

8.7 Modifying and Formatting a PivotChart

8.8 Using Slicers and Timeline Slicers

9. Working with Advanced Pivot Tables and Power Pivot Features

9.1 Using the PivotTable and PivotChart Wizard

9.2 Adding a Calculated Field

9.3 Adding a Calculated Item

9.4 Applying Conditional Formatting to a PivotTable

9.5 Creating Filter Pages for a PivotTable

9.6 Enabling the PowerPivot Add-in

10. Conclusions

10.1 Course Recap

Student Ratings & Reviews