Excel Courses at ExcelCraft

ACADEMY

Learn Excel Live or at Your Own Pace

Course 1: Basic Excel

(Live Online Batch + Recorded Course)

Who Can Join this Course?

Students

Job seekers

Business owners

Beginners with no Excel background

LMS Access

Assignments

Notes & Quizzes

Certificate

Basic Excel Course​ : Syllabus Overview

Module 1: Excel Foundation
  • What is Excel & its uses
  • Workbook, worksheet, rows, columns
  • Excel interface & shortcuts
  • Text, numbers, dates
  • Cell & number formatting
  • Wrap text, merge & centre
  • Arithmetic operators
  • SUM, AVERAGE, MIN, MAX
  • AutoFill & Flash Fill
  • Office data discipline
  • Accuracy & speed techniques
  • Mini practice file

Course 2: Advanced Excel with Template Designing

(Live Online Batch + Recorded Course)

Who Can Join this Course?

Working professionals

MIS executives

Analysts

Business owners

What Includes In this Course?

LMS Access

Assignments

Notes & Quizzes

Certificate

Advanced Excel with Template Designing Course​ : Syllabus Overview

Module 1: Data Management
  • Advanced sorting & filtering
  • Data validation & remove duplicates
  • IF, IFS, COUNTIF, SUMIF
  • VLOOKUP, HLOOKUP, XLOOKUP intro
  • Conditional formatting
  • Tables, charts & print setup
Module 4: Excel Soft Skills
  • Professional file naming
  • Presentation & reporting skills
  • Business requirement analysis
  • Input‑process‑output logic
  • Nested IF, INDEX‑MATCH
  • Dynamic ranges & IFERROR
Module 7: Dashboard & Automation
  • Dynamic charts & reports
  • Sheet protection & automation
  • Attendance tracker
  • Payroll & salary sheet
  • Sales, expense & invoice templates
  • Pricing Excel templates
  • Client communication
  • Delivery & support etiquette

Learning Formats Comparison

Live Batch

Recorded Course

Real‑time interaction

Live Practical Training

Instant Doubt Solving

Self-Paced Learning

Replay And Practice

Flexible Schedule

Not Sure Which Course Is Right for You?

Scroll to Top