How to create a Passport size photo in a simple and easy way in Hindi??
#Knowledgekidunia
#Onlineeducation
#AnkushGarg
This is default featured slide 1 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 2 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 3 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 4 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
This is default featured slide 5 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.
Monday, April 27, 2020
Vlookup in Excel | Vlookup IN HINDI | Data validation | Vlookup with Na...
How to Use Vlookup in Hindi? In this video, we will learn the advanced use of vlookup and learn it in a very simple and easy manner.
Vlookup is a lookup tool that brings the desired value out of any table on the principle of Indexing and invoking in excel.
Saturday, April 25, 2020
Voucher Entry in Tally (In Hindi) | Contra | Payment | Receipt | Journal...
Voucher Entry in Tally (In Hindi) | Contra | Payment | Receipt | Journal...
TALLY | TALLY EPR | TALLY WITH GST | BASIC OF ACCOUNTING | JOURNAL | LEDGER | VOUCHERS | INVOICE | POS | CONTRA | BUDGET | CREDIT NOTE | DEBIT NOTE | PAYROLL | REPORT |
#KNOWLEDGE #ANKUSH #LEARNING #EDUCATION #YOUTUBE #TALLY #GST #ONLINE #MBA #ACCOUNTING #INVOICING
Practice Entries:
1. Account Opened In SBI Bank With Cash Rs. 1000
2. Cash Deposited Into Bank Rs. 15500
3. Cash Withdrew From Bank Rs. 5000 For Office Use.
4. Deposited The Cheque Of Mr. A Kumar Into Bank Rs. 13640
5. Cheque Received From Ram Deposited Into Bank Rs. 4500
6. Paid Into The Bank Rs.12000
7. Cash Advanced To Petty Cashier or Cash Transfer To Petty Cashier
8. Paid Rent Rs. 10000
9. Paid Salary Rs. 5800
10. Paid Wages Rs. 1200
11. Paid Cash To Ankit Rs. 15060
12. Paid Cash To Shailesh Rs. 12000
13. Insurance Premium Paid Insured for Rs. 10000 @5%.
14. Paid As Clearing Charge Rs. 1350
15. M/S Kala Shree’s Order Was Complied With Freight Thereon Rs. 145
16. Amount Paid To Shree Ram Pvt. Ltd. By Cheque Rs. 23500
17. Paid Subscription Rs. 1200
18. Sundry Expenses Paid Rs. 100
19. Given Away As Charity In Cash Rs. 15000
1. Rent Received Rs. 10500
2. Rs.500 Interest Received From Canara Bank.
3. Salary Received Rs.45000
4. Commission Received Rs. 1650
5. Amount received From Ganesh Rs. 21560
6. Dividend Received Rs. 1500
7. Subscription Received Rs. 12000
8. Freight Received Rs. 10000
9. Cash Received Rs. 100000 from HCL Pvt. Ltd.
10. Cash Received Rs. 12000 as Bonus
11. Interest Received On Investment Rs. 1500
12. Paid By Ms. A. Sharma Rs. 25000
1. Started Business With Cash Rs. 200000
2. Furniture Purchased Rs.46800
3. Salary Paid Rs.45000
4. Commission Received Rs. 1650
5. Brought Goods For cash Rs. 5000
6. Sold goods to Sanjeev Rs. 15000 and Allow 5% cash discount.
7. Subscription Received Rs. 12000
8. Freight Received Rs. 10000
9. Cash Received Rs. 100000 from HCL Pvt. Ltd.
10. Cash Received Rs. 12000 as Bonus
11. Interest Received On Investment Rs. 1500
12. Paid By Ms. A. Sharma Rs. 25000
Wednesday, April 22, 2020
Tuesday, April 21, 2020
SGPA CALCULATION IN EXCEL IN HINDI | FUNCTION IN HINDI | Excel Tutorial...
Excel | Advance Excel | Excel VBA | Excel Chart | Excel Datasheet | Marksheet | GST Invoice | Bill | Payroll | Paysheet | Attendance Sheet | Pivot Reporting | Pivot Table | Graph | in Hindi
Home Menu in Hindi | Excel Functions (A-Z) | Ankush Garg | Knowledgekidunia | Knowledge Ki Dunia |
SGPA CALCULATION IN EXCEL IN HINDI
Sunday, April 19, 2020
SUMIF FUNCTION IN HINDI | Excel Tutorial in Hindi | Knowledgekidunia | A...
Excel | Advance Excel | Excel VBA | Excel Chart | Excel Datasheet | Marksheet | GST Invoice | Bill | Payroll | Paysheet | Attendance Sheet | Pivot Reporting | Pivot Table | Graph in Hindi | Home Menu in Hindi | Excel Functions (A-Z) | Ankush Garg | Knowledgekidunia | Knowledge Ki Dunia | #happylearning #knowledgekidunia #ankushgarg #hr #payroll #invoice #onlineeducation
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A/playlists https://www.youtube.com/watch?v=Aq8srSb4vmk&list=PLugxdEsjwo6aY0jgGKn1SLtS5OuheKhUa https://www.youtube.com/watch?v=sH_hQFUG0HE&list=PLugxdEsjwo6agzwH7bHZHte94upspkenu https://www.youtube.com/watch?v=IBijO2N3MzM&list=PLugxdEsjwo6abRtAjQvFLTDnqkJEyU47B https://www.youtube.com/watch?v=36gaJCMXmX8&list=PLugxdEsjwo6ZKsWgzV7lHlylW9Ljz5KnZ https://www.youtube.com/watch? v=eMwukJu7g6Q&list=PLugxdEsjwo6ZixuJt8TeCUYpjqJo-bbkb https://www.youtube.com/watch?v=-a_zZea9mk4&list=PLugxdEsjwo6aQ8cIVEjIOgRRCq7azBqQT https://www.youtube.com/watch?v=tGqhdSGdKNE&list=PLugxdEsjwo6beJgKGKAV6grcrmJRhFppH knowledge2020times.blogspot.com Thanks
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A/playlists https://www.youtube.com/watch?v=Aq8srSb4vmk&list=PLugxdEsjwo6aY0jgGKn1SLtS5OuheKhUa https://www.youtube.com/watch?v=sH_hQFUG0HE&list=PLugxdEsjwo6agzwH7bHZHte94upspkenu https://www.youtube.com/watch?v=IBijO2N3MzM&list=PLugxdEsjwo6abRtAjQvFLTDnqkJEyU47B https://www.youtube.com/watch?v=36gaJCMXmX8&list=PLugxdEsjwo6ZKsWgzV7lHlylW9Ljz5KnZ https://www.youtube.com/watch? v=eMwukJu7g6Q&list=PLugxdEsjwo6ZixuJt8TeCUYpjqJo-bbkb https://www.youtube.com/watch?v=-a_zZea9mk4&list=PLugxdEsjwo6aQ8cIVEjIOgRRCq7azBqQT https://www.youtube.com/watch?v=tGqhdSGdKNE&list=PLugxdEsjwo6beJgKGKAV6grcrmJRhFppH knowledge2020times.blogspot.com Thanks
Thursday, April 16, 2020
#2 Microsoft Word Tutorial | Ankush Garg | Knowledgekidhnia | Word Tutor...
Microsoft Word Tutorial | Ankush Garg | Knowledgekidhnia | Knowledge Ki Dunia | Word Tutorials in Hindi | Word 2007 | Word 2013 | Word 2016
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A/playlists
https://www.youtube.com/watch?v=Aq8srSb4vmk&list=PLugxdEsjwo6aY0jgGKn1SLtS5OuheKhUa
https://www.youtube.com/watch?v=sH_hQFUG0HE&list=PLugxdEsjwo6agzwH7bHZHte94upspkenu
https://www.youtube.com/watch?v=IBijO2N3MzM&list=PLugxdEsjwo6abRtAjQvFLTDnqkJEyU47B
https://www.youtube.com/watch?v=36gaJCMXmX8&list=PLugxdEsjwo6ZKsWgzV7lHlylW9Ljz5KnZ
https://www.youtube.com/watch?
v=eMwukJu7g6Q&list=PLugxdEsjwo6ZixuJt8TeCUYpjqJo-bbkb
https://www.youtube.com/watch?v=-a_zZea9mk4&list=PLugxdEsjwo6aQ8cIVEjIOgRRCq7azBqQT
https://www.youtube.com/watch?v=tGqhdSGdKNE&list=PLugxdEsjwo6beJgKGKAV6grcrmJRhFppH
knowledge2020times.blogspot.com
Microsoft Word Master Class in Hindi | Word Tutorial in Hindi | knowledg...
Microsoft Word Tutorial | Ankush Garg | Knowledgekidhnia | Knowledge Ki Dunia | Word Tutorials in Hindi | Word 2007 | Word 2013 | Word 2016
Wednesday, April 15, 2020
Home Part -3 in Excel in hindi | knowledgekidunia | Knowledge Ki Dunia ...
Excel | Advance Excel | Excel VBA | Excel Chart | Excel Datasheet | Marksheet | GST Invoice | Bill | Payroll | Paysheet | Attendance Sheet | Pivot Reporting | Pivot Table | Graph | in Hindi
Home Menu in Hindi | Excel Functions (A-Z) | Ankush Garg | Knowledgekidunia | Knowledge Ki Dunia |
clipboard cut copy paste format painter font style typeface design font size bold italic fill color border all border outside border alignment left center right top middle bottom text orientation merge cell merge and center text color colour Ankush Garg HTML CSS photoshop ms word PowerPoint access tags language India Bhubaneswar Bokaro MBA hr menu tab file save undo-redo
Learn Excel is an easy and simple way, a complete step by step learning through our channel and always share my knowledge continuously with all my friends and all.
A most powerful tool for documentation and help to level up your skill.
Accounting as well as Financial work we will learn here and different types of file and database preparation, the calculation in a simple and easy manner.
I hope you will learn from my channel and I will always try to solve your query related to the topic in every possible time.
excel tutorial youtube
advanced excel tutorial pdf
best excel tutorial
advanced excel tutorial youtube
ms excel tutorial point
excel tutorial intermediate to advanced
excel for beginners free
Microsoft excel basics for beginners pdf
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A/playlists
https://www.youtube.com/watch?v=Aq8srSb4vmk&list=PLugxdEsjwo6aY0jgGKn1SLtS5OuheKhUa
https://www.youtube.com/watch?v=sH_hQFUG0HE&list=PLugxdEsjwo6agzwH7bHZHte94upspkenu
https://www.youtube.com/watch?v=IBijO2N3MzM&list=PLugxdEsjwo6abRtAjQvFLTDnqkJEyU47B
https://www.youtube.com/watch?v=36gaJCMXmX8&list=PLugxdEsjwo6ZKsWgzV7lHlylW9Ljz5KnZ
https://www.youtube.com/watch?
v=eMwukJu7g6Q&list=PLugxdEsjwo6ZixuJt8TeCUYpjqJo-bbkb
https://www.youtube.com/watch?v=-a_zZea9mk4&list=PLugxdEsjwo6aQ8cIVEjIOgRRCq7azBqQT
https://www.youtube.com/watch?v=tGqhdSGdKNE&list=PLugxdEsjwo6beJgKGKAV6grcrmJRhFppH
knowledge2020times.blogspot.com
Thanks
Home Menu in Hindi | Excel Functions (A-Z) | Ankush Garg | Knowledgekidunia | Knowledge Ki Dunia |
clipboard cut copy paste format painter font style typeface design font size bold italic fill color border all border outside border alignment left center right top middle bottom text orientation merge cell merge and center text color colour Ankush Garg HTML CSS photoshop ms word PowerPoint access tags language India Bhubaneswar Bokaro MBA hr menu tab file save undo-redo
Learn Excel is an easy and simple way, a complete step by step learning through our channel and always share my knowledge continuously with all my friends and all.
A most powerful tool for documentation and help to level up your skill.
Accounting as well as Financial work we will learn here and different types of file and database preparation, the calculation in a simple and easy manner.
I hope you will learn from my channel and I will always try to solve your query related to the topic in every possible time.
excel tutorial youtube
advanced excel tutorial pdf
best excel tutorial
advanced excel tutorial youtube
ms excel tutorial point
excel tutorial intermediate to advanced
excel for beginners free
Microsoft excel basics for beginners pdf
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A
https://www.youtube.com/channel/UCxQTuzrnSamVov-tJT1r-6A/playlists
https://www.youtube.com/watch?v=Aq8srSb4vmk&list=PLugxdEsjwo6aY0jgGKn1SLtS5OuheKhUa
https://www.youtube.com/watch?v=sH_hQFUG0HE&list=PLugxdEsjwo6agzwH7bHZHte94upspkenu
https://www.youtube.com/watch?v=IBijO2N3MzM&list=PLugxdEsjwo6abRtAjQvFLTDnqkJEyU47B
https://www.youtube.com/watch?v=36gaJCMXmX8&list=PLugxdEsjwo6ZKsWgzV7lHlylW9Ljz5KnZ
https://www.youtube.com/watch?
v=eMwukJu7g6Q&list=PLugxdEsjwo6ZixuJt8TeCUYpjqJo-bbkb
https://www.youtube.com/watch?v=-a_zZea9mk4&list=PLugxdEsjwo6aQ8cIVEjIOgRRCq7azBqQT
https://www.youtube.com/watch?v=tGqhdSGdKNE&list=PLugxdEsjwo6beJgKGKAV6grcrmJRhFppH
knowledge2020times.blogspot.com
Thanks
Tuesday, April 14, 2020
Sunday, April 12, 2020
Friday, April 10, 2020
Excel_Tutorials: Free ✓!!!
It's Knowledge_Time......🙂🤝💻🖥️📱🔗🕙
This is all about to share my knowledge with you and I also wants that you also support me to provide a review through your genuine comments, like, share and subscribe my YouTube channel.
Plz comment me that will help me to know about your questions and problem related with all courses and video and I definitely provide the best solution to all the friends in very short period of time.
Introduction of Excel:
https://youtu.be/36gaJCMXmX8
Excel Interface (A to Z):
https://youtu.be/lv8liWTRz4Q
Customise Quick Access Toolbar:
https://youtu.be/CBcqIz3fka8
Setup of TallyERP9:
https://youtu.be/-a_zZea9mk4
Sales Invoice in Excel:
https://youtu.be/heDDbZQhs9o
Watch these and Subscribe.....like and comment
Thursday, April 9, 2020
Fundamentals of Tally.ERP 9
How to Set-up Tally ERP9: Free !!! Simple & Easy
Setup_tallyerp9 |
Steps:
Open any web browser Like Google Chrome, Mozilla, etc.
Then type download tally
Click on the link as showing below
↧↧↧↧↧↧↧
click on downlaod
your downloading will start
wait for few minutes as per your internet connection speed..
your setup is ready to install....
just double click on setup and click on install...
your installing will be starting...
just click on Done after msg (above)
your software is ready for you ::: Happy😀
if want to Quit or close just click on Quit or Press Ctrl + Q to Quit the tally...
I have a video for you guys to learn step by step how to download Tally ERP 9: Free
https://youtu.be/-a_zZea9mk4
https://youtu.be/-a_zZea9mk4
Introductions:
Tally.ERP 9 is the world's fastest and most powerful business Accounting and Inventory Management software. Tally.ERP 9, designed exclusively to meet the needs of small and medium businesses is a fully integrated, affordable and highly reliable software. Tally.ERP 9 is easy to buy, quick to install, and easy to learn and use. Tally.ERP 9 is designed to automate and integrate all your business operations, such as sales, Purchase, inventory, and manufacturing. With Tally.ERP 9, we can records accurate and up-to-date business information.
The powerful new features and high speed and power of Tally.ERP 9 combined with Accounting And Inventory Reports (Trial balance, P/L/ A/c, Balance Sheet, Stock Summary, etc.) which simplifies all your business processes easily.
Shortkeys of Tally ERP9
Shortkeys of Tally ERp9:
Alt+2: Duplicate Voucher |
Alt+A: Add voucher/To Alter the a column in the columnar report |
Alt+C: Create a master at a voucher screen, if it has not been already assigned a different function, as in reports like Balance Sheet. |
Alt+D: Delete a voucher To delete Accounting or Inventory master which is not used by any voucher or elsewhere in the alteration mode |
Alt+E : Export the report in ASCII, HTML OR XML format |
Alt+I: Import statutory masters |
Alt+H: Help Shortcut |
Alt+I: Insert a voucher/To toggle between Item and Accounting invoice |
Alt+N: To view the report in automatic columns, Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg |
Alt+P: Print the report |
Alt+R: Remove a line in a report |
Alt+Y: Register Tally |
Alt+F2: Maintain Date for Multiple Years by changing period on Gateway of Tally/Change of Period for Setting Period |
Alt+S: Bring back a line you removed using Alt+R |
Alt+U : Retrieve the last line which is deleted using Alt+R |
Alt+W : To view the Tally Web browser. |
Alt+O: To upload the report to the website |
Alt+M: Email the report |
Alt+F1: Close a Company (At All Menu Screens). View detailed Report (Report Screens). Explore a line into its details (At Almost all Screens) |
Alt+F3: Select the company info menu (At Gateway of Tally Screen). Create/alter/shut a company (At Gateway of Tally Screen) |
Alt+F5: View sales and purchase register summary every quarter |
Alt+F12 : View the filters screen where the range of information can be specified |
Alt+X: Cancel a voucher in Day Book/List of Vouchers |
Alt+R: Recalls the last narration saved for the first ledger in the voucher, irrespective of the voucher type |
Alt+D: Delete any voucher in Deere the range of information can be specified |
Alt+Z: Zoom |
Tally ERP 9, Shortcuts with “Function” Button |
F10: Navigate between Accounting Reports |
F11: Modify Company features specific to the current company only |
F12: Master Configurations, which will affect all companies in the same data directory. |
F2: Change the date |
F6: Select Receipt Voucher |
F7: Select Journal Voucher |
F8: Select Sales Voucher |
F9: Select Purchase Voucher |
F4: Contra Voucher (All voucher creation and alteration screens). View list of Groups (Reports groups summary, group voucher screen, cash/ bank summary) |
F5: Select Payment Voucher. Switch between Grouped and Ledger-wise Display |
Tally ERP 9, Shortcuts with “Ctrl” Button |
Ctrl+R: Repeat narration in the same voucher type irrespective of Ledger Account |
Ctrl+T: Mark any voucher as Post Dated Voucher Ctrl+N: Switches to Calculator/ODBC Section of Tally Screen |
Ctrl+Q: Abandon a form–wherever you use this key combination, it quits that screen without making any changes to it. |
Ctrl+M: Switches to Main Area of Tally Screen |
Ctrl+A: Accept a form–wherever you use this key combination, that screen or report gets accepted as it is. |
Ctrl+G: Select Group |
Ctrl+L: Mark a voucher as Optional or Regular |
Ctrl+F9 : Select Debit Note Voucher |
Ctrl+Alt+V : To paste the text from Tally (At creation and alternation screens) |
Ctrl+Alt+R : Rewrite data for a Company |
Ctrl+Alt+B : Check the Company Statutory details |
Ctrl+Alt+C : Copy the text from Tally (At creation and alternation screens) |
Ctrl+Alt+c : for copy |
Ctrl+Alt+v : for paste |
Shift+Enter : To view the next level of details and/or condense the next level of details |
Tally ERP 9, Shortcuts in use of “Inventory Vouchers” |
Alt+F4: Purchase Order Voucher |
Alt+F10 : Physical Stock |
Alt+F5: Sales Order Voucher |
Alt+F7: Stock Journal / Manufacturing Journal |
Alt+F8: Delivery Note |
Alt+F9: Receipt Note |
Esc: Clear entry |
Ctrl+F6 : Rejection In |
x
x