Using number formatting options using a dialog box, Find Last Occurrence of an Item in a List, Creating Dynamic Named Ranges using OFFSET and INDEX formulas, Advanced Data Validation Tricks (such as Create Dependent Validation, Make Sub Headings in Validation, Disguise Numbers as Text, Creating Dynamic Drop Down List), Filtering and Sorting in Excel Data Tables, Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search). Please guide. I believed this free Excel Tutorials will help me a lot to land my home-based job. I think this could be one way to pay you back. I hope to learn the program soon though it is a bit too fast for me but you are very clear. I want do that. Hope that helps. You won’t be charged for anything. Thank you for sharing your knowledge with everyone. And there are many combination charts and advanced charts you can create to pack a lot of information in a single chart. I am your fan nowonwards. How to count that How much AHU, Chiller & Boiler’s point in my sheet. I will be glad I get it here. Cant believe so much detailed training and guidance for free. Many thanks for sending me emails. Grate work Mr. Sumit, I planed to take up an online program in Data Analytics next semester but indeed hope these videos would help me a lot. Any other feedback? 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? 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, And automatically update them in DIFFERENT EXCEL DATA AS PER SUBJECT, And different sheets having name and address according to subject like, Maths students Science students English students. By learning this course would I have completed advanced level or just basic or intermediate? I am struggling with an issue, I am unable to resolve myself and I hope you can give me right direction: In my first worksheet “dataentry” I have a column A and B, where column A is a dropdown list with numbers and column B is a dependent dropdown list related to column A. I have really found you to be clear and concise in your presentation. I must appreciate you ,you have prepared all the videos and that available for all. Is this because there may be high traffic? I have gone through the video of merging multiple workbooks into one workbook. It’s bravo and majestic. 1, it appears in every cell. Thanks for commenting… Glad you are finding the videos useful! Does this course come with a certificate? This is the best online course i have ever found. If you want to learn more about using formulas and functions in Excel or another spreadsheet application (such as Google Sheets), you've come to the right place! In this video of this Free training, you will learn about using Named Ranges in Excel. Learn how to use INDEX MATCH in this Excel tutorial. 0; 0 ₹ 0.00; Home; Courses; Dashboard; Student Registration; Cart; Checkout Excel templates. Since Excel has 1000s of features, they are grouped in to several ribbons. 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. Thank you so much for this course it is really helping me you are such a good person to do this for us all. Very appreciate for all you have done.!!! Can you please try now? Thanku sir for this wonderful excel videos but sir i want certificate with this so can you provide certificate of this or not? So I get a certificate for Thai training? When it is a good, properly laid, will make one’s home sitting on a solid foundation. Click here to learn more about Excel School Program. Do you get a certificate upon completion? Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. 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. Thank you very much, this really helped me a lot. What can i do for…? Thank you Sumit for an excellent training course! I can’t find any links to the videos. The reason is simple. It didn’t help. This is so user friendly. Dear Palak, Siri connected me to your excel Tutorial program and many thanks. Use Tables to handle data better, Introduction to Formulas Kudos. In case we have two worksheets on three workbooks with similar names, is it possible to merge into one having the end result as a combined workbook with two worksheets, Thank you Sumit.