Excel Mastery: Basics se Advanced Tak

Last Updated : March 13, 2024
42 Lessons
0 Enrolled

Course Prerequisite(s)

  • Please note that this course has the following prerequisites which must be completed before it can be accessed
  • Excel Course 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:

  1. 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.
  2. 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.
  3. 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. ๐ŸŒŸ

Show More

What Will You Learn?

  • In this course, you'll learn **Excel from basics to advanced**, including data management, financial analysis, and business intelligence. ๐Ÿ“Š๐ŸŒŸ

Course Content

Excel Mastery: Basics se Advanced Tak
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.

  • 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

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

โœ•