Complete Microsoft Excel Tutorial In Hindi | MS Excel A to Z Full Course Video for Beginners Student
HTML-код
- Опубликовано: 3 окт 2024
- VLOOKUP video link 13:03:32 to 13:18:25 voice issue correction
• How to Use Vlookup For...
MS Excel A to Z Full Course, Step by step Video for Beginners Students to old Users. You will Learn About MS Excel Basic to Advance Level MS Excel which CA, MBA and other Industrialist are using.
This is excel full course for students who are searching for Excel full course in hindi |
Complete ms excel tutorial in hindi | excel tutorial for beginners | Complete Microsoft Excel Tutorial In Hindi | MS Excel A to Z Full Course Video for Beginners Student
Many students does face for Interview question answer. So in this video you will prepare for Interview question answer also.
In this video we will learn basic to Advance Excel. We will cover topics like :
Vookup, Hlookup, Scenario management, Pivot Table, Validation, Macro, Forms, Filters, Adv-Filter, Paste Special, Conditional Formats, Styles, Many Formulas, Freeze, Goal Seek, Many Short, commands, Adv. Page setup, Work List, Advanced Attendance, Mark sheet, Loan, Interest Calculation, Inventory, EMI Calculator, Exam Records, etc.
To Get Your Free Certificate Click on the Below link
• Get Free Certificate ...
Get Your Free Ms Word Course Click on the Below link
• MS Word Tutorial In Hi...
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 VLOOKUP
13:18:36 Hookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
#excelforbeginners #excelbasictoadvance #interviewquestionanswer #vlookup #hlookup #senario #pivottable #MisReport #marksheetcreation #pastespecial #advpagesetup #inventory #EMIcalculator #examrecord #formCreation #macro #filteradvancefilter #conditionalformates #goalseek #shortcommands #attendancesheet #Loaninterestcalculation #examrecords #msexcelfullcourse
![OsamaSon - ik what you did last summer [Official Music Video]](http://i.ytimg.com/vi/4DIQDnu3mr4/mqdefault.jpg)
Today I completed whole 16 hours of course
And I would say that the course taught by faculty is just phenomenal
Each and every topic is covered
Totally worth it
Best MS Excel course in RUclips
Aapko certificate mile gaya plz must reply me
And it's useful in job or not
@@karishmakushwah2989 see bro
I complete this course for knowledge and skills
Ya they do provide certificate
But I am not interested in certificate
So I have not applied for the same
And if I talk about job
You have to apply for MS Excel job by yourself
They don't have placement assistance
They provide knowledge which matters most
@@shaileshpandey2539 tnx for informing me . I'm interested in ms Excel & it's also helpful in accounting and auditing etc. That's why I ask u about this tnx again.
Sir aapko ye course complete krne mai kitna time lga?
I am feeling like ,i became master in Excel after this course . thank-you very much for this course to ur team .double thanks.❤️
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 Vlookup
13:18:36 Hlookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
Bauth acha kaam kiye ho bhai thank you 👍🏻... bauth mehnat kiye hai aap 👌🏻👌🏻
Lovely...👍
Superb 👍👍
Thank you for making our learning easy
Thank u soo much bhai....❤️
Best video to learn excel who don't know about ms excel
point to point explanation in details about every single formula and every single function.
Thanks for liking
This video is mind blowing .aapka teaching ka tareeka bahut bahut good hai maine pura cource complete kar liya hai aur ab mujhe lagta hai ki mai bhi. Excel me expert ban gya hu jay ho anil computer.
Aap se request hai ki MIS REPORT KO AUR JYADA SE EXPLAIN KARKE VIDEO BANAYE KISI COMPANY ME INTERVIEW KE PURPOSE SE VIDEO BANAYE BAHUT HELP HOGI
Provided in depth knowledge about the topics. Shown most of the topics practically which help in visualizing the topic. Providing training video is a plus. thanks you so much sir.
Thanks a ton
Fully explained little little things , today I completed my course of excel which was of 16 hours . Great team work and must say best excel course for who wants to learn excel. Thanks to your Team. lots of love. ♥
Thanks
Bro kitna time laga seekhne me
मस्त एकदम जीरो से हीरो
आपके पुरे टीम को बहुत बहुत धन्यवाद।।।।
🙏💐👍 Thanks for the appreciation
I recently got certificate of Advanced Excel from Anil Computers Thankyou so much for all your efforts and facilitating students with free and valuable content❣️❣️❣️❣️
I got the certificate of advance excel, thank you sir.
Your explaining easily understandable,
Videos are free,
And certificate is also free
Thanks please share this video to your friends also
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 Vlookup
13:18:36 Hlookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
🙂🙂🙂🙂🙂
Well done
Bade tez ho bhai description mein se copy krke wah wahi loot rhe ho😁😝
Thanks bhai sir ne miss ker deya ta
Uploading this video convey your love towards spreading education. It is a big gift for student who want to learn excel. Hats off to your decision of uploading this great video.
Thank you
Aap kya kahana chahte hai hum log samaj nahi pai
Kya hum acha work kat rahe hai
Please guide us
We are always waiting for your positive response
Thank you 🙏💐👍💐
@@anilcomputers-bestcomputer9973
Actually me aaplog bahot achha kam kar rhe h...
Itna important educational video free me dena ek bade soch wale hi kar skte h... Isko banane me ofcourse aapko bahot samay and mehnat laga hoga...
Aapke soch ko salam.
Thank you
First of all Salute you Sir to very well explained with details 🙏 people like you are real Gem 💎of our great country india🇮🇳 Thank you sooooo much Sir.
Sabse Accha teaching skill beginning level to master hats off to u mam .keep rocking 🙏❤️ I am giving the daily 2 hourse time in our smart TV it is so helpful it means it takes me to learn almost 2 week after this course I don't have to learn anything know mam is it enough.
what a phenomenal video by anil computers
aise samjhaya jaise koi school ke teachers ho from basic to advance totally worth it
good luck
Great my dear❤️. Aap log ki wajah se hamara desh aage badega insha'Allah ❤️
Yes you are right 😊
Thanks a lot Priyanka ji
@@anilcomputers-bestcomputer9973 😊😊
Sir. Mujhe ye jaanna thaa ki hum ye video se saara excel seek to jaynge na ..
Yes, Priyanka ji
Very usefull this video.
Thanks to all of you 🙏🎉
VERY NICE TEACHING. JUST HAVE SOME SUGGESTIONS
1. Please include intro to each session while mixing all small videos.
2. keep good quality of audio while recording. In some parts we can't get the audio properly.
The lady in the video taught so well, and Thank you so much I got my certificate!
I WATCH MANY TUTORIAL VIDEOS. I LIKE THAT BUT YOUR TUTORIAL VIDEO IS THE BEST FOR LEARNING BECAUSE YOU TAUGHT WITH DETAIL. EVERY ONE SHOULD TAKE THIS LECTURE.
Thanks a lot to like us
अदभुत अविश्वनीय 🔥🔥🔥🔥
I have completed my 16hrs today, and I have no words to explain how I am Excited And Happy after Learning Almost everything in Ms-Excel
Thank you so much...
Anil Computers
Watched whole series .....now I want certificate so pls give information and process to apply....cost also .. the way mam teach is very simple and understanding..tysm mam❤️👍
whatsapp on 94142 34600
Bahut badiya sister Mene Pura video Dekh liya aur samaj liya dhanyabaad
Thank you
Thank you so much for providing free course on RUclips. Teaching is also best. Thank you for providing free certificate. I got my certificate today.
Thank you Abhijeet ji
Thank you for the effort . It was worth spending time on your channel. Keep uploading such valuable content 💜
Thanks a lot
Thank you very much for this video.
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 Vlookup
13:18:36 Hlookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
thanks brother
Thanx bro
Nice
Bade tez ho bhai description mein se copy krke wah wahi loot rhe ho😁😝
ok
Really very very thank you so much I am so happy to watch this video because it's very very helpful full teaching like a paid course thank so much... 🤗😊🙏🙏
Lots of content in single video .very very thanks mams
Such a great video with patience 😃
Thanks Anil Computer🙏It's a complete package of excel but it would be more helpful if you add that comment where all the contents are mentioned with time ...which was in that last video..that is very very essential. ..,thank you😊
I m also looking for that
Please provide the spreadsheets through links so that we can practice the concepts on it. Thank you for the course. Highly appreciated.
This will provide in paid courses
399/- only with many more
94142 34600 par whatsapp kijiyega for details
Msg i m interested in paid online course
thanku so much sir & mam for making this knowledgeable & helpful video 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼✔️✔️✔️✔️✔️✔️
Got the Certificate within 1 day of test completion. Thanks a lot sir ji
how we will get certificate..PLEASE TELL
anilcomputersudaipur.com/free-certificate/
@@anilcomputers-bestcomputer9973 TQ SIR
I want to lean excel then I search it but I just can't believe all I need is in one video.... Great work 👍
Thank you so much sir 😄
Thanks for the appreciation 💐
Isse future mai help hogi part time job ke liye
@@maheshrawat1030 ys
thank you so much mam and all of your team
very useful video
jai hind
jai maa bharati
Thank you for your comments 🙏
Thank u so much.
Thanks you so much for providing me such a great ms advanced Excel certificate without any cost..🙏🙏🙏
Watch mis report full video also
That will be beneficial
Thanku so much mam 👌👌
Full knowledge full video A too z Excell knowledge .only one video 👌👌👍👍👍👍
Thank you soo much for your valuable effort sir and ma'am. This video is wonderful and up to the mark. Thank you so much.
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 Vlookup
13:18:36 Hlookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
good work
thnk u so much
Bhaiyo issne description se copy paste kiya h
Thank you Vinayak ji
Time Stamp
02:40 Introduction.
15:54 How to insert Row & Column.
22:39 How to delete Row & Column.
26:22 How to change width & height of row & column.
33:48 Hide or Unhide Row & Column.
38:13 Group or Ungroup Row & Column
44:11 Autofill
53:23 Sheet Option
1:05:04 Text Alignment
1:09:12 Text Angle
1:14:42 Wrap Text
1:16:41 Excel Bullets
1:18:25 How To Select Blank Cell
1:19:33 Merge & Center
1:29:51 Border
1:36:23 Find & Replace
1:42:25 Page Setup
2:04:06 Watermark
2:09:50 Quick Access Toolbar
2:16:24 Format Painter
2:20:44 Mini Toolbar
2:24:40 Format As Table
2:32:11 Status Bar
2:39:06 How to Use Cut, Copy & Paste
2:46:33 Paste Special
2:57:46 Undo Redo Function
3:02:43 Header Footer
3:15:28 Number Block
3:26:24 Change Case
3:34:11 Protect Sheet
3:39:55 Lock Cell
3:41:49 Excel file password
3:44:36 PDF
3:46:52 New Window
3:58:03 Sort And Filter
4:06:08 Custom Sort
4:28:46 Hyperlink
4:32:35 Spelling & Grammar
4:37:24 Comment
4:44:01 Chart Part 1
4:58:37 Chart Part 2
5:13:05 Sparkline
5:21:22 Autosum
5:26:50 Product Video
5:32:38 Subtotal
5:36:14 Sum product
5:39:08 Array
5:43:26 Average
5:46:10 Average if
5:50:41 Deaverage Formula
5:55:09 Dget
6:00:36 Min & Max
6:05:40 Dmax & Dmin
6:12:45 Today
6:16:14 Edate
6:20:29 Now formula
6:22:21 Count, Countam Countblank
6:24:54 Countif, countifs
6:34:56 Dcount
6:40:04 Attendance Sheet
6:51:43 Even Odd
7:00:57 Iseven , Isodd
7:07:07 Round
7:17:15 And
7:21:30 Or
7:24:43 Fact
7:27:50 Discount
7:37:56 Due, Advance
7:43:08 Percentage
7:52:54 Percentage Pass or Fail
7:58:07 Nested If Formula
8:06:18 Marksheet
8:23:29 Frequency
8:28:17 New Tab
8:37:07 Create a New Template
8:41:42 Left Right Formula
8:45:17 Mid Function
8:49:32 Find Function
8:57:29 Search
9:03:02 Replace
9:08:14 Substitute
9:13:57 Char Function
9:15:51 Code
9:18:35 Clear
9:23:31 Rept
9:27:10 INT
9:28:47 Exact
9:32:15 Roman
9:35:50 Trim
9:37:21 ABS
9:40:18 Dollar
9:43:12 Text To Column
9:48:51 Concatenate
9:53:26 Simple Interest
9:58:50 Compound Interest
10:06:25 Data Table
10:11:51 Comma Style
10:17:28 Rand And Rand Between
10:23:46 How to remove Zero In Table
10:26:19 Goal Seek
10:29:31 Celling and Floor
10:36:41 Forecast
10:40:40 Sqrt Formula
10:43:00 Cube Root
10:48:45 Istext, isnontext
10:58:03 Large Video
10:55:58 Small Formula
10:59:19 Is Blanks
11:01:37 DB Formula
11:08:55 Pivot Table
11:14:18 Pivot Chart
11:20:21 MIS
11:36:04 Conditional Formatting Part 1
11:49:18 Conditional Formatting Part2
12:07:13 Advance Conditional Formatting
12:19:27 Macro's
12:29:03 Age Calculator
12:33:18 PMT Video
12:39:29 Rate Formula
12:42:24 NPER
12:44:31 PV
12:46:50 Future Value
12:52:17 Scenario
12:58:59 GCD
13:03:26 LCM
13:05:09 Vlookup
13:18:36 Hlookup
13:28:34 Lookup Formula
13:36:56 Calculation
13:43:13 Formula Auditing
13:54:10 Data Validation Whole Number, List, Text Length
14:07:03 Data Validation Custom Part 2
14:12:42 Data Validation Part 3
14:19:08 Data Validation Date & Time
14:26:45 Data Validation Decimal
14:31:16 Index
14:34:50 Index With Match
14:42:33 Indirect Formula
14:48:58 Consolidate
14:54:37 Print of Excel
15:08:03 Error in Excel Part 1
15:16:09 iferror Function
15:24:13 Bill Format
15:33:04 Salary Slip
15:37:11 Absolute Cell Reference
15:14:43 Mix Cell Reference
15:48:28 Excel Font
15:55:38 Excel Setting Part1
16:05:17 Excel Setting Part2
16:12:29 Excel Setting Part 3
Ms office Mai time stamp dalne par appreciation certificate scheme bhi hai
Link ke liye 94142 34600 par whasapp kijiyega
Thanks sir please don't delete this educational video I am watching every day
Thank you for watching our videos regularly 🙏
It's the best video I have ever seen! One day it will cross 1 crore view.
Mam iam very glad for this video useful
great explation loved it 👍🏻👍🏻👌🏻👌🏻
Superb...I wanted to learn excel suddenly I came across this channel and not only i have learnt but also got certificate absolutely free.... Thank you so much...😊
Thank u Vishal ji 👍💐
Apko free certificate kaise mila..please reply...vishal sir...bcz i also want to apply
@@sumansaini5850 hey.. Suman... Please dont call me sir... Please see the video that link has been given in description. About how to get free certificate.
@@anilcomputers-bestcomputer9973 sir can you give me your number
Sir keyboard to dikha diya karo esy samjh nhi ata konsa key press kar rhe hai ap
Jitni tarif karo utni kam hai..is video ki
Anil computers..really appreciable work..unke liye bhut helpful video hai..jo..course ka karcha..nhi utha sakte...sat sat naman
Sir ye cousre complete karne k bad..MS excel ka course certificate..apke institute se kaise mil sakta hai..please reply soon..i want..MS excel..certificate...taki job k liye apply kar saku..aur apke reputated institute se mil jaye to...balle balle hai
Thank you Suman ji ,
Nice video I am watching this video every thing is fit and fine.thankyou
Awesome🔥 great help for learners🙏
Great work by the entire team...a very helpful and easy learning course. The teachings were like it's a paid course. Thank you soo much to all and lots of love ❤️
Bro if we pay also we won't get the tachings in detail I'm telling you. Ek din theory ek din practicall hotha hai magar practicall mein trach karney wala koe nahee rehta.
Any ways this is a goo course
Good course
22:34
Thanx😊
bik gayi ye gormit. sala apna admi hi comment mai tarif karta hai
Great work by the entire team...a very helpful and easy learning course. The teachings were like it's a paid course. Thank you soo much to all and lots of love .. THANK YOU SIR
I love Anil computer bcz this Excel complete video provide with zero fee on utube.... 🙏❤️
Thank you from heart
please share this video to friends and relatives also
Sister, thank you so much for your best system of excel teaching I am very eager to learn complete excel .But I do not understand clearly. It becomes difficult on my part to grasp all the thing properly. I have tried very often to learn the excel completely .But the style of teaching is not worth convincing. Request to teach in a great visible way which would be easy to understand. I thing your teaching will be easy to understand. May god bless you and save you from dangers. All the best. Sirrah and family. Odisha.
Sir Tally ERP 9 with GST ka vedio upload kijiye please sir.
Thank you so much for this video. I really appreciate your efforts. I have a request if you could make it... It would of great help. Kindly include the pdf notes or the screenshots of the database as notes.
Thank you
Mam Email Address please Send kare
94142 34600 par whatsapp kijiyega
Its a nice video, and have everything about excel in this video. I have learnt many thing from this video
Thank you 🙏💐
Best course till now😊
Thank you sister. God bless you. Excellent teaching.
Thanks a lot
to support us Suresh Ji
Thank you so much for this
Thank you MAM, JAI HIND..🙏🙏
Jai hind 🙏
PAKISTAN ZINDABAD I BELIEVE THAT ALLAH IS GOD AND HAZRAT MUHAMMAD S.A.W IS THE LAST PROPHET OF ALLAH
@@hassanriaz6276 my brother ALLAH, JESUS, ISHWAR sab ek hi hai, colour of your blood is red,my colour of blood is also red...tumhara mera god ek hi hai,sirf zuban,dharm,liwaz,desh, halat ,mentality,enviorment alag alag hai,ye sab GOD ne create nehi kiya hai,hum insano kiya hai,so kon zinbadad kon murdabad ye mudda nehi hai, sab desh zindabad hai,hum sab zindabad hai mere bhai....love from hindustan.....HUMANITY ZINDABAD...🙏🙏🙏🙏
👌🙏
@@kgverse9767 ALLAH aik hai us ko koi hamsar nahi woh waahid hai la shareek hai aur jahaan tak baat hai kay ue sab allah nai nahi balkay insaanon nay banaya hai meray bhai allah ki marzi kay baghair pata bhi nahi hil sakta inshallah aik waqt aaye gha puri dunya main har ghar main har ghali main MUHAMMAD IBNE ABDULLAH S.A.W kay deen ko ghalba haasil ho gha
Sir it's really amazing video but could you please make confirm like is it basic excel or basic + advance both?
Respected mam.. You are excellent.. Be blessed🙏🙏🙏🙏
Most appreciable work done by you see thanks Giving such amazing video, with easy and understable language thank you so much.....
Thank you for your comments
I learnt from your video, it's amazing. Thank you so very much Sir🙏🙏🙏
Thanks for the comments 🙏
You are doing a great Job. Can you please share excel data set for better understanding & practice.
Wow wow wow i'll be always thankfull to uh mam mujhe excel sikhnaa thaa bt source nhi mil rha tha bt aapkii vjh se yeah possible huaaa tqqq tqqq tqqq tqqq very much ❤🙏😍
Umm today on 12th Nov 2021 I'm starting this course let's see how much time I gonna take :) lessssshh gooooo ,will edit it back when I'm done with this lecture 🙂
Certificate kaise milega? Koi exam Dena hoga?
Exam Dena hoga
Atishundar video ise kafi labh liya jasakta h dhanyabad sir
Mam and sir thank you so much my joining for was required excel course I was unable for pay but when I see your your video it's to helpfully
I want video of tally please prefered it .
Thank you so much
Thank you Poonam ji
Mam, people like you are the pride of our country ❤️
Sir thanku for uploading this video is very helpful.. 👍 one of the best method to teach👍
thank you so much......!! its amazing .
सर आप बहुत अच्छा काम कर रहे हो🙏🙏
Thank you Rahul Ji
Vividly explained everything. A lot of thanks.
Thanks for your comments 🙏💐
Got my excel certificate thank you very much sir great work, This video is very useful and after completing quizzes you will get your certificate absolutely free.
Thanks for the comments
Deepak ji 🙏💐👍💐
94142 34600 par whatsapp kijiyega
bro where are the quizzes organized how can i get certificate can you please guide
That's great video sir because you have taught the whole excel in just one video but their are many more youtubers would not do that because they can earn more views by making so many videos but you didn't think for views that's great sir ❤️
So nice of you
Thank you very much really very hard working.Again video mis full Course please reply me
Bohot hi achcha hai 😊
Sir thanks alot for this, I am just starting, From where can we download this working sheet?
Microsoft office bro
As I Completed my MS Excel Course from this Video I got Certificate from Anil Computers. I must say thanks for providing us better Courses at free of Cost. Thank You.😊
We need to give any exam?? Is it paid or free one??
Give exam
100% free hai
@@anilcomputers-bestcomputer9973 thankyou so much
How I get certificate??
Brother does it cover all aspects of advance too
Awesome. Masterpiece. Thank you very much
Thanks for giving so much knowledge for free of cost thanks mam and channel
Thanks
Is the best platform to learn computer courses without any cost. It gives vast information related to course and also enhance my knowledge too. It is the high-level learning institute. They teach in very easy and simple way that's why anyone can understand without any inconvenience. It is the best ever computer institute. The faculties of this institute is very helpful , supportive and very co-operative. responses is very quick. Thank you so much for your support sir I have received C and C++ sir very nice sir.
Thank you Vaishali ji
N
Yeah really
Hiiu
Apne liye perfect job paane ke liye Apna app download kare.
I have very very Impressed with this channel " Anil Computers ". On home without any cost We study the full Course of excel Thanks sir and mam .📕 to 👦
Thanks a lot Madam and anil computers for your efforts I completed my advance excel course today ... I feel very confident working in excel with your advance training ... You are very good trainer... Thank a lot again 🙏🙏🙏🙏🙏 🥺
Thank you sir ☺️ for Computer certificate without any cost❤️...
Most welcome
ধন্যবাদ মহাশয় 🙏🏼
Ma'am you r a brilliant teach, thanks for this institution 🙏
I wanted to learn excel then I searched in RUclips Anil computer class and join I am so happy that a lot of topics learnd by this class.
I am very grateful to you and your all teacher.
I am Avinash from Mumbai
Working in motilal Oswal🙏🙏🙏
Thanks for the comments
You can get 100% free certificate also after giving exam
For process whatsapp on
94142 34600
Good Attempt by team, just make one correction
At 04:16 four hour sixteen minutes, Topic is Custom Sort Option - Audio is missing, please upload once again this portion only. Today I am going to complete full tutorial, morning 05:00 am I have started.
Thanks
ऑडियो मिसिंग है उसे आप अलग वीडियो में देख सकते हैं क्योंकि 16 घंटे के वीडियो में कुछ तो होता ही कुछ गड़बड़ रह जाता है वीडियो रेंडर करते समय बहुत प्रॉब्लम होता है हम दो बार ऑलरेडी लांच कर चुके हैं
@@anilcomputers-bestcomputer9973 I really appreciate the paid you have taken to make such a fantastic
Knowledge sharing video...keep it up and I have told many of my friends to watch this to learn Excel within 3 days
Thanks
🙏👌👍
But sir app waha pe comments daal dete jaise aajkal Hindi movie mai hoti hai
Thankyou mam I'm from kerala
Thank you so much sir ji
Finally after 7 days i have completed this course......what an awesome lecture.....
Thanks to mam and anil computers
Did u got your certificate?
@@danieldexter5592 i don't want certificate i learned excel for my business not for job
There is no harm to take certificate
The tests will give you confidence that how much you really understand the excel
It's my personal suggestion that you should give the test either you take certificate or not
Thank you
And I have one request also please share this video to friends and relatives groups
Thank you again 🙏
@@anilcomputers-bestcomputer9973 sir i had already shared this precious video with my friends ......this video will surely help them.....
Thankyou
@@aryaman4068 can i watch this video? Bcz i am very beginner.
Want to learn from basic.
Sir this vedio is very usefull to us thank you very much sir
U all r doing great
Keep it up 👍👍
Very nice course, learning with simple and easy language..
Thanks for appreciation
All topy marathan layeye sir
Thanks sir really helpful
Bahut sunder class hai sir ji❤👍🙏