Excel programming weekend crash course free download

Use the menus on the left of every page on this site. Each link takes you to a tutorial. There's plenty of screenshots to keep you on track, and exercises to complete to bring your skills along. Other Home and Learn courses We have lots more free computer course on our main site. Here's a list of what you can learn for free with Home and Learn Click a link below to go to that course :.

Beginners Computing. Microsoft Word. Microsoft Excel. Web Design. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. Visit your learner dashboard to track your course enrollments and your progress. Every Specialization includes a hands-on project. You'll need to successfully finish the project s to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.

When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools. This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel.

In this course Part 1 , you will: 1 learn how to effectively navigate around the Excel environment; 2 edit and format Excel worksheets; 3 implement basic to advanced Excel functions including financial, logical, and text functions ; 4 learn how to manage data sets filter, remove duplicates, consolidate data, sort data, and validate data ; and 5 learn how to effectively visualize data through scatterplots, column charts, and pie charts.

New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks modules. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment.

This course is unique in that the weekly assignments are completed in-application i. Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel.

By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 Projects ".

This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel.

In this course Part 2 , you will: 1 learn advanced data management techniques; 2 learn how to implement financial calculations in Excel; 3 use advanced tools in Excel Data Tables, Goal Seek, and Solver to perform and solve "what-if" analyses; 4 learn how to create mathematical predictive regression models using the Regression tool in Excel. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!

It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects open-ended with respect to the fact that they can be solved in multiple ways.

Each learner must complete 3"warm-up" projects chosen from 3 , 3 intermediate projects chosen from 6 , and 3 main more difficult projects chosen from 5. The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds.

For eg. Can you help me with that. You are a fantastic man to offer your services to educate those that need to learn about excel …. How refreshing it is to hear you speak not too fast, nor too slow in a manner that is clear and understanding. Thank you most kindly. Working alright at my end. Kindly help me how can I access these options?

I guess I need to upgrade excel with version. Is this a certification course? If not, then what should we do to get a certificate for our learnings? I created a link to enable the contents of Sheet 1 Cell A1 to appear automatically in Sheet 2 so that whenever I change the contents of Sheet 1, the same automatically changes in Sheet 2.

Question: How do I change the settings of my laptop at home to enable me jump from Sheet 2 to Sheet 1 upon double-clicking the link in Sheet 2, Cell A1, to enable me to go to the actual location of my data in Sheet 1? Hi Sir! Thank you for this three tutorial. What should I do? When you click on the gray bars on the page above, you will get the video that you can watch. Are you not getting any videos when you click on the gray bar?

Can you please try now? Also, refresh the page hold the control key and then hit the F5 key. This should fix the issue. Click on the link and then scroll down slowly, so you do not pass it up, until you see the box with the video area…. Sumit You are truly an MVP.

Your videos and instructions are fantastic, they are easy to understand, not cumbersome or a burden to watch and your instruction is simple and precise. I have used Excel for a very long time but each time I need an answer you are my go to search and instructor and it goes without saying I always find what I am looking for.

Are you as good in other aspects of the MS Suite or Master of one? Let me know. Thanks for your support. Paramveer Sidhu. Your website provides excellent insight in Excel which is very useful for every type of end user. Need your support on power query. I have gone through the video of merging multiple workbooks into one workbook. That was an interesting feature. However need to know one thing.

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, you have a heart for people and an understanding of their needs, I honour you for the gift that you are sharing with us, I pray blessings over any venture that you set your heart on. Thanks sumit … all videos are great and very helpful…. And again thank you so much, making this course free so that more people engaged to learn excel.

Thank you so much, making this course free will get more people engaged to learn excel the right way. Thank you Sir, I am delighted with your work.

Your hard work and dedication have brought positive changes in learning excel. Though i could not yet prepared excel sheet for fetching the fund mutual fund units from nse mf fund for my portfolio. I am trying to prepare requisit worksheet in excel Just discovered the cause of this problem: my Adguard blocker was stopping the display of the video.

AOK now. My adblocker was preventing the videos from appearing. When I turned it off, the videos appeared. Where are the links??? Best Excel Shortcuts. Conditional Formatting.

Creating a Pivot Table. Excel Tables. Creating a Drop Down List. Recording a Macro. VBA Loops. Privacy Policy Sitemap. Modules Covered in this Free Excel Training.

Lesson 1 — Getting Started with Excel. You can enter three types of data in Excel — numeric, text, and formulas. Apart from this, it also covers the auto-fill in Excel as well as number formatting. Lesson 3 - Data Formatting. Click here to download the example Excel file This video covers the basics of data formatting in Excel. Here are some of the common formatting I use to make my data look better and more readable Applying borders to all cells Making headers bold Giving a background cell color to headers.

Center align the headers You can find these options in Home tab in the Font category. Lesson 4 - Working with Cells and Ranges in Excel. And this video will teach you exactly that. Lesson 5 - Managing Worksheets.

Lesson 6 - Introduction to Excel Tables. In this video, I cover the following topics: Creating an Excel Table Excel Table features Structured references Table slicers Note that table slicers became available only from Excel version onward. Click here to download the example Excel file In this video of this Free Online Excel Training, you will learn about tools that can help you when working with data in Excel.

In this lesson, I cover the following topics: Autofill : This allows you to quickly fill data in contiguous cells. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse Flash Fill : Flash fill is a new feature in Excel and allows you to identify a pattern in data and perform data slice and dice based on the pattern Related Excel Articles: Fill Handle in Excel Flash Fill in Excel Create your own sorting criteria with custom lists Separate First and Last Name in Excel Using Flash Fill.

Lesson 8 - Number Formatting in Excel. Lesson 9 - Excel Formula Basics. Click here to download the example Excel file In this video of this Free Online Excel Training, you will learn how to get started with Excel formulas. Lesson 10 - Logical Formulas in Excel. Lesson 11 - Math Formulas in Excel. Lesson 12 - Lookup and Reference Formulas in Excel. Lesson 13 - Stats Formulas in Excel.

Lesson 14 - Text Formulas in Excel. Lesson 15 - Date and Time Formulas in Excel. Lesson 16 - Formulas Mix and Match 10 Examples. Click here to download the example Excel file In this video of this Free Excel Training, I will show you some advanced formula examples that involves using one or more than functions. Lesson 17 - Named Ranges in Excel. In this video of this Free training, you will learn about using Named Ranges in Excel. Lesson 18 - Data Validation in Excel. How to Insert Checkbox in Excel.

Lesson 19 - Data Sorting and Filtering in Excel. Click here to download the example Excel file In this video of this Free training, you will learn about data sorting and filtering in Excel. Lesson 20 - Using Conditional Formatting in Excel. In this video of this Free training, you will learn about the amazing conditional formatting. Lesson 21 - Introduction to Excel Charting. Lesson 22 - 10 Advanced Excel Charting Examples. Click here to download the example Excel file In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.

Lesson 23 - Dynamic Charts in Excel. Click here to download the example Excel file In this video of this Free Excel training, I will show you how to create dynamic charts in Excel. This video covers two detailed examples of creating dynamic charts from scratch Example 1 — Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.

Lesson 24 - Overview of Excel Pivot Table. Click here to download the example Excel file In this video of this Free training, I will show you how to create and use Pivot Tables in Excel. Lesson 25 - Protection in Excel. Is this course really free?

You get to watch each and every lesson absolutely free and as many times as you want. All you need is a decent internet connection. Can I download the videos?

No, you can only watch the videos online. These videos can not be downloaded. Which version of Excel is used to create this course? I have used the Excel to record these videos. Who is the instructor of this Excel training?

Thank you for your shared knwoledge! Very hepful to increase my knwoledge on Excel. Very strightforward and very good pace!.

Dear Mr Bansal I want to take this opportunity in thanking you for offering your services free to all. Can I get a certificat when I will finish this cours? Wow I love learning opportunities as this hope to really know this Excel. I want do that. How do I get the certificate after completing the videos?

May God bless your excel training. Do you receive a certification for completing the course? I am not receiving the tips ebook you are offering. Can I get certificate after I finished the course? The best, simplest and eastist way of learning excel …. This is the best online course i have ever found. Thank You and best regards from Bosnia. Do we get certificate at the end of this course? Osm Guidance in this video, Thank you so much to learning lots of new features.

Where are the exercises for each module to practice the lessons? Can I get certificate after finishing the whole excel course? Will there be any certification given at the end of the course? Can it be used better than tally for inventory management. This is so useful, so clear. Just like excel You are an Excellent instructor. Thanks for helping! Hello Sir, I am not able to play the videos.

They seems to be freezed. It may be your connection, try to hook to WiFi and try again. Hope that helps. Total how many hours does the course is? Can I get certificate? Yes they are, try to connect to WiFi and try again to access. Thank you so much Sumit for such a comprehensive course, I really appreciated it!

Great Job and I am learning every day as I watch one video per day. Hi I would like to start study excel When the course start? Will a certificate be provided by the end of the course? Is there any assessment that I need to give after completing the training? The organisation, time, effort and passion has to be really appreciated. Will we be getting certificate after completion.

Sir after completing this …can I have a certificate of this or not.. Sir I completed the course so would you please give me a certificate. Awesome course I learn lots of thing Thank you sir. Khupch chan information dili ahe purn upyukt asa course ahe excelcha. Thank you soooooo much for the effort Really appreciated. This is really good way to taught I really liked. Please I am interested in taking thefree Excel class.

Thank you very much, this really helped me a lot. Am new how do i get started and do you anything to show that someone did this training. Sir please tell us some assignments so we can practice after every lecture. May i learn the Macros in this Excel Program as well. Sir can u tell us some assignments so we can practice after every lecture? The language is so easy to understand the lesson. Are we getting any certification after the course completion.

Hello, Thanks for training and good experience and thanks a lot. I like all the videos and I have easily understood everything. It is very useful.

This is what I was looking for to learn in my life. Module 3, lesson 9. Could you help. Do we have to sit in one go or we have can do per day per video. I have learnt formulas in this online course… Usefull course. Can I get a Certificate after course completion. I am using excel. I need to improve……. Thank you for the course Sir, it is really useful. I found this Course very useful for me and suggest to others also. What about a sertificate after finishing for cv for work purpose. HI Sumit, I find your tutorials quite useful for many excel formula.

Libraries near you: WorldCat. Not in Library. Classifications Library of Congress HF M A58 eb, HF MA58 The Physical Object Format Electronic resource. Community Reviews 0 Feedback? Lists containing this Book. Loading Related Books.