Spreadsheet software like Microsoft Excel is used by everyone from office workers to data scientists. Excel gives a lot of power to people working with data, but it can also be intimidating.
We've released a full course on the freeCodeCamp.org YouTube channel that will teach you how to use Microsoft Excel from the beginning. You will learn by creating 6 real-world projects. Most of the content applies to Google Sheets as well.
The course was created by Shad Sluiter. Shad is a professor of computer science at Grand Canyon University. Over the past 20 years he has taught students from grade 6 to senior citizens in many aspects of technology.
Excel is one of the most used tools in business, engineering, accountancy and many more industries. It helps you organize and manipulate a large amount of data which can be otherwise time-consuming, mundane, and difficult to organize.
If you are in the business sector, learning Excel is a necessity. It helps you manage inventory, human resources, and finances.
In this Excel course, you will learn how to:
- enter data,
- navigate through a spreadsheet,
- create formulas to solve problems,
- create charts and graphs,
- understand relative vs absolute references,
- import and export data,
- implement VLOOKUP,
- use pivot tables,
- split and concatenate text,
- and more.
![image-12](https://www.freecodecamp.org/news/content/images/2020/11/image-12.png)
While learning Excel, you will create the following six projects:
- Payroll
- Gradebook
- Decision Factors
- Sales Database
- Car Inventory
- Problem Solving Templates
Here is the free full-length Microsoft Excel course:
📺 Learn Microsoft Excel - Full 3-hour Video Course on YouTube.
Free Excel Courses and Tutorials
And here are a lot of other free Excel courses and tutorials you can use to master Excel. These answer some of the most widely-asked questions about Excel.
- Word Count in Excel – How to Check the Number of Words
- AutoSum Excel – How to Add Numbers with the Sum Formula
- Auto-Numbering in Excel – How to Number Cells Automatically
- VLOOKUP Example – How to Do VLOOKUP in Excel
![Excel VBA Tutorial – How to Write Code in a Spreadsheet Using Visual Basic](https://www.freecodecamp.org/news/content/images/2020/06/excel-1771393_1920.jpg)
And here are some Excel programming tutorials, if you want to combine Python and other programming languages with spreadsheets to automate even more of your work.
- How to create, read, update and search through Excel files using Python
- Excel VBA Tutorial – How to Write Code in a Spreadsheet Using Visual Basic
- How to Remove Duplicates in Excel – Delete Duplicate Rows with a Few Clicks
- How to Create Auto-Updating Excel Spreadsheets of Stock Market Data with Python, AWS, and IEX Cloud
- How to Build an Excellent Stripe Integration with Node.js: 4 Best Practices and Examples
- How to Generate an Excel Report in a Spring Boot REST API with Apache POI and Kotlin