A1
fx
=SUM()
B12
C3
=VLOOKUP()
100
Total
=IF()
AVERAGE

Training on Excel

5 Days

Timeline & Workbooks

Day 1: Excel Fundamentals & Basic Workbooks

Workbook

Day 2: Cleanup, VLOOKUP & Logical Operations

Workbook

Day 3: Intermediate Logic & Conditional Exercises

Logic Book Workbook

Day 4: Summaries, PivotTables & Slicers

Workbook

Day 5: Goal Seek, Data Tables & VBA Automation

Workbook

Getting Started

  1. Download workbooks from links.
  2. Open files in Excel (version 2016+).
  3. Click Enable Editing if prompted.

Quick Links

References & Guides

Open Guides

Online Final Exam

Start Exam

Exit Form

Open Form