Excel 2010 Level 3

The videos in this suite of Lessons are for those who wish to delve deeper. Specifically through PivotTables you will enhance the presentation and organisation of your data. Investigate also the value of the SumProduct, Index and Match functions and learn to provide focus to text and figures through Conditional Formatting.

Buy a Subscription to this Course

Course Content

Lessons Status
1

Lesson 1 – Working with Basic PivotTables

2

Lesson 2 – Customising PivotTables

3

Lesson 3 – Sorting & Filtering in a PivotTable

4

Lesson 4 – Grouping in a PivotTable

5

Lesson 5 – Calculating in a PivotTable

6

Lesson 6 – Working with Macros

7

Lesson 7 – Conditional Formatting using Formulas

8

Lesson 8 – Applying ‘Left Lookup’

9

Lesson 9 - The SUMPRODUCT Function