Excel Essentials – Level 3: Take Control of Complex Data

$47.00

Master PivotTables, logical formulas, and lookups while learning how to work faster and solve bigger data challenges. View the demo.

Description

Once you’re confident with the basics, Level 3 introduces the tools that make Excel truly powerful. You’ll work with PivotTables, logical formulas (like IF, AND, OR), data validation, and lookup functions such as VLOOKUP and XLOOKUP. You’ll also get a beginner-friendly introduction to macros for automating repetitive processes.

This level is built for professionals who need to manage larger datasets, create more dynamic spreadsheets, and improve overall productivity. With these tools, you’ll reduce manual work, present insights more clearly, and handle complex data with confidence.

Modules Details

Excel Essentials Level 3 Modules:

  • Options
  • Worksheet Grouping
  • Dates & Times
  • Linking in Excel
  • Linking to PowerPoint/Word
  • Data Validation
  • Functions – IF and DATES
  • Functions – IF, AND, Nesting
  • Functions – VLOOKUP
  • Protection & Security
  • Pivot Tables – Introduction
  • What If – Scenario Manager
  • What If – Goal Seek
  • Macros – Introduction

Preview Excel Essentials Level 3

Pivot Tables Introduction