

Each Excel workbook can contain multiple worksheets.Ĥ Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.ĥ Find & Select: Learn how to use Excel's Find, Replace and Go To Special feature.Ħ Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. When you start Excel, click Blank workbook to create an Excel workbook from scratch.ģ Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Learn how to use the ribbon.Ģ Workbook: A workbook is another word for your Excel file. Watch the full course on the YouTube channel (2.5 hour watch).This section explains the basics of Excel.ġ Ribbon: Excel selects the ribbon's Home tab when you open it.

While learning Excel, you will create the following six projects: understand relative vs absolute references,.In this Excel course, you will learn how to:

It helps you manage inventory, human resources, and finances. If you are in the business sector, learning Excel is a necessity. It can help you accelerate your career in many different directions, such as starting your journey as a data analyst. Proficiency in Excel increases your chances of securing a job. It helps you organize and manipulate a large amount of data which can be otherwise time-consuming, mundane, and difficult to organize. Over the past 20 years he has taught students from grade 6 to senior citizens in many aspects of technology.Įxcel is one of the most used tools in business, engineering, accountancy and many more industries. Shad is a professor of computer science at Grand Canyon University. Most of the content applies to Google Sheets as well. You will learn by creating 6 real-world projects. We've released a full course on the YouTube channel that will teach you how to use Microsoft Excel from the beginning. Excel gives a lot of power to people working with data, but it can also be intimidating. Spreadsheet software like Microsoft Excel is used by everyone from office workers to data scientists.
