MS Excel Complete Course – Beginner to Advanced
Categories: Productivity & Career
Course Content
Excel का परिचय और बेसिक्स
-
-
Excel Interface की समझ
-
Workbook और Worksheet का परिचय
-
Cells, Rows और Columns Explained
-
Data Entry और Editing Basics
-
Excel Views और Navigation Tips
-
Save, Open और File Formats
Formatting और Page Layout
-
Font, Color और Alignment
-
Cell Borders और Fill Color
-
Format Painter और Clear Formats
-
Wrap Text, Merge & Center
-
Number Formatting (Currency, Date आदि)
-
Conditional Formatting Basics
-
Sheet Tab Color और Rename
-
Page Layout, Orientation और Margins
-
Print Titles, Print Area और Gridlines
Basic Formulas & Functions
-
Formulas की शुरुआत (=, +, -, *, /)
-
Cell Referencing: Relative, Absolute, Mixed
-
SUM, AVERAGE, MIN, MAX
-
COUNT, COUNTA, COUNTBLANK
-
ROUND, ROUNDUP, ROUNDDOWN
-
Basic Math Functions
-
CONCATENATE और TEXTJOIN
-
TODAY, NOW और DATE Functions
-
Basic Error Handling: IFERROR
-
Formula Auditing और Trace Precedents
Charts और Visualization
-
Chart Insert करना (Bar, Column, Line)
-
Chart Elements: Title, Axis, Labels
-
Pie Chart और Donut Chart
-
Combo Charts
-
Sparklines और Data Bars
-
Formatting Charts Professionally
-
Dynamic Chart Titles
-
Best Chart Practices
Logical Functions
-
IF Statement Basics
-
Nested IF और AND/OR Functions
-
IFS Function
-
SWITCH Function
-
NOT Function ?
-
IFERROR vs IFNA
-
TRUE/FALSE Logic
-
Conditional Calculation with IF
-
Logical Charts & Visual Logic
Data Sorting और Filtering
-
Basic Sorting (Text, Numbers, Date)
-
Multi-Level Sorting
-
AutoFilter और Custom Filter
-
Advanced Text Filters
-
Filter by Color
-
Remove Duplicates और Unique List
Lookup & Reference Functions
-
VLOOKUP Basics
-
VLOOKUP with Approximate Match
-
HLOOKUP
-
INDEX और MATCH का उपयोग
-
XLOOKUP की शुरुआत
-
Dynamic Arrays के साथ Lookup
-
LOOKUP Function
-
INDIRECT Function
-
OFFSET Function
-
CHOOSE Function
Data Validation और Forms
-
Data Validation Basics
-
Drop-down List बनाना
-
Custom Validation Rules
-
Input Message और Error Alert
-
Dependent Drop-down Lists
-
Form Controls (Buttons, Checkboxes)
-
User-Friendly Input Forms
Text और Data Cleaning Functions
-
TRIM, CLEAN, LEN
-
LEFT, RIGHT, MID
-
FIND और SEARCH
-
SUBSTITUTE और REPLACE
-
TEXT Function
-
VALUE और TEXT to Columns
-
Flash Fill
-
Remove Duplicates vs Unique
Advanced Data Tools
-
Named Ranges
-
Goal Seek
-
What-If Analysis
-
Scenario Manager
-
Data Table
-
Consolidate Data
-
Grouping and Subtotal
-
Power Query Intro
-
Solver Tool
Pivot Tables और Dashboard Design
-
Pivot Table Introduction
-
Grouping और Filtering in Pivot
-
Calculated Fields
-
Pivot Charts
-
Slicers और Timelines
-
Dashboard Components
-
Interactive Dashboard with Pivot
Security, Sharing और Printing
-
Worksheet और Workbook Protection
-
Password Setup
-
Share Workbook & Co-author
-
Sheet Hide/Unhide और Protect
-
Print Area Setup
-
Export to PDF
Real-World Projects और Automation
-
Attendance Sheet बनाना
-
Sales Tracker Dashboard
-
Budget Planner & Tracker
-
Final Project: Dynamic Excel Report with Dashboard
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
