Microsoft Excel Training - Beginner to Expert Level in Hindi
- Description
- Curriculum
- FAQ
- Reviews
This course has been updated to the latest Excel 2019 version topics. New topics has been added in such a manner that almost all the topics from 2010, 2013, 2016 and 2019 has been covered.
This is an Excel training program with an effort to put live practical experience in the form of videos. This course will teach you thoroughly on how to manage important tools in Excel and how to apply various functions with nested methodology. It is advisable that you must follow the structure pattern for better understanding.
What can be expected?
At the end of the course you will be able to handle data in excel, also will be able to apply text, logical, math, lookup & reference functions very easily. You will find it easy to manage organizing tools in Excel like charts, pivot table, filter, Conditional Formatting etc.
Who should do this?
If you work on Excel and found it difficult to apply advance functions and tools then this is must course for you. Candidate must have basic computer knowledge and should be aware of Excel environment.
Even though the course which is up right now will be sufficient but every week I will keep on adding more videos.
-
1Introduction to Excel - StructureVideo lesson
- Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
- Customizing Ribbons and options
-
2Equation in Excel - Operators basedVideo lesson
How to use operators in Excel to do equation
BODMAS in EXCEL
-
3Equation in Excel - Function basedVideo lesson
- How to apply functions
- SUM()
- AVERAGE()
- COUNT, COUNTA, COUNTBLANK
- MAX, MIN
- LARGE, SMALL
- Nested Function
-
4Data ValidationVideo lesson
- Data Validation Types
- Input Message
- Error Alert Customization
-
5Draw Tab in Excel - UpdatedVideo lesson
-
9Text Function 1 - IntroductionVideo lesson
- Introduction to Text Function
- UPPER()
- LOWER()
- PROPER()
- TRIM()
- Nesting TRIM with other Function
-
10Text Function 2 - LEFT, RIGHT & FIND FunctionVideo lesson
- LEFT()
- RIGHT()
- FIND()
-
11Text Function 3 - Nested FIND, LEFT & RIGHTVideo lesson
- Advance FIND()
- Nesting FIND with RIGHT() & LEFT()
-
12Text Function 4 - MID FunctionVideo lesson
- MID Function
- Nested MID
-
13Text Function 5 - ConcatenateVideo lesson
- CONCATENATE()
- Nesting CONCATENATE with other Text Function.
-
14Concat and Textjoin Function - UpdatedVideo lesson
-
15Text Function 6 - REPLACEVideo lesson
- REPLACE()
- Nested REPLACE()
-
16Text Function 7 - Substitute, Rept & LenVideo lesson
- SUBSTITUTE()
- REPT()
- LEN()
- Nested Function
-
17Numbervalue Function - UpdatedVideo lesson
The Excel NUMBERVALUE function converts a number in text format to numeric value, using specified decimal and group separators.
-
18Text to ColumnVideo lesson
- How to use Text to Column
- Delimited & Fixed Width
- Date Format through Text to Column
-
23IF Function - Logical Test & IntroductionVideo lesson
- Logical Test
- Introduction to If Function
-
24If Function - NestedVideo lesson
- Nested If Examples
-
25IFS Function - UpdatedVideo lesson
IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
-
26IF Function - AdvanceVideo lesson
Nesting IF() with other Functions to get desired output
-
27AND() & OR() FunctionVideo lesson
- AND() Function
- OR() Function
- Nested IF() with AND() & OR()
- Advance Examples
-
28Advance Math Function 1 - SUMIF, COUNTIF, AVERAGEIFVideo lesson
- SUMIF()
- COUNTIF()
- AVERAGEIF()
-
29Advance Math Function 2 - SUMIFS, COUNTIFS, AVERAGEIFSVideo lesson
- SUMIFS()
- COUNTIFS()
- AVERAGEIFS()
- Wild Card
-
30EMI Calculator - PMT FunctionVideo lesson
- How to create EMI Calculator
- Apply PMT() Function
-
31What if Analysis 1 - Data TableVideo lesson
- How to create data table
- How to format data table
-
32XOR Function - UpdatedVideo lesson
The XOR function returns a logical Exclusive Or of all arguments.
-
33What if Analysis 2 - Goal SeekVideo lesson
- How to apply Goal seek
- Get the desired output from complicated equation through Goal Seek
-
34What if Analysis 3 - Scenario ManagerVideo lesson
- How to Apply Scenario Manager
- How to merge Scenario
- how to get summary
-
35Pduration Function - UpdatedVideo lesson
PDURATION() Function helps the user calculate the time or the specific number of periods required for an investment made to reach a particular value
-
36Lookup & Reference 1 - VLOOKUP & HLOOKUPVideo lesson
- VLOOKUP()
- HLOOKUP()
-
37Lookup & Reference 2 - MATCH, INDEX, OFFSETVideo lesson
- MATCH()
- INDEX()
- Nesting both to get desired result
-
38Lookup & Reference 3 - OFFSETVideo lesson
- OFFSET()
- Nesting Offset and more example
-
39Lookup & Reference 4 - VLOOKUP TRUEVideo lesson
- How to use VLOOKUP() TRUE option
-
40Lookup & Reference 5 - LOOKUP()Video lesson
- LOOKUP()
- Drawbacks and how to apply it correctly
-
41Lookup & Reference 6 - Tricks 1Video lesson
- How to apply VLOOKUP() in all columns in a single go
- Array VLOOKUP()
- VLOOKUP() with IFERROR
- VLOOKUP with IF
-
42Lookup & Reference 7 - Tricks 2Video lesson
- Nested Lookup Function
- Advance Level Examples and problem solving
-
43Conditional Formatting 1Video lesson
How to apply conditional formatting
Types of Conditional Formatting
-
44Conditional Formatting 2 - CustomizeVideo lesson
- How to Manage Rules - Edit & Delete
- How to apply new Rules - Based on Formulas
-
45Conditional Formatting 3Video lesson
- Advance Customize options
-
46Chart Preparation 1 - IntroductionVideo lesson
- Start with Excel Chart
- Understanding Layout options
-
47Chart Preparation 2 - Format, Design, Axis & SeriesVideo lesson
- Chart Format
- Chart Design
- Handling Axis and Series
-
48Chart Preparation 3 - CustomizeVideo lesson
- Handling Data Series and Legends
- Customize options
-
49Power Map in Excel - UpdatedVideo lesson
Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways.
-
50Pivot Table 1 - Starts withVideo lesson
How to create Pivot Table
Managing Fields Properly in Field area
Managing Value setting
How to get detailed report
-
51Pivot Table 2 - Exploring Features & FunctionalityVideo lesson
- Managing Field List, Buttons & Field Headers
- Refresh Options
- Designing Pivot Table
- Pivot Table layout
- Changing Source Data
- Managing Slicer
- Pivot Chart
- Multiple Pivot Table
-
52Pivot Table 3 - AdvanceVideo lesson
- Handling Dates and Values through Group option
- Doing Calculation through Calculated field.
-
53Power Pivot in Excel - UpdatedVideo lesson
Practice Files are available in Resources
-
54Quick Analysis and Chart Recommendation - UpdatedVideo lesson
-
55Print Options 1 - Page LayoutVideo lesson
- How to set and customize margin
- page orientation and paper size
- Print Area & Page Break
- Set Image as a background
-
56Print Options 2- Advance OptionsVideo lesson
- How to Repeat heading on each page
- print pattern
- customize header and footer
- How to apply image like a watermark in Excel
-
57Protect WorkbookVideo lesson
- How to protect workbook
- how and when you may use this option
-
58Protect SheetVideo lesson
How to Protect sheet
How to allow cells for changes
-
59Protection Advance OptionsVideo lesson
- How to hide formulas
- How to customize protect related options
- Making workbook password protected
-
60Share WorkbookVideo lesson
- How to enable share workbook option
- how and when to use it

External Links May Contain Affiliate Links read more