Live Learning Lounge 2020 > Live Learning Lounge October 2020

Excel Level 3 Parts 1 & 2

Microsoft Excel Level 3 Part 1

Duration:                 90 minutes

Medium:                  Zoom

Audience

This course is aimed at participants wanting to expand their Excel skills towards the more advanced functionality.   It is recommended delegates have attended the Excel Level 1 & 2 (all sessions) or have the equivalent knowledge.  The course will look at Pivot Tables, What IF Analysis and securing data.

Content

• A brief recap on previous items taught on level 2 – part 2
• What IF Analysis
• Scenario Manager
• Scenario reports
• Pivot Tables
• Pivot Charts
• Slicer
• Macro’s
• Data Validation
• Data Validation Lists

Microsoft Excel Level 3 Part 2

Audience

This course is aimed at participants who have completed the Excel  Level 1 Parts 1&2, Level 2 Parts 1&2 and Level 3 Part 1 or who have the equivalent knowledge (see overview for content) and wish to learn more of the advanced functionality.

Content

• A brief recap on previous items taught on level 3 – part 1
• Securing Documents, sheets, and cells
• Data Validation
• Developer Tab
• Macros
• Show Hide functionality
• Using Comment
• Creating pick lists

Cost: 0

< back