Excel 2019 – Level 3 Session 3 and Level 4 Session 3

Conditional Formatting, Sparklines, Filtering, Sorting, Subtotals and more – Free Course

Deal Score+7

What you’ll learn

  • Apply conditional formatting
  • Transpose columns and rows

  • Filtering, sorting and creating sparklines

  • Remove duplicates
  • Subtotals and outlines


  • Before beginning, you will need to know how to use a Windows computer, including a mouse.
  • It would be good if you have used Microsoft Excel before, but this is not essential.
  • You should have the latest version of MS Excel installed on your computer. This is Excel 2019 or Office 2019, or the version of Excel included in the Office 365 subscription.


This course series has been recorded entirely on Excel 2019. This is an extract of two sessions from my full Excel 2019 beginner to intermediate course.

In this course, we’ll look at:

  • Applying conditional formatting,

  • Transposing columns and rows,

  • Sparklines,

  • Filtering,

  • Sorting,

  • Removing duplicates, and

  • Subtotals and outlines

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

So what are you waiting for? Let’s start learning.

Coupon Scorpion