Excel 2013 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 LOOKUP, 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 – Create and Work with a Basic PivotTable

2

Lesson 2 – Customise 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 – Using the LOOKUP Functions

7

Lesson 7 – Create Left LOOKUPs using INDEX and MATCH

8

Lesson 8 – Conditional Formatting with Functions

9

Lesson 9 – Macros

10

Lesson 10 – The SUMPRODUCT Function

11

Lesson 11 - AGGREGATE