I had the quiz question how many times does the number 3 appear between the integers I must appreciate you ,you have prepared all the videos and that available for all. Regarding printing I want to know how can I print bill format using data of various cells. My,my,my…I know we still have kind souls, we have just lost our way a bit in the world today. Knowledge is no good unless you share it. I will be taking your course. I sincerely thank you for your kindness.
Thankyou so much Sir for providing us such a valuable course free of cost. Your Teaching style and way of explanation is Fabolous. It helps me alot. I am now I like to convey my thanks to you for your philanthropic activity as a teacher in real sense. I was a teacher and hope to be a student of you very soon. Live long. Are these courses still available? Waaw Mr. This is a fantastic gift to all the human race. I planned to take up an online course in Data Analytics next semester, and hope this would help me a lot.
Your service is invaluable to me and I will be studying for 2 hours a week until October. Many thanks for sending me emails. Kind regards, Jeanne. Will you provide Certificate after completion. How much time it will take to complete. I am in intermediate status. Thank you so much!!! Out of my tight schedule and extra working hours, I took out some time to complete this course and it helped me tremendously to manage and analyse my data, along with it I could save hours per day.
I am grateful to you for making it available free and help people like me who struggle working efficiently without good knowledge of excel. I have recommended this course to my colleagues now. Many many thanks again. Hi sumit, thanks for giving such wonderful learnings at no cost. Will u please guide me for certification stages in excel and also best link to go for it. I would really appreciate ur response.
Thanks in advance. If not what books do you recommend to learn Excel for work? The courses offered and the way these are structured are meant to lay a firm and solid foundation to build upon. Everybody builds their own home on a foundation. SB has taken time, mastered the Excel, excited by its capabilities, organised it and prepared to teach his students in a simple and direct way.
Bansal, Pranam to you, as a teacher who put in all this time into these video courses and offering it for free. I bow to you for your kind heart. Goddess Saraswathi has blessed you, may her blessings be showered upon you into the future, so we all get at least a part of those blessings. Hi Sumit! Thank you for this! Question …is there a file to download to follow along with the videos? Will start with your videos here , thank u! This is so user friendly.
For someone who has never been able to use Excel, your training is just so simple and easy to understand. This is beautiful. I enjoyed the training and with this excel training, i can say that i now understand excel at some extent. Many thanks to the instructor. Thanks you so much ,sir. I am from Pakistan. I learned a lot from your videos. Kindly share me the procedure to get excel notes if you prepared according to the video you published. Good effort. Contains are clear and crisp. Course is Advanced, I will highly recommend this to Computer teachers who wants to clarify their doubts in excel.
I have to learnt data entry and number formatting with excell. In module 2 I learn to auto fill , custom list. And excell is spread sheet program include in the Microsoft office suite of applications it is also soft ware program.
Is there any way to help me? I am desperate. May be if start watching this video daily I will learn more new about the excel thank you so much for providing this free of cost course. Why is Trump name on this course? How is President Trump associated with this course?
If he is not, why did you put his name on it? This course and the site has nothing to do with anything except Excel. I think this was an excellent video on excel I really appreciate the efforts who had made so easier to learn excel. Contains are clear and chrisp. Now after learning so many things through video I feel so confident and happy now I have to rush to take help of anybody, I will keep practicing and learn more and more to enhance my excel as a superb skill.
Thanks you so much to all those who had given great platform to learn the Excel and various things….. Thank you Sir, it is very useful for me to know about Excel as I am working on Excel in my office and it will be very useful for me.
Hello sumit sir, I am writing this to Thank you for providing such great lessons. They are very few people left around us who provide education and great learnings for free. I am disappointed for finding this site a bit late. Thankyou so much for your knowledge and efforts Sir. Dear Sumeet Sir, Can you explain a bit more about Vlookup for the last example in the given where you were T is higher lower, Really I got confused ,It has been asked for T why it is giving data for jane?
I enjoy and learn a lot from your Excel course. Wonder you have free online course for Microsoft word training just like this excel course. May God bless you my brother. Thanks for sharing your knowledge.
My name is yunus be in touch Kerala. Thank you very much. This training has helped me a lot and I am so grateful. I have been looking for an Excel training , tried to buy from Udemy several times but could not complete the transaction due to some restrictions in their payment system which does not allow a credit card issued in a different country. Well, this was before I came across your page and started learning.
Having gone through several videos and other trainings, I can honestly say that your training is one of the best structured and delivered. Thanks a lot. I was literally looking for an excel training opportunity for teacher professional development. I had my wallet out ready to pay. Your training is above and beyond structured and easy to follow. I would have paid hundreds of dollars for this training. Thank you for sharing your knowledge and talents!
I found it very useful, really appreciating Mr. Sumit for your valuable contribution. Keep it up……. I find your tutorials quite useful for many excel formula. I have a unique situation. I would like to seek your help. Is there any way that I can reach out to you and share the soft data Dummy and seek solution.
This is related to vlookup. These courses sound great. However, nothing happens when click on any module. Is this because there may be high traffic? Do I need to access via google or IE? I am using your free 26 lessons program to learn Excel. Thank you for the very informative videos. Is there anywhere I can do practice exercise? I thank Mr. Sumeet Bhansal for giving me such a lucid training where in got to know the easiness in understanding the excel formats quickly.
Good Job… Thanks a lot…. I appreciate the downloads you provide with each lesson so that I can switch screens and practice while you are teaching. Also, you have organized these beautifully in small sections so that anyone can take a quick lesson in between other projects.
Sumit -the way you explained formulas its amazing. I am your fan nowonwards. Dear Sir, I need help in conditional formatting. In a column A there are a number like for different row ,,,,,, … I would like to high lite the number for value is red either if it is or for all combination , is yellow similar like all combination, and is green or Please help. Thank you.
It is a pleasure to have the opportunity of learning this courses free and I hope it will be a successful experience. Dear Mr. Sumit, I need a small solution for my Xl Table I need to change the Data Rate of Interest in the cells in one column for a particular period in another column to only Kindly help me solve this problem Regards S D N Murthy.
Where is the company located? Is there a phone number where I can contact anyone if necessary? How long have your company been in business? What is the name of your company?
I am an Excel trainer who shares tutorials and videos online. You can reach out to me at sumitbansal trumpexcel. Hello Kimberly… Yes, the course is free. Just click on the video and watch. Is there any free online course work that can be done by the person on hands learning to be learning by doing? Many thanks. Just wanted to say—Sumit, Big thank you for taking time for providing these free online training courses.
God bless you. This is the best course on the internet!! I need to develop a tactical crime analysis matrix using a spreadsheet. The matrix will contain 10 records rows and 16 variables columns.
I have a list of crimes. Would you please demonstrate a sample of this. Congratulations Sumit Bansal for this exceptional work!
It is really fantastic to have access at this great content. There are so many things you can do by just using excel properly! Do you mind if I make a post regarding your site on LinkedIn or on twitter? Hi Pooja… There was some minor update going on which prevented the videos from loading. You can watch these now.
There is no restriction. I will jump to the third and hope the 2nd returns. Hello Morgan, There was some minor update going on which prevented the videos from loading. You can watch all the videos now. I have really found you to be clear and concise in your presentation.
It is very easy to follow and is a great brush up for my rusty skills. Thanks you!!! There used to be a feature in excel that let you send the sheet to a list of people to add data in a sequence — is this still available? We glad to have this guide for our reference to learn the Excel free. Thank you in advance… I am working in excel from last 7 years, wanted to learn more 1 passionate about excel 2 need a better career growth, let me start with this, if require will take help further.
I have a small problem with vlookup i am getting few errors on few cell and i am unable to solve the issue can u pls help me. Hello I want to create a business cards alphabetical file Is there any tips you can give me to make it easier. Just click on a video and start watching.
I feel you are doing charity on the behalf of excel. Sir I salute you. God may bless you through your ahead intiatives. Thank you, sumit bansal. Hello sir, thankyou so much for free excel online training materials. This will gonna really helpful to people who want to learn excel online for free.
I would like to know is there any Certificate available after compilation of this course? I Have Data in sheet.
You can get it from pivot table, select d whole data, go to insert top left side you will get pivot table option. I promise to recommend it to friends too. Thanks a lot for this free excel training course.
Never thought that i can learn so many things in this course. My confidence level has gone up now. I was looking for a way to learn Excel for free.
I just lost my job and I see that most of the companies require knowledge of using Excel. I will let you know my results when I am done here! Nothing to do enroll. All things are in front of your finger tips, start with praying to sumit bansal and keep going, rock on.
Thanks Sumit for your excellentwell-paced method of teaching the basics in excel. I was just asking my son for some assistance when I found your video. This has given me hope that I may be able to pursue your advanced Excel course if I master the basics. O I am so excited! Really appreciable sir, you are extremely brilliant, and really doing good work for helping student in excel tutorial, each and everything you are making clear to student in each video even tiny things you are covering and your voice is so clear and very simple way to make understand.
Thanku sir for this wonderful excel videos but sir i want certificate with this so can you provide certificate of this or not? For certificate you can go through udemy!
Course,, if you are willing to get certificate, thank you, rock on! This is the most helpful teaching website regarding excel I have come across online. Your teaching style is really passionate, your way of explanation is very clear and you obviously deserve a load of respect and appreciation.
It helps me a lot in better understanding excel, and also motivates me to dive deeper into further learning. Thanks very much for tutorials, I like to know if there is a way to make just a cell behave as a normal calculator. This other cell will be the key-in cell or active cell. Kindly share a video if this is possible. I have searched online and came across your youtube video tutorial on how to count color using function and macro module programing in excel.
I am traying to count the highlighted cell that contains a specific numbers inside of the cell highlighted in color using your code. What should I change to add the values inside of the cell instead of 1? I would like to learn the importance of this course which helps me in resume as an addon and can be fast in computer operations with Latest knowledge.
Yes, Sumit it is exciting to Join with your Free Excell training videos. I learnt a lot and appreciate your Teaching skills. It is so easy to understand each step as you move forward. Thanks and Blessings. Great work. Hello I am reviewing your free excel training course. Does your course offer practice after watching the videos? I am trying to give this to my employees.
However, I would like to give them a practical test to be sure they went through all training modules. Could you help with this?
I tried to clean data by using the methods suggested by you in one of your lesson. But could not successfully clean certain data sets. How can I send it to you for your help? I receive more knowledge related Excel thinks you if you have other levees of excel send me linked.
I feel very happy not only to be enriched with learning Excel tips by you but also to be enjoyed by your way of imparting training. How can I be able to download the book? Please suggest me. Excellent Sumit! I truly wish to appreciate your way of teaching and effort you put in while creating these videos. I learnt a lot. I have a folder in which I have approx photos and want to search old photos of same person i clicked today.
Hi, Im subscribed to a mail list for 31 videos [Excel Video 8 of 31] today buy i want to subscribe a friend but I dont see where he has to click to subscribe to the list.
Can you tell me what he neds to do? Thank you Sumit for giving us your time and teaching us Excel. I am subscribed to your YouTube channel. The Excel in two minutes series contains nine parts. I am unable to access parts five through nine because they are listed as private. If this is in Error will you correct it so I can view those videos please?
Can you try again Rose? Can you help me with this Any suggestions? Hello Courtney.. You can find the videos as soon as you click on the gray bar. Good morning. I am having the problem where no video pops up when gray bar is clicked. Any suggestions? Hi I have hundreds of rows and I want to multiple select rows over 10 columns with bold fonts only, I saw you video on filtering cells that contain bold font, do you have similar for rows with bold font instead of cells? Hi… your videos are very detailed and very helpful…thank you for all your efforts in sharing your knowledge..
Just seen 4 of them today intial ones and its superb, no need to go anywhere. Simply and Easiest way to learn excel from Sumit Bansal. I want to know If i want to create a data for my students in which i have name ,address,phone and email And categories them using Drop down feature according to their subject.
Buy for business. Get the Excel mobile app. Send now. Your message is being sent. Your message has been sent, please check your device shortly. Your message has been sent, please check your email shortly. We're sorry, an error occurred while sending your message. Please try again shortly. Please enter a valid digit phone number. Format: or email address. That email address is not valid.
Please enter your email address in valid format such as name example. How your phone number or email address is used. Microsoft will use your phone number or email address only for this one-time transaction. Standard SMS rates may apply. Share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. With Microsoft , work within an Excel file from mobile, desktop, and web. Linked data types powered by Wolfram offer teachers and students real-time academic and goal-settings data from trusted, online sources.
Explore data types. Plan and track your health. Tackle your health and fitness goals, stay on track of your progress, and be your best self with help from Excel.
Get healthy. Support for Excel has ended. Learn what end of Excel support means for you and find out how you can upgrade to Microsoft Get the details. Work with stocks and geography data. Turn your data into insights.
List of all Excel functions available. IF function.
0コメント