MS EXCEL Crash course for Beginners in URDU/HINDI
Автор: NaseebCodeStudio
Загружено: 2025-10-27
Просмотров: 115
🔔 Complete MS Excel Fundamentals Course in Urdu/Hindi (2 Hours +)
Welcome to this full-length training session on Microsoft Excel where we cover everything from basic interface and shortcuts to advanced functions and operators. Whether you’re a beginner or looking to upgrade your job skills, this course is designed to help you master Excel for professional use.
✅ What You’ll Learn:
• Introduction to Excel: What it is, file extensions, run command, welcome screen, light/dark theme
• Excel interface: Workbook vs worksheet, rows, columns, cells
• Fundamental operations: shortcut keys, drag-handle, row/column insert/delete, cell editing
• Formula vs function: understanding the difference and how to apply them
• Random number functions: RAND, RANDBETWEEN
• Operators & working with data: addition, subtraction, multiplication, division, caret (^), percentage
• PEMDAS/BODMAS rule for correct calculation order
• Core functions: SUM, AVERAGE, MIN, MAX, LARGE, SMALL, COUNT, COUNTA, COUNTBLANK
• Advanced math and text functions: SQRT, POWER, PRODUCT, ROMAN, ABS, CHAR, CODE
• Text functions: UPPER, LOWER, PROPER, LEN, CONCAT/CONCATENATE, LEFT, MID, RIGHT, REPLACE, REPT, TRIM, FIND
• Lookup & reference functions: MATCH, TRANSPOSE, INDEX, ROW, COLUMN
• Number functions: CONVERT, SEQUENCE, MODE/MODE.MULT/MODE.SNGL, MOD, MEDIAN, ROUND, FLOOR, CEILING, CHOOSE, ADDRESS, fixing cell references
🕰️ Timestamps / Topics Covered:
00:00 – Introduction to the Course
02:30 – Introduction to MS Excel
04:50 – Extension
06:18 – Run Command
06:45 – Welcome Screen & Dark/Light Theme
09:44 – Interface of MS Excel
16:40 – Excel Fundamentals & How to Work – Shortcut Keys
27:04 – Drag Handle Usage
32:38 – Row & Column Customization
33:45 – Row & Column Delete / Insert
34:35 – Cell Editing – Different Ways
36:40 – Formula vs Function
38:40 – Random Numbers Functions
43:55 – Operators & Working with Data
52:00 – PEMDAS/BODMAS
59:05 – RAND & RANDBETWEEN Functions
1:03:45 – SUM & AVERAGE Functions
1:07:35 – MIN, MAX, LARGE, SMALL Functions
1:13:21 – COUNT, COUNTA, COUNTBLANK Functions
1:18:30 – SQRT, POWER, PRODUCT, ROMAN, ABS, CHAR, CODE Functions
1:26:30 – Text Functions
1:27:20 – UPPER, LOWER, PROPER Functions
1:30:00 – LEN, CONCAT, CONCATENATE Functions
1:33:57 – LEFT, MID, RIGHT Functions
1:36:35 – REPLACE, REPT, TRIM, FIND Functions
1:42:35 – MATCH Function
1:43:40 – TRANSPOSE Function
1:45:25 – INDEX, ROW, COLUMN Functions
1:49:15 – Number Functions
1:49:40 – CONVERT Function
1:50:47 – SEQUENCE Function
1:53:14 – MODE, MODE.MULT, MODE.SNGL Functions
1:55:17 – MOD Function
1:57:20 – MEDIAN Function
1:58:27 – ROUND, FLOOR, CEILING Functions
2:03:30 – CHOOSE, ADDRESS Functions & Cell Address Fixing
👍Like, 💬Comment, 📤Share, 🔔Subscribe: NaseebCodeStudio and Start learning NOW and MASTER🔥 IT / CS skills for Free💸!
🎯 Why This Course?
You’ll gain practical Excel skills used in data entry, analysis, office work, finance, and freelancing. The lessons are in Urdu/Hindi so you can easily follow along and implement from day one.
IT / CS SKILLS:
📌 • MS Word Complete Course | MS Word Full Cou...
📌 • Computer Basics For Beginners
📌 • 📊 MS Excel Full Course for Beginners
📌 • Virtual Box For Beginners
📌 • CMD Commands For Beginners
📌 • MS OFFICE For Beginners
🏷️🏷️🏷️🏷️🏷️🏷️
#NaseebCodeStudio #ncs #nk #skill #msExcel #excelCourse #excelTutorial #excelFunctions #excelFundamentals #excelForJobs #excelInUrdu #excelInHindi #dataEntrySkills #officeSkills #learnexcel #msexcel #excel #microsoft #excelcourse #msexcelcourse #completemsexcel #excelinurdu #excelinhindi #office #msoffice #exceltutorial #msexcelfullcourse
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: