![Training by Himanshu](/img/default-banner.jpg)
- Видео 107
- Просмотров 601 000
Training by Himanshu
Индия
Добавлен 25 дек 2015
Learn MIS related courses, ranging from MS Excel, MS Word and macros etc. Subscribe to our channel for latest tips and tricks.
Mastering Google Calendar Tasks and Reminders: A Comprehensive Guide
Unlock the full potential of Google Calendar with our in-depth tutorial on utilizing tasks and reminders effectively. In this 8-minute video, we walk you through the ins and outs of managing your schedule with Google Calendar's powerful task and reminder features. Whether you're a seasoned user or just getting started, this tutorial covers everything you need to know about organizing your life seamlessly with Google Calendar tasks and reminders. Streamline your productivity and stay on top of your commitments with this essential guide. Don't miss out-watch now! #googlecalendar #TasksAndReminders #productivitytips
Просмотров: 103
Видео
IFS Formula in Excel in Hindi - Now no need for Nested IF Formulas
Просмотров 376Год назад
With the introduction of IFS Formula in Excel it has made the life of the users very easy. The complicated Nested IF Formula is no more required. However its available in the latest version only.
How to use Power Map tool in MS Excel for interactive data visualization
Просмотров 845Год назад
Unlock the Power of Data Visualization with Power Map in MS Excel In today's data-driven world, the ability to transform raw information into compelling visualizations is essential. Microsoft Excel, a widely used spreadsheet program, offers a powerful tool called Power Map that allows users to create stunning visual representations of data on interactive maps. With its intuitive interface and r...
How to Delete This is No Longer located Files for Error "Verify the items location and try again."
Просмотров 18 тыс.2 года назад
If you get the error "Could not find this item. This is no longer located in (path). Verify the items location and try again" when attempting delete a folder on a Windows computer. This might help solve that problem, it worked for me. Here is the command prompt. in prompt type rd /s "\\?\
Excel Charts and graphs learn the basics for a quick start | Dynamic Chart in Excel
Просмотров 1794 года назад
#chartinexcel #chart #dynamicchart This is a detailed training to create chart in excel and also create a dynamic chart. 0:00 Getting Started with Chart 13:10 Format Option in Chart 17:20 Customize Options in Chart
Converting unorganized Row data into Column data | Magic of filter solution
Просмотров 7 тыс.4 года назад
#filterinexcel
Self Learning of excel || Best way to learn Excel by yourself
Просмотров 2734 года назад
#learnexcel #selflearningexcel Here is the playlist to learn Excel. ruclips.net/p/PLTapRnxwDnt1bpBo4fNR_pQuBmQL01zhq
Define Name in Excel || रेंज को नाम देना और इसके फायदे
Просмотров 1284 года назад
#definename #definenameinexcel
Data Validation in Excel in Hindi - Complete explanation
Просмотров 2084 года назад
#datavalidation setting up a workbook for your users, you may often want to control information input into specific cells to make sure all data entries are accurate and consistent. Among other things, you may want to allow only particular data type such as numbers or dates in a cell, or limit numbers to a certain range and text to a given length. You may even want to provide a predefined list o...
Match Index and Offset Function in Excel || Vlookup से भी ज्यादा काम का function
Просмотров 2,2 тыс.4 года назад
Match Index and Offset Function in Excel || Vlookup से भी ज्यादा काम का function
Conditional formatting in Excel || Excel में data को सुन्दर तरीके से सजाना सीखिए
Просмотров 2584 года назад
Conditional formatting in Excel || Excel में data को सुन्दर तरीके से सजाना सीखिए
Chart in Excel || इस वीडियो से आधे घंटे में Chart एंड Graph बनाने में Expert बने
Просмотров 1064 года назад
Chart in Excel || इस वीडियो से आधे घंटे में Chart एंड Graph बनाने में Expert बने
Pivot Table Complete Training Part 2 || Excel में नौकरी के लिए सबसे जरुरी ट्रेनिंग
Просмотров 1724 года назад
Pivot Table Complete Training Part 2 || Excel में नौकरी के लिए सबसे जरुरी ट्रेनिंग
Replace Text Function - Nested - Training Part 16
Просмотров 1744 года назад
Replace Text Function - Nested - Training Part 16
Replace Function in Excel - Training Part - 15 || Training by Himanshu
Просмотров 2045 лет назад
Replace Function in Excel - Training Part - 15 || Training by Himanshu
Pivot Table Tutorial - Excel का सबसे दमदार Tool | Interview से पहले इसे जरूर देखे
Просмотров 2935 лет назад
Pivot Table Tutorial - Excel का सबसे दमदार Tool | Interview से पहले इसे जरूर देखे
Concatenate Function Nesting with other text Function - Part 14
Просмотров 7105 лет назад
Concatenate Function Nesting with other text Function - Part 14
Concatenate Function in Excel - Excel Training Part 13
Просмотров 2525 лет назад
Concatenate Function in Excel - Excel Training Part 13
Math Function in Excel - Excel Training Part 5
Просмотров 1275 лет назад
Math Function in Excel - Excel Training Part 5
Cell properties in Excel - Excel Training Part 2
Просмотров 5395 лет назад
Cell properties in Excel - Excel Training Part 2
Excel structure - Excel Training Part 1
Просмотров 3205 лет назад
Excel structure - Excel Training Part 1
Close Multiple Excel File at one go | Excel VBA tricks
Просмотров 6625 лет назад
Close Multiple Excel File at one go | Excel VBA tricks
How to use a Dropdown to Switch between Charts
Просмотров 1985 лет назад
How to use a Dropdown to Switch between Charts
Clock effect Presentation in PowerPoint
Просмотров 1,1 тыс.5 лет назад
Clock effect Presentation in PowerPoint
How to know age in Excel use of DATEDIF
Просмотров 985 лет назад
How to know age in Excel use of DATEDIF
Do While Loop in Excel VBA - Macro - Part 30
Просмотров 1565 лет назад
Do While Loop in Excel VBA - Macro - Part 30
Powerpoint Infographics Amazing art technique - in Hindi
Просмотров 6705 лет назад
Powerpoint Infographics Amazing art technique - in Hindi
Loop Related Task Solution in Excel VBA - Macro - Part 29
Просмотров 1765 лет назад
Loop Related Task Solution in Excel VBA - Macro - Part 29
what if the column need to filter is not in pattern . for example column a has company name, product name and its size in below below cells and second company is in below cell but has 2 or more product and size below . how to filter it company vise
Thanks BRO!
It worked. Thanks
thanks
Thank You
How to save this worksheet
Thank you for for a lesson Mr.
I am getting an error of (run-time error '424': object required). How to rid this error?
Best tutorial, to the point. Works 100%.
It's not working
Thats Awesome. I have created an userform with this video for my daily business. My sincere gratitude to you
Thanks
For those that got the 1004 error: there should be 1 entry in the first row below your headers. In all the columns you're planning to populate.
Thank you ! It's bother me for three years, for god sake!
You are a gem! Thank you!
sir awaz bohat slow haay
this is amazing!! so concise, straightforward and complete for a person learning the Excel VBA Macro for the first time! keep up the good work!
Lovely
Thank you soo much this really helped a lot
Thank u very much
Thanks boss God bless i have done so many things but cant be successful until this thanks alot.
a masterpiece made 3 years ago. thanks. googled a lot, finally found the solution
That worked like a charm. Thank you.
Sir, thank u very much for ur easily graspable way of teaching strategy.. much appreciated...
thank you a lot
Thanks for fixing what windows decides to break for no reason at all.
the file is in my E not in C.. how can i delete it
how to give the condition in save button like " do you want to save the data?" and in my excel unload me is not working, when i put this command then whole panel will close.
Worked! Thanks!!!
Thank you for such a nice explanation. I have a small query. As per the code mentioned by you, I am able to create pivot table, but if I want that table to be sorted in descending order, then how. I tried but it's not working. below is my code. Dim datepivot As PivotTable Dim datecache As PivotCache Sheet2.Activate Set datecache = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("A2").CurrentRegion) Set datepivot = ActiveSheet.PivotTables.Add(datecache, Range("b2"), "Mypivot1") datepivot.PivotFields("Date").Orientation = xlRowField datepivot.PivotFields("Net Premium").Orientation = xlDataField datepivot.PivotFields("Net Premium").AutoSort Order:=xlDescending, Field:="Net Premium" Last line is the sorting thing, it's not throwing any error, but also not sorting. Please help.
Thank you Mr. Training by Himanshu I wrote it based on the questions in the comments. In order to record data; Headings should be entered in the first line, and records should be entered as if data were made in the second line. (Range("a1").End(xlDown).Offset(1, 0).Value = Range("a1").End(xlDown).Value + 1) ←this snippet persists the sequence number.
You may try this Range("a1048576").End(xlup).offset(1,0).value.. with this method a single entry is not needed.
thank you.
worked immediately. thank you
It deleted all the folders on my destop, I can't open my computer shortcut too, please help
Thank you so much. I was trying to find a way to do this on TypeScript but it would not show drop-downs.
Thanks so much. This issue has been bugging me for 3 or 4 years, you came along and solved it right away
Thanks sir
well done
it is showing as compile error : variable not defined in the sub trail_pivot12() line
Dear sir Thanks for this video Sir could you please help me 🙏 Sir i need to save and print the form it self on one page only Sir i try many times and i can't Sir what is the codes for this If you have vidio or link pls provided Thanks again
Thank you for the lesson
Followed like 5 tutorials, didn't work. This worked immediately, thank you!
Glad it helped
Followed like 5 tutorials, didn't work. This worked immediately, thank you!
legend thanks
सिलेक्शन कैसे किया जाता है
Himanshu, as I proceed and tried to run all the VBA formula it is showing debug to me with error "1004". What am I suppose to do to resolve this
It doesn't work on other drives. Works on just C drive files
None sense
By the way... Can I save one form entry to more than one row or to more than one sheet?
nice video, but your audio is very very low...
Thank you for a very educative session Himanshu 🙏