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.

Proficiency in Excel increases your chances of securing a job. It can help you accelerate your career in many different directions, such as starting your journey as a data analyst.

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.
Source: xkcd

While learning Excel, you will create the following six projects:

  • Payroll
  • Gradebook
  • Decision Factors
  • Sales Database
  • Car Inventory
  • Problem Solving Templates

Watch the full course on the freeCodeCamp.org YouTube channel (2.5 hour watch)