Excel 2019 – Level 3 Session 3 and Level 4 Session 3
Conditional Formatting, Sparklines, Filtering, Sorting, Subtotals and more – Free Course
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,
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.