HDI

Bestseller

0 rating

CERTIFICATE of BASIC COMPUTER COURSE WITH ADVANCE EXCEL(M-BCCWAE-7633)

Last updated Apr, 2026
Certified Course

₹5,000 ₹6,000

Enquire Now

Course Includes

Duration4 Months
Enrolled1
Lectures100
Videos0
Notes0
CertificateYes

What you'll learn

A Basic Computer Course with Advanced Excel is a dual-focus program designed to build fundamental digital literacy before transitioning into high-level data management. It is ideal for students, office administrators, and professionals in finance or HR who need to manage large datasets efficiently.

Course Syllabus

Phase 1: Basic Computer Fundamentals

Computer Basics: Understanding hardware (CPU, I/O devices), software types, and basic troubleshooting.
Operating Systems: Managing files/folders, using the taskbar, and personalising system settings in Windows/Linux.
Internet & Email: Safe browsing, using search engines, and professional email etiquette.
MS Office Basics: Introduction to MS Word (documentation) and MS PowerPoint (presentations).

Phase 2: Intermediate to Advanced Excel

Foundational Excel: Interface navigation, data entry, and basic formulas (SUM, AVERAGE, MIN, MAX).
Advanced Formulas: Mastery of VLOOKUP/HLOOKUP, INDEX-MATCH, Nested IF statements, and Array formulas.
Data Management: Multi-level sorting, advanced filtering, and Data Validation (creating drop-down lists).
Analysis Tools: Using Pivot Tables & Pivot Charts for dynamic summaries and What-If Analysis (Goal Seek, Scenario Manager, Solver).