Excel 365/2016 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 & 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 - Advanced Charts

7

Lesson 7 - Using the LOOKUP Functions

8

Lesson 8 - Create Left LOOKUPs Using INDEX & MATCH

9

Lesson 9 - Conditional Formatting with Functions

10

Lesson 10 - SUMPRODUCT

11

Lesson 11 - AGGREGATE

12

Lesson 12 - Macros

13

Lesson 13 - What-if Analysis