Course Prerequisite(s)
- Please note that this course has the following prerequisites which must be completed before it can be accessed
- MS Excel Advanced Course
About Course
Kya aap Microsoft Excel ke saare gunaah ko khul kar istemaal karna chahte hain? Toh aap bilkul sahi jagah par hain! Hamara vistarik course, โExcel Mastery: Basics se Advanced Tak,โ aapko data management, financial analysis, business intelligence, aur administrative support mein un gunaahon se sajiv karega jo aapke liye zaroori hain.
Aap Kya Seekhenge:
- Excel ke Mool Siddhant:
- Excel ke interface, functions, aur mool data organization techniques ko samjhein.
- Basic formulas aur functions ko data manipulation ke liye master karein.
- Madhyamik Excel Techniques:
- Advanced functions aur tools ka upayog karke data analysis mein gehraai tak jayein.
- Pivot tables, time-saving formulas, aur data visualization ko explore karein.
- Excel ke Uchch Star ki Maharat:
- Complex dynamic formulas aur techniques seekhein.
- Apne critical thinking aur problem-solving skills ko sudhar karein.
Chahe aap student ho, professional ho, ya data analyst banne ki ichha rakhte ho, yeh course aapko Excel mein vishwaas se safar karne ki maharat pradaan karega. Abhi enroll karein aur apne spreadsheet skills ko uchch sthal tak pahunchayein! ๐๐
Note: Course content industry trends aur software enhancements ke adhar par updates aur improvements ke liye subject to change hai. ๐
Course Content
Excel Mastery: Basics se Advanced Tak
-
Basic Knowledge
43:08 -
Option Menu Explain
27:06 -
Option Menu Explain 2
30:37 -
Option Menu Explain 3
30:47 -
Home Menu Explain
21:23 -
Home Menu Explain 2
24:29 -
Home Menu Explain 3
15:48 -
Home Menu Explain 4
14:43 -
Home Menu Explain (Formate)
24:28 -
Home Menu Explain (Auto Sum, Fill, Clear, Sort & Filter, Find & Select)
22:54 -
How to Use Formula
25:34 -
Varient of Sum Formula
28:00 -
Question Answer Previous Classes
16:33 -
Shortcut Key Explain
26:58 -
Date & Time Formula
15:23 -
Date & Time Formula 2
19:34 -
Logical Formula
35:02 -
Question 1 With Answer Explain (how to use Right Formula)
30:56 -
How to Use Formula (ABS | LCM | FACT | MOD)
17:37 -
How to Use Formula (Combine | GCD | Ceiling & Floor )
23:09 -
How to Use Matrix Formula in Excel
05:37 -
Insert Menu Explain
30:01 -
Insert Tab Explain (Chart Option Use)
13:10 -
Insert Tab Explain (Text | Symbols)
21:47 -
Insert Tab Explain (Sparklines | Page Layout)
01:00:59 -
How to make Attendance Sheet in Excel
23:22 -
How to make Salary Attendance Sheet in Excel
30:59 -
How to Use Count Formula in Excel
11:18 -
How to Use Text Group Formula in Excel
20:09 -
How to Use Formula (Clean | Code)
21:49 -
How to Use Formula (Raw & Column | Fixed )
22:14 -
View Tab Explain
20:42 -
Review Tab & Pen Tab Explain
25:58 -
Data Tab Explain
26:30 -
Data Tab Explain 2
11:55 -
How to Use Formula (Cell | Info | Sheet & Sheets | Isnumber)
15:00 -
How to Use Formula (Iseven | Isodd | Istext | Islogical | NA | Iserr | Iserror | N)
22:24 -
How to Use Formula (Isnontext |Isblank | Error | Type | Isna)
15:32 -
How to Use Formula (Lookup)
14:40 -
How to Use Formula (Vlookup)
15:42 -
How to Use Formula (Hlookup)
06:55 -
How to Use Formula (Forecast & Xlookup)
17:27