Microsoft Excel Training - Beginner to Expert Level in Hindi
- Description
- Curriculum
- FAQ
- Reviews
(माइक्रोसॉफ्ट एक्सेल को प्रभुत्व के लिए व्यापक कोर्स, जिसमें तार्किक कथन, उन्नत फंक्शन, डेटा स्वरूपण, VBA मैक्रो, और अन्य शामिल हैं।)
Welcome to the “Mastering Microsoft Excel” course! This comprehensive guide is designed to take you from a beginner level to an advanced user of Microsoft Excel. Throughout this course, you will learn a wide range of functions and features to enhance your data analysis, reporting, and presentation skills using Excel, including macros and VBA (Visual Basic for Applications) programming.
Module 1: Introduction to Excel
-
Understanding the Excel interface
-
Navigating workbooks and worksheets
-
Entering and formatting data
-
Basic formula writing and cell references
-
Managing workbooks and sheets
Module 2: Logical Statements and Basic Functions
-
Introduction to logical statements (IF, IF-ELSE, nested IF)
-
Utilizing logical functions for data analysis
-
The SUMIF function for conditional summing
-
The COUNTIF function for conditional counting
Module 3: Advanced Functions
-
Introduction to the “THEN” function
-
Utilizing advanced functions (e.g., SUMIFS, COUNTIFS)
-
Using the “IF” function in conjunction with other functions
-
Working with date and time functions (e.g., TODAY, NOW, DATE, TIME)
Module 4: Data Formatting and Protection
-
Conditional formatting to highlight data
-
Custom formatting for cells and data
-
Protecting files with passwords and permissions
-
Data protection techniques to prevent unwanted changes
Module 5: Data Organization and Management
-
Hiding and unhiding rows and columns
-
Sorting and filtering data for analysis
-
Organizing data using tables and named ranges
Module 6: Lookup and Reference Functions
-
Vertical Lookup (VLOOKUP) for finding data in tables
-
Horizontal Lookup (HLOOKUP) for finding data in tables
-
Utilizing INDEX and MATCH functions for dynamic lookups
Module 7: Macros and VBA Programming
-
Understanding macros and their benefits
-
Recording simple macros to automate tasks
-
Writing and editing macros using VBA code
-
Customizing macros to suit specific needs
-
12Functions In Excel part 1Video lesson
-
13Basic Conditional FormattingVideo lesson
-
14Condiforma Data BarsVideo lesson
-
15CondiForma Top Bottom RulesVideo lesson
-
16Condiforma Color ScalesVideo lesson
-
17Condiforma Icon SetsVideo lesson
-
18Worksheet ProtectionVideo lesson
-
19Data ProtectionVideo lesson
-
20Hide Rows_ColumnVideo lesson
-
21Unhide Rows And ColumnVideo lesson
-
22Insert Rows_ColumnsVideo lesson
-
23Delete Rows_ColumnsVideo lesson
-
24Sorting The DataVideo lesson
-
25Functions In Excel Part II IntroductionVideo lesson
-
26Flash FillVideo lesson
-
27Text to ColumnsVideo lesson
-
28Lower caseVideo lesson
-
29Proper CaseVideo lesson
-
30Spark lines ColumnsVideo lesson
-
31Page set upVideo lesson
-
32Data Validation 1Video lesson
-
33Data Validation 2Video lesson
-
34Data Validation 3Video lesson
-
35Data Validation 4Video lesson
-
36Consolidate 1Video lesson
-
37Consolidate 2Video lesson
-
38Consolidate 3Video lesson
-
39Choose FunctionVideo lesson
-
40Match FunctionVideo lesson
-
41Match Index Function 1Video lesson
-
42Match Index Function 2Video lesson
-
43Match Index Function 3Video lesson
-
51Pivot Table And ChartsVideo lesson
-
52Begineers Of PivotVideo lesson
-
53SlicersVideo lesson
-
54Complete Home TabVideo lesson
-
55Pivot ChartsVideo lesson
-
56Pivot Table Part 1Video lesson
-
57Pivot Table Part 2Video lesson
-
58Pivot Table Part 3Video lesson
-
59Pivot Table Part 4Video lesson
-
64Data HandlingVideo lesson
-
65ConcatenateVideo lesson
-
66Concatenate Text CasesVideo lesson
-
67DSUMVideo lesson
-
68Dmin_DmaxVideo lesson
-
69Dcount_DcountaVideo lesson
-
70Data Base Part 1Video lesson
-
71Data Base Part 2Video lesson
-
72Data Base Part 3Video lesson
-
73Data Base Part 4Video lesson
External Links May Contain Affiliate Links read more